Excel Functions

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

SharePrice Function

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

XBRLAnalyst Functions

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

Function Calculation Speed

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

Speed Up Value Return Process by Removing Annotations

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

Set "No Data" Output into Blank/Zero

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

XBRLFact

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

FinStatement

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

Error in Comparing All Companies in SEC database

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

Period Prefix/Code

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 spcify the period to an additional parameter. There are different ways on how to do this, but below are XBRLAnalyst

Read more

Last Twelve Months (LTM) Period

Last Twelve Months (LTM) is a built-in period code which calculates automatically for a full year equivalent of financial data from your specified date.  This feature is very useful if you are doing a mid-year comparison or comparing companies having different fiscal years. Though we already varios 

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 differences: Input concept should be TextBlock concept. For finding their list for a given company, please see example (available in Corporate

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 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

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 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

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