Fundamental financial data for stocks worldwide

We offer our premium customers access to the following fundamental data:

 

  1.   API_Fundamentals 
    contains fundamental data from the annual reports:

    - Diluted earnings per share
    - total capital
    - equity
    - net operating cash flow
    - capital expenditure
    - free cash flow
    - Profit loss
    - Shares outstanding
    - Net sales

  2.     API_Dividend
    contains the annual dividends (split-adjusted without special dividend)

  3.     API_Fscore
    contains our FScore for each past trading day

  4.     API_Pricetobook
    contains the price-book ratio (P / B ratio) for each past trading day

  5.     API_Pricetocashflow
    contains the price-cash-flow ratio (P / C ratio) for each past trading day

  6.     API_Pricetoearning
    contains the price-earnings ratio (P / E ratio) for each past trading day

  7.     API_Pricetofreecashflow
    contains the price-free-cash-flow ratio (P / FC ratio) for each past trading day

  8.     API_Pricetosales
    contains the price turnover ratio (P / S ratio) for each past trading day

  9.     API_Roa
    contains the profitability (ROA ratio) for the financial year

  10.     API_Roe
    contains the equity ratio (ROE ratio) for the financial year

Determine shareuid

To query the fundamental data via our API, you need the Shareuid for the share you are looking for. You can either determine this yourself via the API, or take it from the Excel table.
IMPORTANT! The currency that is output in the API_Fundamentals results is also included here.

Syntax:

name = search shareuid with company name
wkn = search shareuid with WKN
isin = search shareuid with ISIN
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example calls:

https://api.finanzoo.de/v1/public/?API_Index&name=ibm&token=YOURTOKEN
https://api.finanzoo.de/v1/public/?API_Index&wkn=851399&token=YOURTOKEN
https://api.finanzoo.de/v1/public/?API_Index&isin=US4592001014&token=YOURTOKEN

Example answer:

{"shareuid":"2","isin":"US4592001014 ","wkn":"851399","currency":"USD","shortname":"IBM","name":"International Business Machines Corp.","country":"Vereinigte Staaten von Amerika","indizes":"Dow Jones Industrial Average,S&P 500","sector":"Technology","lastbalanceupdate":"2020-01-26"}

Shareuid Excel Table

Find the shareuid for your query.

API_Fundamentals

Syntax:

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:

https://api.finanzoo.de/v1/public/?API_Fundamentals&shareuid=2&from=2019-01-01&to=2020-03-31&token=YOURTOKEN

Example answer:

[{"year":"2019","eps":"10.566","total_liabilities":"152186000000","operating_cashflow":"14770000000","capex":"-2370000000","free_cashflow":"12400000000.00","total_equity":"20841000000","net_income":"9431000000","net_revenue":"77147000000","outstandingshares":"892580000"}]

API_Dividend

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Dividend&shareuid=2&from=1919-01-01&to=2020-03-31&token=YOURTOKEN

Example answer:

