History¶

0.1.1 (2017-08-31)¶

Removed the –dimension CLI keyword. Now uses Most Recent Year (MRY) for SF0 database and Most Recent Trailing 12 Months (MRT) for the SF1 database
Fix to avoid the Pandas future warning about decrementing df.rename_axis and using df.rename

Now uses the get_table methods from the quandl_api.

Fix bug where the SF0 subscription data was not being returned.
With the discontinuation of the Sharadar Time series API at the end of March 2018, the codes for the free fundamental subscription SF0 database changed. Subscribers to the SF0 data now use the SHARADAR/SF1 code in the get_table accesses.

Added some new Cash Flow related ratios and corrected the LTDEBT ratios
Changed the default to be the paid SF1 Database as this is the one I’m using and testing. Requires a separate free SF0 subscription to test SFO. All of the API calls whether the user has an SFI paid membership or SF0 use the SF1 codes.

After learning that the sample data API now allows _all_ of the same indicators as those available using the paid SF! aPI key I was able to remove a lot of special case code for the Sample data KEY. The paid KEY allows for many more dimensions to be queried.
The CLI now defaults back to using the sample data SF0 API key.
Added a number of Cash Flow from Operations based metrics as well as some Free Cash Flow based metrics.
Added a development test which uses the API and a sample data or SF0 API key to extract ratios for AAPL.
Added Excess Cash Margin ratio.

Add support for the MRQ and ARQ dimensions.
Correct error in calculating CAGR when the data was given in quarterly increments.
Correctly reference the Excel spreadsheet example figures in the README.

Check for the presence of the QUANDL_API_SF0_KEY or the QUANDL_API_SF1_KEY environment variable depending on which database the user is requesting to use.

Refactored by using and manipulating the pandas dataframe as it’a returned from quandl/Sharadar. The dates are rows and the columns are the “observations” ie the revenue, income etc. The dataframe is transposed prior to writing to excel so that the data is in the typically viewed format of dates as columns and the observations as rows.

Added some metrics favored by Kenneth J Marshall, author of “Good Stocks Cheap: Value investing with confidence for a lifetime of Stock Market Outperformance”

Added the working capital value from the balance sheet Note: For finance companies and REITS this is not provided by the API.

Added a summary sheet as the first sheet of a workbook. This is conditionally formatted to highlight the best and worst values for each of the summarized metrics of each ticker in the workbook. The summary table is an excel table and thus each column can be sorted to put best on top or worst on top.