I hope you are well and keeping safe in these times.
This problem I have been facing trying to get Google Sheets to run smoothly has been annoying me for a while now but I can never get this to work. I need help!
On Google Sheets, I am trying to pull the data from =GoogleFinance but I keep getting errors.
I tried this simple code to start getting something but it never works.
=GOOGLEFINANCE("CURRENCY:EURGBP", "OPEN", TODAY(),)
Then I need to figure out how to get the last 5 days worth.
How do I get the 5 days of prices for the Daily Open, Close, High & Low so I can run some calculations?
If you can get me the correct formula I will be very thankful.
Happy New Year
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…