How to Automatically Integrate Financial Data with Google Sheets
@MattMacarty
Use a free add on to access data financial data from around the world.
For more information about our sponsor please visit:
https://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):
https://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" https://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 https://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.
Смотрите видео How to Automatically Integrate Financial Data with Google Sheets онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Matt Macarty 07 Октябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 5,875 раз и оно понравилось 68 людям.