Forum Discussion
Dastrade
Aug 09, 2022Copper Contributor
stockhistory function doesn't work with indexes
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
No RepliesBe the first to reply