Current market quotes and other live data in a spreadsheet

[SmallCap]

Does anyone here have the know how to place live current market data such as quotes and balance sheet data into a cell of a spreadsheet?

 

This can be either an offline spreadsheet such as Excel or an online one such as Google sheets.

 

I just want a place where I can enter in a symbol and then have additional cells with live constantly updating information that I can calculate from.

 

SmallCap

[StubbleJumper]

I do this all the time in GoogleDocs.  In the spreadsheet, just add the following function:

 

=GoogleFinance(D9, "price")

 

 

In cell D9 you put in whichever ticker symbol you like.  There are also a bunch of parameters other than "price" that you can query, which is convenient.  I just open up my spreadsheet at the morning bell, and it happily updates itself all day long.  ;D

 

SJ

[SmallCap]

StubbleJumper,

 

Thanks so much that was perfectly what I was looking for. I knew there was a simple solution buy my Google searches surprisingly turned up nothing of value.

 

Another question is where do I find the list of the other parameters that I can use?

 

SmallCap

[beerbaron]

For Excel, look for the function

 

MSNStockQuote()

 

BeerBaron

[StubbleJumper]

StubbleJumper,

 

Thanks so much that was perfectly what I was looking for. I knew there was a simple solution buy my Google searches surprisingly turned up nothing of value.

 

Another question is where do I find the list of the other parameters that I can use?

 

SmallCap

 

I don't have a complete list of all the parameters available, but in my watch list, I have columns for ticker-symbol, "price", "high52", "low52", "eps", and "pe".  It's not an in depth analytical approach, but those five parameters enable me to keep an eye on the large caps to see whether a security might be heading in a direction where value could be present.

 

 

SJ

[nodnub]

I use this YF Quote add-in for Excel.  It pulls data from Yahoo Finance (which sometimes has more data for obscure stuff than Google Finance)

 

http://fransking.blogspot.com/2006/06/getting-stock-prices-into-excel.html

 

 

[Myth465]

I use this YF Quote add-in for Excel.   It pulls data from Yahoo Finance (which sometimes has more data for obscure stuff than Google Finance)

 

http://fransking.blogspot.com/2006/06/getting-stock-prices-into-excel.html

 

 

 

Thanks adding this tonight.

[SmallCap]

I have been using the YF Quote function now for a little while and it has been very useful, thanks for pointing it out guys.

 

but now I am trying to figure out how to put quotes from options into a spreadsheet and for some reason the YF Quote function doesn't seem to work with option quotes.

 

Any ideas out there to get option quotes into a spreadsheet?

[StubbleJumper]

I have been using the YF Quote function now for a little while and it has been very useful, thanks for pointing it out guys.

 

but now I am trying to figure out how to put quotes from options into a spreadsheet and for some reason the YF Quote function doesn't seem to work with option quotes.

 

Any ideas out there to get option quotes into a spreadsheet?

 

 

Perhaps this message thread from the Motley Fool might help:

 

http://boards.fool.com/a-site-with-option-pricing-28843199.aspx?sort=whole#28843199

 

 

SJ

[Myth465]

Thanks I had just given up on the options setting and was hand keying those in. It seems like it takes alot more effort to pull down options info though.

 

[beerbaron]

SJ, how do you tell the =GoogleFinance function to return a canadian stock if there is a comflicting ticker between US and Canada?

 

BeerBaron

[StubbleJumper]

Using the Royal Bank as an example, you can get either the NYSE or TSX quote in google spreadsheets by using the symbol RY or RY.to respectively.  My assumption is that you can just tack a .to onto any Toronto stock to ensure that google doesn't get confused.

 

SJ