XBRLFact vs Finvalue Functions
Both Finvalue and XBRLFact functions load financial data to Excel from live SEC database, with the same syntax below: Tickers/CIKs Object[,] specifies
Read more
Both Finvalue and XBRLFact functions load financial data to Excel from live SEC database, with the same syntax below: Tickers/CIKs Object[,] specifies
Read more
SharePrice function loads in Excel the stock price of a public company from FinDynamics live database of stock market data from all Equity markets in the US. Its complete syntax is below: Ticker/CIK Object[,] specifies company name or symbol/ticker or other company identifier, e.g
Read more
What are the available XBRLAnalyst Excel functions and how to use them? XBRLAnalyst Excel function list is available in the "Help" button of XBRLAnalyst ribbon, each with defined syntax and definition. Commonly used functions for data return:
Read more
How long does it take for XBRLAnalyst functions to return values in excel? XBRLAnalyst's functions are calculating in asynchronous multi-threaded mode with multiple connections to the database, taking only seconds for single value and couple of minutes for array of
Read more
At default settings, XBRLAnalyst returns values in Excel with "Annotation", with details of related tags, calculations, report accession number, etc. This serves as guide to users on where and how the values were generated. To remove annotation on return values, you can specify it in
Read more
Companies do not use all available financial metrics (XBRL tag/TID) in the system. Hence, "no data" outputs are expected on your reports, particularly if "comparing companies". XBRLAnalyst offers three options on how "no data" output will be returned to Excel
Read more
Finstatement is a very powerful XBRLAnalyst excel function that returns array of financials that a company reported up to 20 periods, incorporating all changes on financial reporting style. It can generate all financial concepts that a company used in its statement (IS,BS,CF), provide segments or dimensions of a financial concept, and filter these dimensions by using
Read more
Every year, almost 8000+ filers are actively submitting reports to SEC database, and this means thousands of data are available for use. Though XBRLAnalyst system can perform synchronous calculations, loads of data might still take time or sometimes incur an error in retrieving all
Read more
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 differences: Input concept should be TextBlock concept. For finding their list for a given company, please see example (available in Corporate
Read more
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 report is published. Some examples of relative periods are: 0Q, -1Q, -2Q, -3Q, ... 0FY, -1FY, -2FY, ... LTM The period parameter should be used in the third
Read more
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 pulling data with FinValue, XBRLFact or any similar XBRLAnalyst function, by default the data is returned from the most recent available report. For example, if you query the
Read more
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 of given type each Owners holds. In the Excel Comment box one can see the Issuer name with CIK code, the Owner name with CIK code and the Stock type help by the Owner. The value in the cell is the
Read more
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 specified date. For example, if you are looking for LTM value of some "Duration" concept such as Revenue as of 2018-Q3, you can get it with XBRLAnalyst using the following syntax in Excel:
Read more
From which reporting period does XBRLAnalyst functions return values? At default, XBRLAnalyst functions return values of any financial metrics/TID from the most recent report in the database. To return values from other period, you need to specify the period under the fourth parameter. There are different ways on how to do this, but below are XBRLAnalyst
Read more
XBRLFact is one of the most important and robust Excel function that XBRLAnalyst added to Excel. It allows getting any value from any financial reports or normalized dataset provided by FinDynamics. There are multiple tutorials, example templates and documentation explaining how to use it. 1) "XBRLFact Tutorial" video in https://findynamics.com/tutorials/ 2) Help document
Read more