Excel Stocks API


Use our excel stocks api to fill in data points that built-in tools don't have. Use it with your excel stock portfolio tracker. Works with Microsoft Excel and Google Sheets. Please note we do not offer real-time price data. We offer the last closing price along with all of the data fields below, which are processed every day after the markets close. There are many fields available including dividend yield, pe ratio, ttm net income, revenue and tons more. Also works for ETFs.

How to use

URL: https://www.financecharts.com/api?ticker=TICKER&stat=STAT

Replace TICKER with the cell you are using for the stock symbol.

Replace STAT with one of the available data fields below.

Optional Parameter: decimalPlaces. Use this to limit the return value to the number of decimal places that you want (&decimalPlaces=2 if you want it to look like 102.22 for example).

Excel Example

You will use the built-in WEBSERVICE function to make the web call. The CONCATENATE function will help you build the URL with the required ticker and stat.

Example usage: Assume your ticker value is in cell 'B2' and you are wanting the dividend yield. Put this text in the cell where you want the dividend yield to go:


Use the above string for any data field, in this case replacing 'dividendyield' with whatever stat you are wanting.

Google Sheets Example

The syntax for Google Sheets is almost exactly the same as excel, except you will use the built-in IMPORTDATA function to make the web call. The CONCATENATE function will help you build the URL with the required ticker and stat.

Example usage: Assume your ticker value is in cell 'B2' and you are wanting the dividend yield. Put this text in the cell where you want the dividend yield to go:


Use the above string for any data field, in this case replacing 'dividendyield' with whatever stat you are wanting.

Data Fields Available (Stocks)

Name
Description
Country
Currency
Sector
Industry
IpoDate
Website
Exchange
MarketCapUsd
LastPrice (last closing price)
FiftyTwoWeekHigh
FiftyTwoWeekLow
VolumeAvg1M
VolumeUsdAvg1M
FiftyTwoWeekHighDate
FiftyTwoWeekLowDate
LastPriceChangePercent
DividendYield (TTM Yield)
DividendYieldAvgTtm
DividendYieldAvg3Y
DividendYieldAvg5Y
DividendYieldAvg10Y
DividendCagrTtm
DividendCagr3Y
DividendCagr5Y
DividendCagr10Y
DividendPayoutRatio
DividendPayoutRatioAvg3Y
DividendPayoutRatioAvg5Y
DividendPayoutRatioAvg10Y
DividendPayoutRatioFcf
DividendPayoutRatioFcfAvg3Y
DividendPayoutRatioFcfAvg5Y
DividendPayoutRatioAvgFcf10Y
DividendFutureYoc3Y (Estimated forward yield on cost based on past CAGR; errs on being conservative)
DividendFutureYoc5Y
DividendFutureYoc10Y
PeRatio
PeRatioAvgTtm
PeRatioAvg3Y
PeRatioAvg5Y
PeRatioAvg10Y
PegRatio
PegRatioAvgTtm
PegRatioAvg3Y
PegRatioAvg5Y
PegRatioAvg10Y
PbRatio
PbRatioAvgTtm
PbRatioAvg3Y
PbRatioAvg5Y
PbRatioAvg10Y
PfcfRatio
PfcfRatioAvgTtm
PfcfRatioAvg3Y
PfcfRatioAvg5Y
PfcfRatioAvg10Y
PsRatio
PsRatioAvgTtm
PsRatioAvg3Y
PsRatioAvg5Y
PsRatioAvg10Y
TotalReturnTtm
TotalReturn3Y
TotalReturn5Y
TotalReturn10Y
CurrentRatio
CurrentRatioAvgTtm
CurrentRatioAvg3Y
CurrentRatioAvg5Y
CurrentRatioAvg10Y
DebtEquityRatio
DebtEquityRatioAvgTtm
DebtEquityRatioAvg3Y
DebtEquityRatioAvg5Y
DebtEquityRatioAvg10Y
EvEbitRatio
EvEbitRatioAvgTtm
EvEbitRatioAvg3Y
EvEbitRatioAvg5Y
EvEbitRatioAvg10Y
EvEbitdaRatio
EvEbitdaRatioAvgTtm
EvEbitdaRatioAvg3Y
EvEbitdaRatioAvg5Y
EvEbitdaRatioAvg10Y
EvAssetsRatio
EvAssetsRatioAvgTtm
EvAssetsRatioAvg3Y
EvAssetsRatioAvg5Y
EvAssetsRatioAvg10Y
EvSalesRatio
EvSalesRatioAvgTtm
EvSalesRatioAvg3Y
EvSalesRatioAvg5Y
EvSalesRatioAvg10Y
ProfitMargin
ProfitMarginAvgTtm
ProfitMarginAvg3Y
ProfitMarginAvg5Y
ProfitMarginAvg10Y
QuickRatio
QuickRatioAvgTtm
QuickRatioAvg3Y
QuickRatioAvg5Y
QuickRatioAvg10Y
RoaRatio
RoaRatioAvgTtm
RoaRatioAvg3Y
RoaRatioAvg5Y
RoaRatioAvg10Y
RoeRatio
RoeRatioAvgTtm
RoeRatioAvg3Y
RoeRatioAvg5Y
RoeRatioAvg10Y
NetIncomeTtm
NetIncomeCagrTtm
NetIncomeCagr3Y
NetIncomeCagr5Y
NetIncomeCagr10Y
FreeCashFlowTtm
FreeCashFlowCagrTtm
FreeCashFlowCagr3Y
FreeCashFlowCagr5Y
FreeCashFlowCagr10Y
RevenueTtm
RevenueCagrTtm
RevenueCagr3Y
RevenueCagr5Y
RevenueCagr10Y
EpsDilutedCagrTtm
EpsDilutedCagr3Y
EpsDilutedCagr5Y
EpsDilutedCagr10Y
PriceCagrTtm
PriceCagr3Y
PriceCagr5Y
PriceCagr10Y
TotalReturnCagrTtm
TotalReturnCagr3Y
TotalReturnCagr5Y
TotalReturnCagr10Y
FairValuePrice ('fair' price based on DCF with our 'intelligence' applied)
FairValuePriceFcf (DCF based on free cash flow)
FairValuePriceNetIncome (DCF based on net income)

