YCS calls pulling 0s for most recent figures if they the data is either 0 or null

Email 1

Hi Kim,

I hope this email finds you well. I have a question on how I can best pull in data from YCharts to Excel. I have been using this tool for almost two years now, so I’m pretty comfortable with it. However, when I try to pull in a company’s current debt or long-term debt, the data usually needs to be double-checked, which adds a lot of work to my data collection. This is what’s happening: I try to pull in debt amounts for the last 6 quarters and the quarterly data is incorrect.

For example, when I try to pull in debt data for CORT, it comes through like this:

I came back with use YCP or keep YCS and do index matches

Email 2

Hi James,

Thank you for reaching out. Yeah, if YCharts could actually enter a “0” when there is no debt (or another metric like dividends or stock buybacks) so “0” would be retrieved when I pull a string of data, that would go a long ways in helping me collect data more expediently.

I’ve used the YCP system before and it’s actually a worse method to use simply because not all stocks’ data is updated simultaneously on the same day each quarter. So for CORT, when I use YCP, I get this output:

I just want to be able to tell my spreadsheet to pull the most recent six quarters of data and have confidence that zeroes will fill in when they should (instead of data from 4 quarters ago appearing like it was data from the most recent quarter). Please let me know if you have any questions on what I’m trying to do. Thank you for your help on this James!

Ben Brocker