ITA readers who are using the Kipling spreadsheet in any form are aware that Finance-Yahoo (Yahoo) once more altered their downloading codes so we cannot pull security prices into the spreadsheet. Fortunately we have a backup system from Tiingo. If you do not have a Tiingo account (still free to my knowledge) set one up and use it to download stock prices.
Suppose Tiingo goes on the fritz and we are left in the dark price wise. This is akin to owning a restaurant and the chef walks off the job. Where do we go if this were to happen? I’ve given this considerable thought as Yahoo has thrown us this type of knuckle-spitter-screwball before.
1. This change has no impact on the Schrodinger portfolio as it is totally managed by computer at Schwab. So long as the commercial software Investment Account Manager (IAM) is operational, I can keep tabs on the Internal Rate of Return (IRR). The impact would come from not being able to report on the Risk Ratios as that data requires information such as the portfolio beta. The Kipling generates portfolio beta as well as the Information Ratio and Sortino Ratio. If Tiingo goes down, so does some of the portfolio information I find useful.
2. Portfolios such as the Einstein, Gauss, Kepler, and Millikan would need to change dramatically as all are totally dependent on the Kipling spreadsheet.
3. The Copernicus would function as is. All I need is the IAM software as I only invest in U.S. Equities with this portfolio.
4. The income portfolios such as the Huygens would not suffer all that much as I can gain access to Closed-End-Fund data from CEF Connect.
5. Dual Momentum portfolios would be impacted as they depend entirely on the Kipling.
6. Bethe and Bohr would need to change as these growth-income portfolio rely on decisions that emerge from the Kipling.
7. This leaves the BPI Model portfolios. So long as Stock-Charts generates PnF data, I think the Carson and Franklin would not need to change. Granted, they too would be missing critical data used to monitor portfolio risk.
The above hazards exist when one is dependent on others for critical information. We have been fortunate to have free access to stock, bond, and ETF prices for many years.
Were Tiingo to fail, I would most likely reduce the investing models to these portfolios styles as identified by math and science giants; Schrodinger, Copernicus, Carson, Franklin, and Huygens. I would likely scrap the Dual Momentum and Relative Strength models.
Comments and Questions are welcome.