InvestorsHub Logo

JLS

Followers 62
Posts 7863
Boards Moderated 0
Alias Born 12/14/2004

JLS

Re: TREND1 post# 9

Wednesday, 12/31/2014 2:58:16 AM

Wednesday, December 31, 2014 2:58:16 AM

Post# of 18
No column for PE?

Or PEG?

If you used Excel, you could do a query to download any financial data you want, from Yahoo. You could make your own tables.

Click on the following link to query some data (it will download a .csv file):

http://finance.yahoo.com/d/quotes.csv?s=FB+MSFT&f=snd1l1yr

The codes in the link are described in the image below.



The example link uses only 6 codes. There are a total of 85 codes.

You don't need a browser. You can do the queries directly from within Excel.

note: The PE downloaded is historical (ttm). If you want current (or future estimates), you have to calculate it using queried data. The link in the image shows AAL. I didn't include it in the data in the image because it is old and not worth looking at because it doesn't account for the merger.