How to Get International Key Metrics in Excel

Get international key metrics directly in Excel using custom formulas. Retrieve financial data, automate your workflows, and keep your spreadsheets updated with our Excel add-in.

Install Add-inView Pricing
No VBA/Macros Required
Microsoft Certified Add-in
2-Minute Setup
EXCEL FORMULA
=FDN("InternationalKeyMetrics", "SHEL.L", "", 5)

This formula pulls data into your spreadsheet once our Excel add-in is installed.

Formula Result

See exactly how data fills into your sheet when the formula runs. This example shows the actual up-to-date information returned.

ABCDEFGHIJKLMNOPQRSTUV
1trading_symbolregistrant_namefiscal_periodperiod_end_datecurrency_codeearnings_per_shareprice_to_earnings_ratioearnings_growth_rateprice_earnings_to_growth_ratiobook_value_per_shareprice_to_book_ratioebitdaenterprise_valuedividend_yielddividend_payout_ratiodebt_to_equity_ratiocapital_expendituresfree_cash_flowreturn_on_equityone_year_betathree_year_betafive_year_beta
2SHEL.LShell plcFY2025-12-31USD3.03904.29042904290418.823529411764748.040429042904329.761492496774692.065275298170844745000000.016157872000000.0-0.000524881306939585-0.4749677636373830.2678448552685922025000000.020838000000.00.1022810679388960.1021959904303890.1449743250243320.176490420763994
3SHEL.LShell plcFY2024-12-31USD2.55970.980392156863-11.4583333333333-84.740106951871628.59991110546786.573695661826743655000000.015608349600000.0-0.000555719054295931-0.5385858083757920.27130735192673313087000000.041600000000.00.09026005709254260.08477140070354970.1598385613862150.5660622531524
4SHEL.LShell plcFY2023-12-31USD2.88892.881944444444-50.0-17.857638888888927.97386203311891.925097684246347093000000.017330713250000.0-0.000484718761689967-0.433545121132290.28847792419362619299000000.034892000000.00.1037420889891590.2957680426177320.2236852231424150.600971212953514
5SHEL.LShell plcFY2022-12-31USD5.76403.819444444444——26.212589316093988.735987580284270048000000.017106347000000.0-0.000433287098488995-0.1750218629605990.29480448569868526103000000.042311000000.00.222127136797010.1495160255635990.6323605360444160.573381870913392
ABCDE
1trading_symbolSHEL.LSHEL.LSHEL.LSHEL.L
2registrant_nameShell plcShell plcShell plcShell plc
3fiscal_periodFYFYFYFY
4period_end_date2025-12-312024-12-312023-12-312022-12-31
5currency_codeUSDUSDUSDUSD
6earnings_per_share3.032.552.885.76
7price_to_earnings_ratio904.290429042904970.980392156863892.881944444444403.819444444444
8earnings_growth_rate18.8235294117647-11.4583333333333-50.0—
9price_earnings_to_growth_ratio48.0404290429043-84.7401069518716-17.8576388888889—
10book_value_per_share29.761492496774628.59991110546727.97386203311826.2125893160939
11price_to_book_ratio92.065275298170886.573695661826791.925097684246388.7359875802842
12ebitda44745000000.043655000000.047093000000.070048000000.0
13enterprise_value16157872000000.015608349600000.017330713250000.017106347000000.0
14dividend_yield-0.000524881306939585-0.000555719054295931-0.000484718761689967-0.000433287098488995
15dividend_payout_ratio-0.474967763637383-0.538585808375792-0.43354512113229-0.175021862960599
16debt_to_equity_ratio0.267844855268590.2713073519267330.2884779241936260.294804485698685
17capital_expenditures22025000000.013087000000.019299000000.026103000000.0
18free_cash_flow20838000000.041600000000.034892000000.042311000000.0
19return_on_equity0.1022810679388960.09026005709254260.1037420889891590.22212713679701
20one_year_beta0.1021959904303890.08477140070354970.2957680426177320.149516025563599
21three_year_beta0.1449743250243320.1598385613862150.2236852231424150.632360536044416
22five_year_beta0.1764904207639940.56606225315240.6009712129535140.573381870913392
The formula returns key financial metrics, including price-to-earnings ratio, price-to-book ratio, and free cash flow. Data is available for several thousand international companies whose shares are traded on the following stock exchanges: Toronto, London, Frankfurt, Euronext Paris, Euronext Amsterdam, Tokyo, Hong Kong, Singapore, Indonesia, Malaysia, Korea, Brazil, Mexico, India, Bombay.

Steps to Get Started

01
Install the Add-in

Open Excel, navigate to the Home tab, select Add-ins, and search for FinancialData.Net.

02
Grab Your Key

Sign in to your account at FinancialData.Net, open the dashboard, and copy your API key.

03
Run Your Formula

Open the task pane in Excel, save your API key, and start typing the =FDN(...) formula.

Formula Reference

Use the formula to retrieve financial data by specifying a dataset, ticker symbol, and additional parameters.

=FDN(dataset, identifier, argument, maxRows)
datasetString
Specifies the dataset to query. Enter the dataset name enclosed in quotation marks, for example "InternationalKeyMetrics".
identifierString
Accepts one or multiple identifiers such as ticker symbols (e.g., "AAPL" or "AAPL,MSFT") or other supported identifier types.
argumentString
Filters the dataset output using an additional parameter, such as a date like "2025-01-15" or a reporting period like "year" or "quarter".
maxRowsInteger
Limits the number of records returned by the formula. For example, setting the value to 5 returns the five most recent rows.

Troubleshooting & FAQ

If Excel doesn't recognize the =FDN() formula, the add-in may not have loaded correctly. Restart Excel or reinstall the add-in from the Office Add-ins Store.

Excel displays this error when it does not recognize the =FDN() formula. This means the add-in is either not installed or has been disabled.

The =FDN() formula outputs multiple rows and columns of data, which Excel blocks if any existing text or formatting occupies the surrounding cells. Simply clear these obstructing cells to allow the formula to expand completely.

Install the Excel Add-in

Access 80+ financial datasets directly in Excel using simple formulas.

Install via AppSource
Compatible with Office 365 and Excel for Web
Data Subscriptions for Excel
Standard SubscriptionCore financial data
$29 / mo
Premium Subscription
Full financial data
$69 / mo
Get Started