stockhistory function doesn't work with indexes

Occasional Visitor

Hello everibody

i 'm triyng my first formulas on excel 365 personal

i need a list of the prices of an index like "Dow Jones " or S&P500...

and i wrote this formula :

=STOCKHISTORY(A1;A2;A3) ....where A1 is 1/1/2019

                                                           A2 is TODAY()

                                                           A3 is DJI 

but it returns the error "#CONNECT!"

instead if in A3 i insert the code of a stock like AAPL it works

 

0 Replies