Google finance intraday live data into Exel sheet

[jagankris]

pls provide brokers name for neat terminal i only know sharebazzarinfo
thanks

HI

why to get live data in exel form from google or yahoo or esignal or roguters?:annoyed:googel ,yahoo ,esignal ,routes is still secondary data sourse.best take free live excel data from primary data direct NSE software NEAT u can also get many data live in excel like ATR AND opeintestdata. in NEAT..open one trading accout to those broker who gives NEAT trading termianl to all clint.(neat is easily abailbale now ).
throgugh google u can download last 15 days intrday data..in csv (yahoo gives only only 5 days) but as far as i know google sourse is not live

now if u want to expert thise live data in ami or ms then solution is also abaliable in market use neatplugin for ami

Pls confirm if Neat is "NOW" - Neat on web.

Thanks,
JK

 

[sln1941]

Hello Members,

For those interested and not able to switch on TV or do not have TV to keep update on markets .

This can be viewed now on your Computer. called MTTV.

Here is the link for live tv from Moneycontrol.
http://www.moneycontrol.com/tv/index.php (Copy& Paste)

Thanks
Alok Urs

You can also get ndtv profit on Air through Computer at the follwoing link:
http://www.ndtv.com/video/live/channel/ndtvprofit
The advasntage of this channel over moneycontrol My TV channel is that Nift, Nifty future, Sensex are flashed one after anothewr in this TV wheras even Nifty spot figures are not given in MYTV. Similarly ETNOW channel can be watched at the folowing link:
http://economictimes.indiatimes.com/etnowlive.cms

 

[amit_k2100]

murthy,
you can get the google quotes in google spreadsheet very easily. heres a sample

http://spreadsheets.google.com/ccc?key=0AobjP3YUJDfWcl9UZUdxNTg4b1hiaGRHRG5PeDAwZ0E&hl=en

this will get the quotes for google

last
=googlefinance("goog","price")

% change
=googlefinance("goog","Changepct")

prev close
=googlefinance("goog","closeyest")

hi there, here u have given google spreadsheet for getting live rates which is very easy and good.....thnks for this.... but its 1 min refresh interval....cant i have tick by tick ?

any other kind of xcel spreadsheet either from yahoo or nse or google , where i can have tick by tick ?

 

[negidude26]

Hi,

I have uploaded a youtube video on HOW TO FETCH LIVE data from GOOGLE FINANCE or any other site.

http://www.youtube.com/watch?v=sr1nJboLb-o

Please watch and I hope i solved the original query.:thumb:

 

[jans]

Here's a spreadsheet with VBA that imports intraday prices from Google Finance
http://investexcel.net/free-intraday-stock-data-excel/

It also transforms the weird Unix-based time stamp to a readable Excel date and time

 

[Vipul_84]

This utility is still working :thumb:

Here's a spreadsheet with VBA that imports intraday prices from Google Finance
http://investexcel.net/free-intraday-stock-data-excel/

It also transforms the weird Unix-based time stamp to a readable Excel date and time