Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
529 views
in Technique[技术] by (71.8m points)

Using Google Sheets to import the last 5 Days of Daily Open, Close, High and Low Prices from GoogleFinance. "CURRENCY:EURGBP"

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

Please log in or register to answer this question.

Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...