Stock price for NSE scrips in Googlespreadsheet...help me..

Hi,

I am trying to get stcok price in googlespread sheeet for various scrips in NSE.

But I am getting wrong price for some scrips.

For example for getting price of LT, I entered in a cell like this

=Googlefinance("LT", "Price") then I am getting a price "972.69".

But this is not the correct price of "LT".

How to wirte it to get correct price..?

Thanks,
Nava

Google Finance has the following lookup for LT:

Larsen & Toubro Limited (Public, BOM:500510)

So I did this:

=Googlefinance("500510", "Price")

and it shows the price as 2170.6


I hope this answers your question.

Hi,

Thanks for your reply. But in that case we will get BSE price not NSE.

How to get NSE price..?

Thanks,