Dear Friends
I came across one of the blog. They give below link to get 30 min data(nifty spot) from google finance.
=ImportData("http://www.google.com/finance/getprices?q=NIFTY&x=NSE&i=1800&p=2d&f=d,o,h,l,c,v&df=cpct&auto=60&ts=1266701290")
Just open the google spread sheet and paste in A1 column. We will get the data.
Using this we will calculate SH's Calculations. Please help.
Please see the link
https://docs.google.com/spreadsheet/ccc?key=0AjkHw_ormZBjdG5aWHVkN3psLVZtUlljQ0xla0JvT0E
Suggestions are welcome.
I came across one of the blog. They give below link to get 30 min data(nifty spot) from google finance.
=ImportData("http://www.google.com/finance/getprices?q=NIFTY&x=NSE&i=1800&p=2d&f=d,o,h,l,c,v&df=cpct&auto=60&ts=1266701290")
Just open the google spread sheet and paste in A1 column. We will get the data.
Using this we will calculate SH's Calculations. Please help.
Please see the link
https://docs.google.com/spreadsheet/ccc?key=0AjkHw_ormZBjdG5aWHVkN3psLVZtUlljQ0xla0JvT0E
Suggestions are welcome.