data for intangibles missing

AstIntanQ defaults to N/A for all stocks prior to 6/1/2002. After that, it’s fine. Can this be fixed? Thanks!

There is no quarterly data for AstIntan in the S&P Compustat data model. There is only annual. P123 shouldn’t make up data where none is present.

The closest analogue is going to be Non-Current Assets - Other which includes:

a. On an annual basis: those long-term assets that are not property, plant and equipment, investments and
advances, or intangibles.

b. On a quarterly basis: those long-term assets that are not property, plant and equipment. On a quarterly
basis, this item will include Investments and Advances – Equity Method, Investments and Advances –
Other, Intangibles, Deferred Charges and other long-term assets.

It is unfortunate that P123 didn’t recognize these artefacts of the data when it wrote the syntax.

P123: please let me know if you guys want help identifying all data items which don’t have annual/quarterly analogues.

Every 10-Q I’ve ever seen has intangible assets on it. Portfolio123’s data matches the company’s 10-Q. This isn’t a problem in general. It’s only a problem before June 2002.

Interesting. The data guide I have was updated after 2002, when AstIntanQ was being regularly populated.

Thanks for pointing this out; my prior models were built on the assumption that AstIntan was only available on an annual basis.

I wanted to bump this to get a response from someone at P123 who is familiar with the database. I’m wondering if the absence of AstIntanQ data prior to 6/2002 might be just a data glitch, or if that data is actually nonexistent. Thanks, - Yuval