If you were on Reddit around the time of the GME craze, you’ll probably recall everyone coming out of the woodwork to release their take on stock analysis spreadsheets. So clearly I’m late to the party. There was a general uptick in interest around the stock market after what was an unheard-of bull run during the (post?) covid recovery.
Unfortunately, they only ever seemed to su pport the U.S. market, and as I’m from Australia 🇦🇺 none of these worked for me. That basically sums up why I built this sheet, and how I would end up building a new, financial data API from scratch.
At the very top of the Analysis tab is where we’ll start. Here you’ll enter your desired ticker to lookup. What about the Exchange Code cell? Because we can lookup symbols from multiple exchanges, and some of those symbols exist across multiple exchanges, we have to tell the API which exchange we should retrieve our symbol from. In the case of the NASDAQ and NYSE no exchange code is needed, however, if we wanted to lookup Delivery Hero, ticker symbol DHER from the German XETRA, we would have to add that markets exchange code, in this case, .DE, and so DHER, becomes DHER.DE.
There is a table in the GUIDE tab of the spreadsheet with details about what exchange codes to use for what markets. If in doubt, our API follows the same naming convention as Yahoo Finance. Whatever ticker Yahoo Finance use, the API uses.