Willow Tips

Tip #2000-8: Grab a single historical price

Adding the INDEX function to get a single value from an array

The INDEX function allows us to grab a single price from the array. The second argument of the function (in this case 10), retrieves the 10th item from the array: the FTSE price 10 days ago.