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 in Excel under "Help->Function Help" menu on XBRLAnalyst Ribbon

3) Sample Templates under "Financial Templates" button on XBRLAnalyst Ribbon

4) Excel examples under https://findynamics.com/excel-examples/

5) Extra clarifications on HowTo pages

Most common use of this function is for pulling specific data points from Excel as follows:

  • =XBRLFact("MSFT","[EBITDA]")
    -- for getting Normalized financial of a company from most recent FY report
  • =XBRLFact("MSFT","[EBITDA]",2015)
    -- same but the data is pulled from 2015-FY report
  • =XBRLFact("MSFT","[EBITDA]",2015, "Q1")
    -- same but pulling data from 2015-Q1 period. Alternative syntax: =XBRLFact("MSFT","[EBITDA]","2015-Q1")

  • =XBRLFact("MSFT","[EBITDA]","2015","cal:Q1")
    ​-- getting the data from 2015-Q1 calendar period. Microsoft finishes its fiscal year in June so the calendar and fiscal periods do not match. XBRLAnalyst automatically finds proper fiscal period for the calendar period. This permits comparing mutliple companies with different fiscal year end dates for specified calendar period. Alternative syntax: =XBRLFact("MSFT","[EBITDA]","2015-Q1","cal:")

  • =XBRLFact("MSFT","[EBITDA]","2015","Q1:original")
    -- getting the data from the original 10Q report filed for 2015-Q1. Normally, XBRLFact returns the data from most recent available report. Since companies restate their values sometimes, by default you are getting restated data from most recent report. If you would like to get the originally reported values though, you should use the keyword ":original".

  • =XBRLFact("MSFT","[Gross Profit]","2018","Q3LTM")
    -- "LTM" (Last Twelve Month) is returning 12-month trailing value from the period specified in the fourth parameter, i.e. from 2018-Q3. If you need to get LTM from the current most recently filed report, just omit the year and period and leave "LTM" in third parameter.

Let us know if you need help with some inputs of this function. It is very robust and can return array values for many companies or financials at once, it can scale the values and return data from disclosures, etc.

Leave a reply