Issue: Financials Data Table Overfilled with Erroneous Data, Missing Some Gathered Data about qmj HOT 8 OPEN

Focusing on AAC right now (of Issue #18 fame).

Going through the process of getting and processing data in a tiny cluster of companies around AAC does produce the correct raw data, the correct processed data, and also produces profitability, growth, payouts, safety, and quality scores. Each of the subscores of each component are also calculated.

from qmj.

Playing with a smaller data set (800 companies), it seems likely that tidyinfo is having hiccups when it comes to companies with a '.' in its ticker.

from qmj.

May be resolved. Issue may have been a regex error in tidyhelper, writing up NA years for companies with a '.' in their ticker. Testing further.

from qmj.

Tentatively resolved with #27.

Looking at the results of 800 companies, quality scores were produced for all but 23 of them. From a quick sampling, quality scores were missing because either data was absent or severely deficient. Which is great.

Will close this issue once I look at a few other possibilities for the error.

from qmj.

Data inaccuracies of this magnitude is resolved with #27

from qmj.

Issue with a few extra edge cases:

P
SPTN

Possibly more. Both are likely beating the regex in some unplanned way.

from qmj.

Issue with P at least appears to be the fact that they made two filings within the same calendar year. I'll map the process from the beginning and go for more than a bandaid fix this time.

from qmj.

Good news. After modifying the tidying functions, data processing is vastly improved. Enough so that the number of companies that don't produce quality scores is now at 113, a third its previous value. A quick random sampling seems to suggest that the biggest issue is quantmod being unable to return either financial or stock price data.

from qmj.