This item downloads valuation fundamental data for US stocks. It downloads 13 valuation ratios and stores them into a custom historical database whose name is 'fund_valuation'. This item should be run once per week in order to add additional ratios data and build an historical fundamental database. To get more companies fundamental data, download this item: Financial fundamental data for US companies
In order to reduce the size of the database (in the future, as more and more data are inserted), I have created a script inside this downloader; its role is to update the fundamental items dates, so that these dates day-of-week will be a Monday. The most recent Monday is chosen. (Weekly database).
Here is a list of the fundamental ratios:
MarketCap: Market capitalization.
PE: Price earnings ratio; it is the stock price divided by the earnings per share.
F-PE: Forward price earnings ratio; it is the stock price divided by the forecasted earnings per share for the next fiscal year.
PEG: It is the price earnings ratio divided by the annual earnings per share growth.
P-S: It is the stock price divided by the total revenues per share.
P-B: It is the stock price divided by the latest quarter's book value per share.
P-C: Price/Cash; it is the stock price divided by the cash per share.
P-FCF: Price/Free Cash Flow; it is the stock price divided by the free cash flow per share. EPS: EPS growth this year; EPS, or earning per share, is the company's profit divided by the number of outstanding shares.
EPS-Next: EPS growth next year.
EPS-Past5Y: EPS growth for the past 5 years.
EPS-Next5Y: EPS growth for the next 5 years.
Sales-Past5Y: Sales growth for the past 5 years.
NB: Empty fields are filled with the (double.NAN) value.
