Fixed and released.
will fix and update
I went about getting data from zacks again. It's updated more regularly.
The numbers I'm now using are:
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.
This can easily become a very complex task.
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 email@example.com.
I can see how complex the work is and let you know.
I'll create a different thread for this.
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.
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
Corp AA yield is this one
Customer support service by UserEcho