Last Twelve Months (LTM) Period

Last Twelve Months (LTM) is a built-in XBRLAnalyst period code which calculates a value of financial concept (Original or Normalized) for last twelve months starting from your

Read more

Ownership Function

Ownership function returns ownership data for selected Filer from Forms 3, 4 submitted to SEC. It is an array function that returns an array of values listing how much shares

Read more

Values from original report

Financial reports present values from the latest reporting period as well as from several prior periods. Some statements and disclosures may provided values for up to 1-2 years back. When

Read more

Relative Periods

In many financial models, we build Excel templates leveraging relative periods with respect to the latest reported financials. This makes the templates automatically updating whenever a new

Read more

XBRLBlock

XBRLBlock is an Excel function provided by XBRLAnalyst for getting text blocks from XBRL reports. Its syntax is very similar to XBRLFact but you need to consider 2 main

Read more

Detecting Report Errors

Report errors can make companies susceptible to the disapproving reactions of outside users or entities, particularly SEC. And as data provider heavily relying on companies'

Read more

Restatements - Reissuance or Revision

Financial Accounting Standards Board (FASB) describes restatement as a revision of a previously submitted financial statement to correct an error. Though it clearly defines restatement, it

Read more