Google finance intraday live data into Exel sheet

Thanks Sir...
:thumb:

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

The following types of market data are currently available:

* price: market price of the stock - delayed by up to 20 minutes.
* priceopen: the opening price of the stock for the current day.
* high: the highest price the stock traded for the current day.
* low: the lowest price the stock traded for the current day.
* volume: number of shares traded of this stock for the current day.
* marketcap: the market cap of the stock.
* tradetime: the last time the stock traded.
* datadelay: the delay in the data presented for this stock using the googleFinance() function.
* volumeavg: the average volume for this stock.
* pe: the Price-to-Earnings ratio for this stock.
* eps: the earnings-per-share for this stock.
* high52: the 52-week high for this stock.
* low52: the 52-week low for this stock.
* change: the change in the price of this stock since yesterday's market close.
* beta: the beta value of this stock.
* changepct: the percentage change in the price of this stock since yesterday's close.
* closeyest: yesterday's closing price of this stock.
* shares: the number of shares outstanding of this stock.
* currency: the currency in which this stock is traded.

Dear Senior Members,
Please explain how to load that Google real time data into Metastock and make it refreshes automatically .
Is it possible to use Openoffice Calci instead of Excel ?
If possible explain with screen shots please,
Thanks.
Best of Luck

dear,
i am receving this message when i click on this link.
We're sorry, [email protected] does not have permission to access this spreadsheet.
can you please, give me permission.
tnx,

dear,
how to make refresh.....

how do u refresh and ge real data ,u have just given an excel file .Plz dont post rubbish
This is the closed i have come 1 min intraday backfill on google
http://www.google.com/finance/getprices?q=IBM&i=60&p=10d&f=d,o,h,l,c,v
where q =stock name
i=time interval

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

Hi friends!

Please open attached excel sheet. There is example of downloading data from nseindia.com. It automatically refreshes data after every one minute.

PLEASE NOTE IF U WANT TO UPDATE PIVOTS FOR NEXT DAY THEN SIMPLY CLICK ON PIVOT BUTTON AT EOD ONLY. NEXT DAY PIVOT WILL BE READY.

DATA IS DELAYED BY 5 MINUTES APPROX.

Hi Ravinder,

I could not find any attachment to your post. Can you or any other member of traderji re-post the attachment or mail me at narritu@g m a i l.c o m.

Thanks & Regards
narritu