How to Get Short Interest in Excel

Get short interest 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("ShortInterest", "MSFT", "", 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.

ABCDEFGHIJK
1trading_symboltitle_of_securitymarket_codesettlement_dateshorted_securitiesprevious_shorted_securitieschange_in_shorted_securitiespercentage_change_in_shorted_securitiesaverage_daily_volumedays_to_coveris_stock_split
2MSFTMicrosoft Corporation Common SNNM2026-08-146854495381311791-12766838-15.7334411522.05False
3MSFTMicrosoft Corporation Common SNNM2026-07-318131179192373474-11061683-11.97400183362.03False
4MSFTMicrosoft Corporation Common SNNM2026-07-15923734748906331633101583.72324225092.85False
5MSFTMicrosoft Corporation Common SNNM2026-06-308906331695188264-6124948-6.43606204781.47False
6MSFTMicrosoft Corporation Common SNNM2026-06-15951882648869612064921447.32364714182.61False
ABCDEF
1trading_symbolMSFTMSFTMSFTMSFTMSFT
2title_of_securityMicrosoft Corporation Common SMicrosoft Corporation Common SMicrosoft Corporation Common SMicrosoft Corporation Common SMicrosoft Corporation Common S
3market_codeNNMNNMNNMNNMNNM
4settlement_date2026-08-142026-07-312026-07-152026-06-302026-06-15
5shorted_securities6854495381311791923734748906331695188264
6previous_shorted_securities8131179192373474890633169518826488696120
7change_in_shorted_securities-12766838-110616833310158-61249486492144
8percentage_change_in_shorted_securities-15.7-11.973.72-6.437.32
9average_daily_volume3344115240018336324225096062047836471418
10days_to_cover2.052.032.851.472.61
11is_stock_splitFalseFalseFalseFalseFalse
Short interest represents the number of shares of a company that are currently sold short and have not yet been covered. The short interest ratio, also known as days to cover, represents the number of days it would take for all short-sold shares to be covered or repurchased in the market. Our Excel add-in provides short interest data for over 15,000 securities.

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 "ShortInterest".
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