Your comments

Jeff,


I went about getting data from zacks again. It's updated more regularly.


The numbers I'm now using are:

  • PercentGrowthCurrentFiscalYearMeanOverMostRecentFiscalYearEarningsPerShare
  • PercentGrowthNextFiscalYearMeanOverCurrentFiscalYearMean


Thanks for those screenshots! I didn't think about the indirect function.

You are awesome.

FYI the numbers should be correct now.


For the number formatting, I labeled the title to include % to make it clearer.

@Dan,

This can easily become a very complex task.

  • did you shift rows or columns of any of the original worksheets?
  • or were your customizations done on a new blank worksheet and everything else was intact?

If you shifted rows or columns in the main sections, then there is a lot of work involved with having to match the cells from the old spreadsheet to the new spreadsheet.


If you used a blank worksheet, that's easier because you could do a "copy -> paste special -> paste formula only " which will cut down a lot of the time.


First thing is to send a copy of your spreadsheet to support@oldschoolvalue.freshdesk.com.

I can see how complex the work is and let you know.

You're right. It should actually be showing as a decimal at least. Since it's exporting as a csv, formatting doesn't work on the files. 

@Jeff,


I know what you mean. Those numbers are coming from my data provider so it's not something I can change with them.


What I'll probably have to do is to switch to manual calculations.

Thanks. I'll have to update the link.

Another source I like, which won't disappear is the FRED site.


Here’s one for corp AAA

https://fred.stlouisfed.org/series/AAA

 

Corp AA yield is this one

https://fred.stlouisfed.org/series/BAMLC0A2CAAEY