[{"year":"1962","dividend":"0.00400"},{"year":"1963","dividend":"0.00566"},{"year":"1964","dividend":"0.00791"},{"year":"1965","dividend":"0.01000"},{"year":"1966","dividend":"0.01075"},{"year":"1967","dividend":"0.03575"},{"year":"1968","dividend":"0.09750"},{"year":"1969","dividend":"0.18000"},{"year":"1970","dividend":"0.18000"},{"year":"1971","dividend":"0.26000"},{"year":"1972","dividend":"0.27000"},{"year":"1973","dividend":"0.28000"},{"year":"1974","dividend":"0.34750"},{"year":"1975","dividend":"0.40626"},{"year":"1976","dividend":"0.50002"},{"year":"1977","dividend":"0.62500"},{"year":"1978","dividend":"0.72000"},{"year":"1979","dividend":"0.86000"},{"year":"1980","dividend":"0.86000"},{"year":"1981","dividend":"0.86000"},{"year":"1982","dividend":"0.86000"},{"year":"1983","dividend":"0.92750"},{"year":"1984","dividend":"1.02500"},{"year":"1985","dividend":"1.10000"},{"year":"1986","dividend":"1.10000"},{"year":"1987","dividend":"1.10000"},{"year":"1988","dividend":"1.10000"},{"year":"1989","dividend":"1.18250"},{"year":"1990","dividend":"1.21000"},{"year":"1991","dividend":"1.21000"},{"year":"1992","dividend":"1.21000"},{"year":"1993","dividend":"0.39500"},{"year":"1994","dividend":"0.25000"},{"year":"1995","dividend":"0.25000"},{"year":"1996","dividend":"0.32500"},{"year":"1998","dividend":"0.43000"},{"year":"1999","dividend":"0.47000"},{"year":"2000","dividend":"0.51000"},{"year":"2001","dividend":"0.55000"},{"year":"2002","dividend":"0.59000"},{"year":"2003","dividend":"0.63000"},{"year":"2004","dividend":"0.70000"},{"year":"2005","dividend":"0.78000"},{"year":"2006","dividend":"1.10000"},{"year":"2007","dividend":"1.50000"},{"year":"2008","dividend":"1.90000"},{"year":"2009","dividend":"2.15000"},{"year":"2010","dividend":"2.50000"},{"year":"2011","dividend":"2.90000"},{"year":"2012","dividend":"3.30000"},{"year":"2013","dividend":"3.70000"},{"year":"2014","dividend":"4.25000"},{"year":"2015","dividend":"5.00000"},{"year":"2016","dividend":"5.50000"},{"year":"2017","dividend":"5.90000"},{"year":"2018","dividend":"6.21000"},{"year":"2019","dividend":"6.48000"}]

API_Fscore

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Fscore&shareuid=2&from=2020-02-15&to=2020-03-15&token=YOURTOKEN

Exampler answer:

[{"date":"2020-03-13","fscore":"0.200"},{"date":"2020-03-12","fscore":"0.200"},{"date":"2020-03-11","fscore":"47.200"},{"date":"2020-03-10","fscore":"42.700"},{"date":"2020-03-09","fscore":"47.200"},{"date":"2020-03-06","fscore":"42.700"},{"date":"2020-03-05","fscore":"42.700"},{"date":"2020-03-04","fscore":"38.200"},{"date":"2020-03-03","fscore":"42.700"},{"date":"2020-03-02","fscore":"38.200"},{"date":"2020-02-28","fscore":"36.700"},{"date":"2020-02-27","fscore":"36.700"},{"date":"2020-02-26","fscore":"35.200"},{"date":"2020-02-25","fscore":"35.200"},{"date":"2020-02-24","fscore":"35.200"},{"date":"2020-02-21","fscore":"35.200"},{"date":"2020-02-20","fscore":"35.200"},{"date":"2020-02-19","fscore":"35.200"},{"date":"2020-02-18","fscore":"35.200"}]

API_Pricetobook

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Pricetobook&shareuid=2&from=2019-12-15&to=2020-03-15&token=YOURTOKEN

Example answer:

[{"date":"2020-01-09","pb":"7.464"},{"date":"2020-01-08","pb":"7.386"},{"date":"2020-01-07","pb":"7.325"},{"date":"2020-01-06","pb":"7.320"},{"date":"2020-01-03","pb":"7.333"},{"date":"2020-01-02","pb":"7.392"},{"date":"2019-12-30","pb":"7.249"},{"date":"2019-12-27","pb":"7.384"},{"date":"2019-12-26","pb":"7.364"},{"date":"2019-12-24","pb":"7.368"},{"date":"2019-12-23","pb":"7.399"},{"date":"2019-12-20","pb":"7.401"},{"date":"2019-12-19","pb":"7.345"},{"date":"2019-12-18","pb":"7.337"},{"date":"2019-12-17","pb":"7.326"},{"date":"2019-12-16","pb":"7.321"}]

API_Pricetocashflow

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Pricetocashflow&shareuid=2&from=2020-02-15&to=2020-03-15&token=YOURTOKEN

Example answer:

[{"date":"2020-01-09","pc":"8.22"},{"date":"2020-01-08","pc":"8.14"},{"date":"2020-01-07","pc":"8.07"},{"date":"2020-01-06","pc":"8.06"},{"date":"2020-01-03","pc":"8.08"},{"date":"2020-01-02","pc":"8.14"}]

