Here is an yet another interesting python tutorial to fetch intraday data using Google Finance API , store the data in csv format and also plot the intraday data as candlestick format. We are using plotly library for plotting candlestick charts and pandas to manage time-series data. Luckily found and interesting python code which fetches google intraday data and store in csv format. Done some little modification in the code (exchange added to the Google API) so that one can fetch data for any exchange.
In our example we try to retrieve the data (Date,Time,Symbol,Open,High,Low,Close,Volume data) for RCOM (Reliance Communication) and plot as candlesticks using plotly library. Download the sample RCOM CSV file fetched from Google Finance
[wp_ad_camp_5]
Sample IPython Notebook using Plotly and pandas to plot Interactive Intraday Candlestick Charts using Google Finance API :
In the next tutorial we will be discussing how to push intraday data to Amibroker software using python .
Hello Rajendran,
Thanks for this tutorial. One question though, Is there in value addition in learning python if one is already well versed in AFL? What are the benefits of python over AFL?
Thanks,
Snehil
Go thro this you will find the limitations in Commercial Trading softwares
Any pointer on how I can display these python processed graph on html webpage.? Secondly, Can python script be ran dynamically according to action on my dynamic webpage. I am not aware of Python yet and always use JavaScript, you guide may push me to learn Python.
You need to explore the web frameworks like Django, Flask, tornado
Any thing that we can cut and paste and use for illiterate’s like me? If you have any such thing please put it up. thanks.
Dear Rajendran,
Is there any limitation of no of scripts to fetch the data from google and feed in ami broker.
Dear Rajendran,
I have a query if you support it will be very much useful
In the above code i would like to plot the candle for 1hr 2 hour how to do that? is there a way.
I want 1hr starts from 9.15AM 10.15AM 11.15AM like this not from 10AM 11AM etc.
Please feedback what parameter i would need to change to get the same
Hello Rajendran,
The code has stopped fetching data since last 2-3 days. It returns a 0kb file. Can you please look into it?
This doesnt work any longer. The URL must have changed. Am getting HTTP 403 error.
Google stopped providing Free APIs