The following stats are computed as discounts to the current value. Both the current and 3Y/5Y stats must be positive values else it will return N/A. Negative means it's at a discount, positive the opposite.

PeDiscount3Y (discount of current pe ratio from 3y avg)
PeDiscount5Y
PsDiscount3Y
PsDiscount5Y
EvEbitDiscount3Y
EvEbitDiscount5Y
PfcfDiscount3Y
PfcfDiscount5Y


Data Fields Available (ETFs)

Name
Description
Country
Currency
Sector
Industry
Inception
Website
FundWebsite
Exchange
FundNetExpenseRatio
FundAverageMarketCap
FundTotalAssets
LastPrice (last closing price)
FiftyTwoWeekHigh
FiftyTwoWeekLow
VolumeAvg1M
VolumeUsdAvg1M
FiftyTwoWeekHighDate
FiftyTwoWeekLowDate
LastPriceChangePercent
DividendYield (TTM Yield)
DividendYieldAvgTtm
DividendYieldAvg3Y
DividendYieldAvg5Y
DividendYieldAvg10Y
DividendCagrTtm
DividendCagr3Y
DividendCagr5Y
DividendCagr10Y
TotalReturnTtm
TotalReturn3Y
TotalReturn5Y
TotalReturn10Y
PriceCagrTtm
PriceCagr3Y
PriceCagr5Y
PriceCagr10Y
TotalReturnCagrTtm
TotalReturnCagr3Y
TotalReturnCagr5Y
TotalReturnCagr10Y


Errors and Issues

If the return value is 'ERROR' then we had a problem. Most likely we don't have data for that stock symbol. We cover pretty much any US-listed stock and ETF.

Usage Restrictions

This tool may be used for your personal use only. No commercial use of this tool is permitted.


Disclaimers: FinanceCharts.com is not operated by a broker, a dealer, or a registered investment adviser. Under no circumstances does any information posted on FinanceCharts.com represent a recommendation to buy or sell a security. The information on this site is not intended to be, nor does it constitute, investment advice or recommendations. In no event shall FinanceCharts.com be liable to anyone using this site for any damages of any kind arising out of the use of any content or other material published or available on FinanceCharts.com, or relating to the use of, or inability to use, FinanceCharts.com or any content, including, without limitation, any investment losses, lost profits, lost opportunity, special, incidental, indirect, consequential or punitive damages. Past performance is a poor indicator of future performance. The information on this site is in no way guaranteed for completeness, accuracy, timeliness or in any other way.