How to Automatically Integrate Financial Data with Google Sheets
HTML-код
- Опубликовано: 8 июн 2024
- @MattMacarty
Use a free add on to access data financial data from around the world.
For more information about our sponsor please visit:
lumiwealth.com/macarty
0:00 - Introduction to EODHD Financial Data APIs with Google Sheets Add-In
✅ If you are interested in subscribing to a data bundle from EODHistoricalData, use this link for special pricing (I get a referral):
eodhistoricaldata.com/alphabe... _sheets
In this video I'll show you how to automatically download Stock Price Data and other Financial information into a Google Sheet with the EODHD Google Sheets Add-In.
Without any complicated code, you can easily get:
• Fundamental data for Stocks, ETF, or Funds
• End-of-day historical data
• Intraday data
straight into a Google Sheet, where you can perform any Financial Analysis, you want to do.
0:26 - Sponsors integration
00:13 - Quick start
To get started you'll need to:
• Log into your Google Sheets
• Start a blank worksheet
• Prepare to install the add-in
00:54 - Installation
To begin the installation, you'll need to do next steps.
• Follow the link to "Install our Google Add-in" workspace.google.com/marketpl...
• You'll see the icon Google Sheets Financial add-in on the right menu
• If you don't, then just start a new sheet and it should show up
• Just click on it and you are ready to activate the Add-in
• Next what you'll need is to Register an Account here eodhistoricaldata.com/registe... _sheets
• Or if you already have an account Log In, to get your API Key and insert it into the Add-in's menu
• Once you've done that, just click the Get Data button
00:58 - Get the Financial Data Options
Click on Get Data button and you'll see the set of options with the different Data Feeds that are available to us:
• End-of-Day Historical Data
• Intraday Historical Data
• Fundamental Data
• Bulk Fundamental Data
• ETF Data
• Options Data
• Stock Market Screener
02:26 - Get End-of-Day Historical Data
To start off doing something simple and we'll get some End-of-Day price data, I'll get it for Apple Inc (AAPL.US)
03:22 - Get Intraday Historical Data
If you want, you can get it down to one-minute increments with the free account, it's going to be a day-delayed. You'll get yesterday's intraday trading prices where it works the same way as the daily data does, so I'm not going to demonstrate that.
03:48 - Get Stocks Fundamental Data
I'm going to just stick with Apple Inc (AAPL.US) here and we'll get that.
04:13 - Bulk Fundamental Data for Stocks
If you have a list of symbols, you can kind of feed them or choose a specific exchange to obtain the tickers data of it.
04:31 - Get ETF Data
You can easily get ETF data directly into your Google Sheet.
04:34 - Get Stock Options Data
I'll use Apple Inc (AAPL.US) again and I'll specify 'From' and 'To' to obtain all the Options for October or if you want to go out to the regular expiration, you can set in any data slice.
You'll see that data comes back pretty quickly and the results are placed into the subtotal.
You also get some implied volatilities here, so some high-level statistics are available too like the put/call ratio and that kind of thing.
05:55 - Find Tickers With the Stock Market Screener
You can just use it to download all the symbols in an exchange.
You can create your personal screener presets by choosing from a lots of options.
07:07 - Conclusion
Hopefully that helps you to get started with EODHD APIs to download and then manipulate data however you like in a Google Sheet.
Matt you have the most listenable voice and training style I've heard in a while, it's actually therapeutic
Wow, thank you. Can you tell my kids? ;)
@@MattMacarty lol, I'll bet it's different at home then ;)
Amazing work. I have a question about making one for Forex Trading and if you can fetch and parse data like bank interest rates, GDP, inflation number and export for the major 8 currencies around the globe. Perhaps possible to fetch the data from Yahoo Finance page. I would like to hear from you in this regard. Thank you.
EOD may have international data, but I am not sure. You can get us rate from the federal reserve board. Currencies should be available on EOD.
Tutorial with audio and easy to listen to, thank you. Unfortunately when I click get, it only creates the column headings, I don't even get an error, just empty cells and no sign of Google Sheets progress bar working on anything. My API key is entered already. Any help is appreciated.
Not sure what is happening there. Are you using Chrome? Maybe checl with EOD to see if they know that problem. BTW there is also a plugin for Excel which I think works better
Great explanation, thank you
Thanks
Is there a way to pull my account balance, PnL, % gain fir the day and make a line chart in sheets?
Yes but this will depend on the vendor. Most of what you want I would add as calculated columns after pulling a balance.