Chapter 65

Importing past stock prices, exchange rates, and cryptocurrency prices with the STOCKHISTORY function

Questions answered in this chapter:

  • How can I use the STOCKHISTORY function to import past trading data on a stock?

  • How can I use the STOCKHISTORY function to import past Bitcoin prices?

  • How can I use the STOCKHISTORY function to import past data on currency exchange rates?

  • Can I use the STOCKHISTORY function to import past data on index or mutual funds?

  • Can I use the STOCKHISTORY function to import past data on commodity prices?

Answers to this chapter’s questions

How can I use the STOCKHISTORY function to import past trading data on a stock?

If you have Office 365, you should now (or soon) have access to the amazing STOCKHISTORY ...

Get Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial