Excel Array Formulas can be difficult to edit.
This video shows you how to modify the range over which an array formula is defined.
For other interesting videos on how to work with Excel in the context of financial applications, please visit https://www.deriscope.com
In particular, Deriscope can help you to access real time stock prices, foreign exchange rates, bitcoin prices and historical data all over the world for free.