Create Your Own Excel Stock Research System Using Quandl Stock Data
In my post Quandl – Download Free Amibroker End Of Day Data, I had discussed how you can download free end of day data for Amibroker. In this post we will discuss how you can download quandl stock data and use it for creating an excel stock research system in no time.
First go to Quandl site and create a free account. Next visit the Quandl Excel Add-in page by clicking HERE. Now, please download Quandl excel add in ad shown here. Download and install the Excel add-in that matches your Excel version (32 vs 64 bit). Download and install Visual C Redistributable from THIS LINK. Verify 10.0.50903 version is installed (to check that it installed properly).
Now visit the quandl API page by clicking HERE. Scroll to below of the page where it is written “Sign Up Now For A Free API Key”. Click SIGN UP.
Create a new account OR sign in with your existing quandl account. Go to account profile by clicking HERE and note your Quandl API key.
Now run microsoft excel. It will show that Quandl add-in is being loaded.
Once excel is running you can see a new tab appearing in your excel sheet called Quandl. Click that tab. You will be able to see tabs Get Data, Refresh Sheet, Refresh Workbook, Stop, Formulas, Settings, About and Check Update.
Click on SETTINGS. Input your API key here as shown below and click SAVE.
Now your excel is ready to import Quandl stock data. We will import a sample stock data so that you can do your excel stock research. We will download RELIANCE symbol data. Click on GET DATA tab. Click STOCK DATA –> INDIA –> STOCK PRICES, CURRENT AND HISTORICAL. On right pane select FREE NSE NATIONAL STOCK EXCHANGE INDIA. Click NEXT.
Now you can see all symbol name. Select RELIANCE INDUSTRIES LIMITED, click NEXT.
Choose the data fields that you want to import. Available fields are Date, Open, High, Low, Close, Total Traded Quantity, Turnover (Lacs). Click NEXT.
Select DATE RANGE, select DATA MANIPULATION FREQUENCY etc and click next. Select to include headers and dates. Click INSERT.
RELIANCE symbol data will be imported in your excel as shown below.
You can use this Quandl stock data to perform your excel stock research OR build a trading system easily. You can ask your questions in the comment section below.
Indrajit is a professional blogger and Trading System developer, Amibroker expert, Wordpress expert, SEO expert and Stock market analyst. Trading since 2000, he has started the journey of StockManiacs.net on 2008. He follows Indian and world stock markets closely.