Aug 09 2022 04:29 AM
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