API_Pricetoearning

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Pricetoearning&shareuid=2&from=2019-12-15&to=2020-03-15&token=YOURTOKEN

Example answer:

[{"date":"2020-01-09","pe":"14.363"},{"date":"2020-01-08","pe":"14.213"},{"date":"2020-01-07","pe":"14.096"},{"date":"2020-01-06","pe":"14.086"},{"date":"2020-01-03","pe":"14.111"},{"date":"2020-01-02","pe":"14.225"},{"date":"2019-12-30","pe":"13.951"},{"date":"2019-12-27","pe":"14.209"},{"date":"2019-12-26","pe":"14.171"},{"date":"2019-12-24","pe":"14.179"},{"date":"2019-12-23","pe":"14.238"},{"date":"2019-12-20","pe":"14.243"},{"date":"2019-12-19","pe":"14.134"},{"date":"2019-12-18","pe":"14.119"},{"date":"2019-12-17","pe":"14.099"},{"date":"2019-12-16","pe":"14.089"}]

API_Pricetofreecashflow

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Pricetofreecashflow&shareuid=2&from=2020-01-02&to=2020-03-15&token=YOURTOKEN

Example answer:

[{"date":"2020-01-09","pfc":"10.58"},{"date":"2020-01-08","pfc":"10.47"},{"date":"2020-01-07","pfc":"10.38"},{"date":"2020-01-06","pfc":"10.37"},{"date":"2020-01-03","pfc":"10.39"},{"date":"2020-01-02","pfc":"10.48"}]

API_Pricetosales

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Pricetosales&shareuid=2&from=2020-01-01&to=2020-03-15&token=YOURTOKEN

Example answer:

[{"date":"2020-01-09","ps":"1.575"},{"date":"2020-01-08","ps":"1.559"},{"date":"2020-01-07","ps":"1.546"},{"date":"2020-01-06","ps":"1.545"},{"date":"2020-01-03","ps":"1.547"},{"date":"2020-01-02","ps":"1.560"}]

API_Roa

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:


https://api.finanzoo.de/v1/public/?API_Roa&shareuid=2&from=2019-01-01&to=2020-03-15&token=YOURTOKEN

Example answer:

[{"year":"2019","roa":"6.1970"}]

API_Roe

Syntax:
 

shareuid = unique identifier for the share searched
from = Start date of the searched period in American notation year-month-day with leading 0
to = End date of the searched period in American notation year-month-day with leading 0
token = your Finanzoo token (https://www.finanzoo.de/account/api.html) -> You need a premium account to use.

 

Example call:

https://api.finanzoo.de/v1/public/?API_Fundamentals&shareuid=2&from=2019-01-01&to=2020-03-31&token=YOURTOKEN

Example answer:

[{"year":"2019","roe":"13.69"}]

Fundamental Data API access with PHP

$requesturl = "https://api.finanzoo.de/v1/public/?API_Fundamentals&shareuid=2&from=2019-01-01&to=2020-03-31&token=YOURTOKEN";

$ch = curl_init();
// Get cURL resource
curl_setopt($ch, CURLOPT_URL, $requesturl);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true );

$response = curl_exec($ch);

curl_close($ch);

var_dump(json_decode($response,true));

Fundamental Data RESTful API C#

using System;
using System.Net;

namespace FundamentalData
{
    class Program
    {
        static void Main(string[] args)
        {
            string url = "https://api.finanzoo.de/v1/public/?API_Fundamentals&shareuid=2&from=2019-01-01&to=2020-03-31&token=YOURTOKEN";
            string respose = GetFundamentalData(url);
            Console.WriteLine(respose);
            Console.ReadLine();
        }

 

        public static string GetFundamentalData(string url)
        {
            string response = string.Empty;

            using (WebClient client = new WebClient())
            {
                // Create web client simulating IE6.
                client.Headers["User-Agent"] = "Mozilla/4.0 (Compatible; Windows NT 5.1; MSIE 6.0)";
                response = client.DownloadString(url);
            }

            return response;
        }
    }
}

Questions and suggestions

Do you have any questions or suggestions about our API? Please use our contact form with the subject "API question".