Stop tiring yourself programming while there is no-code
TABLE OF CONTENTS:1. Introduction
2. Getting market data directly to your Excel file:
i) Installing the Excel Add-In
ii) API key registration
iii) Extracting Historical or End-of-day stock data
iv) Extracting Fundamentals data
3. Closing Notes
At the time when I was getting started with APIs and how can it be used to extract market data, I could say the learning process was a bit exaggerating because it was difficult for me to grasp the API-related concepts, and not to mention, coding the entire thing from scratch adds even more bitterness. This is not only applicable to APIs but anything related to programming.
But as everyone says, times are changing. At present, you don’t have the necessity to learn everything about programming in order to create something of your own but just the basics would do it and the rest can be taken care of with the help of the so-called ‘No-code tools’. To me, this is a revolutionary idea that enables its users to create their desired project without any coding. With the assist of no-code tools, people can save a tremendous amount of time spent on learning to code.
I’m personally a huge fan of these no-code tools and when I heard the idea of using such tools to extract market data, I was over the moon. In this article, I’m going to explain how the EOD Historical Data’s Excel Add-In can be used to extract both historical data and fundamental data with just a few clicks. Without further ado, let’s dive into the article!
Note: This article is intensely based on the Excel Add-In feature provided by EOD Historical Data. So to follow up with the upcoming content without any distress, make sure that you have an account for yourself as it enables you to access your private API key. You can create an account using the link here. Also, the feature represented in this article may not be free but a subscription is needed. View the pricing of all subscriptions here and choose what best fits you.
The first and foremost step of this process is to install the EOD Historical Data’s Excel Add-In for historical market data and fundamental data. All you have to do is to click the link here and the installation will start automatically.
After successfully installing the Add-In, you can now be able to see the custom EOD ribbon tab on the top-left corner of Excel. Now the next step in this process is to register your API key in order for the Add-In to function. To register, head over to the Limits group and select the Set API key option.
After selecting that option, a new window pops out where it requests you to enter the API key. After entering your API key, you can hit the Save button to register it. We are now set to extract some data!
Extracting Historical or End-of-day stock data
To extract the historical data of stocks, we have to first navigate to the Get historical data option under the Commands group. After selecting it, a new separate window pops up which looks like this:
After observing the new window shown above, it can be said that it is just an interface to enter the required inputs for extracting the historical data.
The first input is Tickers where we should enter the symbol of the stocks we are willing to extract the data. It can either be a single stock or multiple stocks but the important thing to be remembered is that the tickers must be mentioned along with the exchange. If that is a bit confusing, you can opt-in to the find ticker option where you can search for stocks.
The second input is Period where we have to specify the time interval between the data points. Daily time interval is the default period but there are other options to choose from like Weekly, and Monthly time intervals. The final two inputs are the from and to where we have to enter the starting date and ending date of the historical data respectively.
After filling out all the necessary inputs, we just have to click the Load button, and voila! You will have the historical data of the stocks you mentioned along with a beautiful candlestick chart for helping us make more sense out of the data. When multiple stocks are specified as inputs, different Excel sheets will be created automatically, each having the corresponding stock data. Here is an example of how the final result would look like: