MarginsX MarginsX
Excel add-in · =MX functions

MarginsX in your spreadsheet.

Type =MX.PRICE("AAPL") in a cell and get the price. The same add-in pulls any screener field, the revenue a company filed for a year or a quarter, daily closes as a table, a whole screen, and who holds the stock. It signs in with the API key you already have, and a sheet of 500 cells goes out as one request, not 500.

Functions
PRICE, FIELD, HISTORY, SCREEN, HOLDERS
Excel
Windows, Mac and the web
Sign-in
Your API key (sxc_…)
Cost
25 lookups = 1 unit
Install

Four steps, about a minute.

1

Get a key

Make one on your account page. A free account comes with 100 units a month.

2

Download the add-in

marginsx-excel-manifest.xml is the whole install: it points Excel at capital.sophiaxt.com.

3

Upload it

Home, then Add-ins, then More Add-ins, My Add-ins and Upload My Add-in. An admin can give it to everyone from the Microsoft 365 admin center, under Integrated apps.

4

Paste the key

Open MarginsX on the Home tab, paste the key, and type =MX. in any cell.

We plan to list this same add-in on Microsoft AppSource, Excel's own store. Until then, the upload above is the way in.

Functions

Five functions, plus a field finder.

Arguments in brackets are optional. A ticker can be written AAPL, BRK/B, BRK.B or NASDAQ:AAPL, and a CIK works too. Dates can be a date cell, 2026-11-13, 11/13/2026, or a step back from today: -30d, -6m, -1y.

=MX.PRICE(ticker, [date])

The latest price, or the close on a date. Without a date: the live price while the market is open, the last close otherwise. US, OTC and Canadian listings.

ticker
A ticker (AAPL, BRK/B, SHOP.TO) or a CIK (320193).
date
Optional. A date or a cell holding one: the close that day, or the last close before it.
=MX.PRICE("AAPL")=MX.PRICE("BRK/B", "2025-12-31")=MX.PRICE(A2, B1)

25 cells of lookups cost one unit.

=MX.FIELD(ticker, field, [period])

One figure from the screener or the filed financials. Without a period: the screener's current value, under the same names and labels as the screener's Excel export. With a period: the 10-K or 10-Q figure as filed (SEC XBRL).

ticker
A ticker (AAPL, BRK/B, SHOP.TO) or a CIK (320193).
field
A field name or its label: market_cap or "Market cap". =MX.FIELDS() lists them.
period
Optional. FY (latest year), FY-1, FY2025, FQ (latest quarter), FQ-2, 2026Q3, LTM.
=MX.FIELD("IREN", "market_cap")=MX.FIELD("AAPL", "revenue", "FY2025")=MX.FIELD("AAPL", "net_income", "FQ-1")=MX.FIELD("NVDA", "revenue", "LTM")

25 cells of lookups cost one unit.

=MX.HISTORY(ticker, start, [end], [dates])

Daily closes and volume between two dates, as a table that spills. Split-adjusted closes. A header row, then one row a trading day, oldest first.

ticker
A ticker (AAPL, BRK/B, SHOP.TO) or a CIK (320193).
start
The first day: a date, or -1y, -6m, -30d back from today.
end
Optional. The last day; today when left out.
dates
Optional. "serial" for Excel date numbers you can format; ISO text (2026-11-13) when left out.
=MX.HISTORY("AAPL", "-1y")=MX.HISTORY("IREN", "2025-01-01", "2025-12-31", "serial")

One unit a table.

=MX.SCREEN(criteria, [fields], [limit], [sort])

The companies that pass a screen, as a table that spills. Operators: = != > >= < <= in (values split by |), not in, contains, starts with. Numbers take k, m, b and t: 300m, 2b.

criteria
Conditions joined by ; or AND: "market_cap > 1b; sector = Technology; pe < 20". Or a saved screen: "screen:12".
fields
Optional. Columns, comma separated: "ticker, company, market_cap, pe".
limit
Optional. Rows, 50 when left out; up to your plan's page size.
sort
Optional. A field, with - for largest first: "-market_cap".
=MX.SCREEN("market_cap > 2b; sector = Technology; pe < 25", "ticker, company, market_cap, pe", 25, "-market_cap")=MX.SCREEN("screen:12")

One unit a table.

=MX.HOLDERS(ticker, [type], [limit])

Insiders, 5% holders, institutions and funds, as a table that spills. Ownership is on the paid plans; a free key's cell says so.

ticker
A ticker (AAPL, BRK/B, SHOP.TO) or a CIK (320193).
type
Optional. insider, 5pct, 13f or fund; every holder when left out.
limit
Optional. Rows, 25 when left out.
=MX.HOLDERS("IREN")=MX.HOLDERS("AAPL", "13f", 50)

One unit a table.

=MX.FIELDS([search])

The fields FIELD and SCREEN take, with their labels and the periods they need. Costs no units.

search
Optional. Words to look for in a field's name or label: "margin".
=MX.FIELDS()=MX.FIELDS("debt")

No units.

Units and limits

One request per recalculation.

Batching

Excel asks for every =MX cell when a sheet recalculates. The add-in waits until Excel stops asking, then sends every distinct call in one request, up to 1,000 at a time. Identical cells are asked once.

Units

Each request counts against your plan's monthly units, like any API call: one unit per 25 PRICE or FIELD lookups, one unit per HISTORY, SCREEN or HOLDERS table. MX.FIELDS is free. A key check costs nothing.

Caching

Each answer stays in the add-in for as long as it can't change: 30 seconds for a live price, 15 minutes for a screener field, an hour for filed figures and holders, a day for a past close. Recalculating within that time asks for nothing. Refresh in the pane clears it.

Plan limits

The plan's per-minute rate and monthly units apply to the key. Past them, the cells say so: the add-in waits out a short rate limit and shows #BUSY! meanwhile; a used-up month shows #N/A with the reset date and the upgrade link. SCREEN and HOLDERS return up to your plan's page size, HISTORY up to its paging depth. Ownership is on the paid plans.

Errors

A cell that can't answer shows #N/A, and hovering over it shows why: no key yet, a ticker we don't track, no figure filed for that period, or a plan limit. A malformed argument shows #VALUE! with what it expects.

PlanUnits a monthRequests a minute
Free10010
Founder5,00030
Investor25,00060
Firm100,000120

Prices come from free public quote feeds, real time for most US listings and 15 to 20 minutes delayed where a feed says so; they are not licensed for resale. Filed figures come from SEC XBRL, the screener's fields from our own data layer. Plans and overage are on the developer page.

Fields

The names match the screener's export.

FIELD and SCREEN take a field's name or its label, so "market_cap" and "Market cap" are the same column as in the screener's Excel export. Without a period FIELD reads the screener's current value; with FY, FQ or LTM it reads the 10-K or 10-Q. =MX.FIELDS("margin") finds fields from inside Excel.

Every field, with the periods it takes
FieldLabelPeriod
cikCIKNow
companyCompanyNow
tickerTickerNow
sectorSectorNow
regionState / provinceNow
countryCountryNow
listed_onListed onNow
market_capMarket capNow
exchangeExchangeNow
otc_tierOTC marketNow
venueMarketNow
industryIndustryNow
listing_sectorSector (listing)Now
sector_basisSector basisNow
listing_industryIndustry (listing)Now
tierSize tierNow
cap_basisMarket cap basisNow
listing_countryCountry of the issuer (listing data)Now
primary_listingPrimary listingNow
pricePriceNow
change_pctChange %Now
volumeVolumeNow
ipo_yearIPO yearNow
ipo_dateIPO year (as a date)Now
as_ofAs ofNow
r_1w1-week return %Now
r_1m1-month return %Now
r_3m3-month return %Now
r_6m6-month return %Now
r_ytdYTD return %Now
r_1y1-year return %Now
r_3y3-year return %Now
r_5y5-year return %Now
high_52w52-week highNow
low_52w52-week lowNow
from_high% from 52-week highNow
from_low% from 52-week lowNow
new_highNew 52-week highNow
new_lowNew 52-week lowNow
ma5050-day averageNow
ma200200-day averageNow
above_ma50Above 50-day averageNow
above_ma200Above 200-day averageNow
avg_vol20Average volume (20-day)Now
relvolRelative volume (vs 20-day)Now
vol_30dVolatility, 30-day %Now
vol_90dVolatility, 90-day %Now
beta_1yBeta, 1 year (vs SPY)Now
max_drawdown_1yMax drawdown, 1 year %Now
atr_14_pctAverage daily move, 14-day %Now
avg_volume_30dAverage volume (30-day)Now
avg_dollar_volume_30dAverage dollar volume (30-day)Now
pcr_volumePut/call ratio (volume)Now
pcr_oiPut/call ratio (open interest)Now
atm_ivImplied volatility, next expiry %Now
iv_30dImplied volatility, ~30 days %Now
expected_move_pctExpected move to next expiry %Now
unusual_optionsUnusual option contractsNow
unusual_premiumUnusual option premiumNow
business_segmentsBusiness segmentsNow
largest_segmentLargest segmentNow
largest_segment_share_pctLargest segment, share of revenue %Now
geographic_regionsGeographic regionsNow
non_us_revenue_pctRevenue outside the US %Now
home_listingHome listing (Canada)Now
dividend_ttmDividends, last 12 monthsNow
dividend_yield_pctDividend yield %Now
forward_dividend_yield_pctForward dividend yield %Now
dividend_payout_pctDividend payout ratio %Now
dividend_growth_yearsYears of dividend growthNow
dividend_frequencyDividends a yearNow
last_ex_dividendLast ex-dividend dateNow
total_return_1y_pct1-year total return %Now
total_return_3y_pct3-year total return %Now
total_return_5y_pct5-year total return %Now
insider_pctInsider ownership %Now
inst_pctInstitutional ownership %Now
insider_as_ofInsider % as ofNow
insider_filingInsider % filingNow
insider_pct_reasonWhy insider % is blankNow
inst_as_ofInstitutional % as ofNow
inst_filed_through13F filed throughNow
inst_pct_reasonWhy institutional % is blankNow
own_shares_outOwnership share countNow
own_shares_out_dateOwnership share count as ofNow
own_shares_out_filingOwnership share count filingNow
inst_change_pctInstitutional change, last quarterNow
fivepct_pct5% holders %Now
float_pctEstimated float %Now
shares_outShares outstandingNow
shares_out_dateShares outstanding as ofNow
fully_diluted_sharesFully diluted sharesNow
overhang_pctDilution overhang %Now
fully_diluted_valueFully diluted valueNow
warrant_sharesWarrant sharesNow
convertible_sharesConvertible sharesNow
float_sharesEstimated float (shares)Now
fiscal_yearFiscal year (latest annual)Now
revenueRevenueNow
net_incomeNet incomeNow
cashCashNow
revenue_growthRevenue growth %Now
net_marginNet margin %Now
peP/ENow
psP/SNow
profitableProfitable (latest year)Now
fundamentals_currencyReported currencyNow
ttm_revenueRevenue (TTM)Now
ttm_net_incomeNet income (TTM)Now
ttm_fcfFree cash flow (TTM)Now
gross_marginGross margin % (TTM)Now
operating_marginOperating margin % (TTM)Now
fcf_marginFree cash flow margin % (TTM)Now
total_debtTotal debtNow
net_cashNet cash (cash less debt)Now
net_debtNet debt (debt less cash)Now
debt_to_incomeDebt to income (years)Now
debt_to_ebitdaDebt to EBITDANow
debt_to_equityDebt to equityNow
interest_coverageInterest coverageNow
current_ratioCurrent ratioNow
debt_to_revenueDebt to revenueNow
related_party_revenue_pctRelated-party revenue %Now
top_customer_pctLargest customer % of revenueNow
quarter_endLatest quarter endNow
eps_diluted_ttmEPS, diluted (TTM)Now
eps_basic_ttmEPS, basic (TTM)Now
eps_diluted_ttm_reportedEPS, diluted (TTM), reporting currencyNow
eps_basic_ttm_reportedEPS, basic (TTM), reporting currencyNow
eps_basisEPS basisNow
book_value_per_shareBook value per shareNow
pbP/BNow
tangible_book_per_shareTangible book value per shareNow
p_tbvP/TBVNow
book_ex_aoci_per_shareBook value per share ex-AOCINow
pb_ex_aociP/B ex-AOCINow
book_sharesBook value share countNow
book_shares_as_ofBook value share count as ofNow
book_basisBook value inputsNow
roeROE % (TTM)Now
roaROA % (TTM)Now
ratio_basisROE and ROA inputsNow
quarter_formLatest quarter formNow
quarter_filedLatest quarter filedNow
quarter_filingLatest quarter filingNow
quarter_currencyLatest quarter currencyNow
enterprise_valueEnterprise valueNow
ev_salesEV/SalesNow
ev_ebitdaEV/EBITDANow
ev_ebitEV/EBITNow
ev_inputsEV inputsNow
runway_monthsCash runway (months)Now
quarterly_burnQuarterly cash burnNow
dilution_1yShare dilution 1 year %Now
dilution_3yShare dilution 3 years %Now
going_concernGoing-concern warningNow
reverse_split_3yReverse split in 3 yearsNow
offering_12mShelf or ATM offering in 12 monthsNow
exchange_notice_12mExchange deficiency notice in 12 monthsNow
auditor_change_24mAuditor change in 24 monthsNow
late_filing_12mLate filing notice in 12 monthsNow
insider_net_6mInsider net buying, 6 monthsNow
insider_net_12mInsider net buying, 12 monthsNow
insider_buyers_12mInsiders buying, 12 monthsNow
red_flagsRed flags (count)Now
reporting_statusSEC reporting statusNow
auditorAuditorNow
next_trial_completionNext trial primary completionNow
active_trialsActive clinical trialsNow
enforcement_3ySEC enforcement action in 3 yearsNow
trading_suspension_everSEC trading suspension, everNow
deal_8k_12m8-K deal items in 12 monthsNow
bank_leverage_ratioBank tier 1 leverage ratio %Now
bank_capital_ratioBank total risk-based capital ratio %Now
last_signalNewest research signalNow
signals_30dResearch signals in 30 daysNow
signals_90dResearch signals in 90 daysNow
signal_types_90dSignal types in 90 daysNow
guidance_lastNewest company guidanceNow
guidance_last_changeNewest guidance changeNow
guidance_raised_90dRaised guidance in 90 daysNow
guidance_lowered_90dLowered guidance in 90 daysNow
guidance_fyGuided fiscal yearNow
guidance_revenue_lowGuided revenue, lowNow
guidance_revenue_highGuided revenue, highNow
guidance_eps_lowGuided EPS, lowNow
guidance_eps_highGuided EPS, highNow
guidance_eps_basisGuided EPS basisNow
guidance_surprise_pctGuidance surprise %Now
guidance_surprise_metricGuidance surprise metricNow
guidance_surprise_periodGuidance surprise periodNow
revenueRevenueFY
net_incomeNet incomeFY
operating_incomeOperating incomeFY
op_cash_flowOperating cash flowFY
assetsTotal assetsFY
liabilitiesTotal liabilitiesFY
equityShareholders' equityFY
cashCash and equivalentsFY
shares_outShares outstandingFY
period_endPeriod endFY
fiscal_yearFiscal yearFY
currencyCurrencyFY
period_endPeriod endFQ
period_startPeriod startFQ
period_monthsMonths in periodFQ
fyFiscal yearFQ
fpFiscal periodFQ
latestLatest period for the companyFQ
currencyCurrencyFQ
revenueRevenueFQ
gross_profitGross profitFQ
operating_incomeOperating incomeFQ
net_incomeNet incomeFQ
op_cash_flowOperating cash flowFQ
capexCapital expenditureFQ
fcfFree cash flowFQ
cashCash and equivalentsFQ
total_debtTotal debtFQ
shares_outShares outstandingFQ
shares_dateShares as ofFQ
shares_basisShare count basisFQ
ttm_revenueRevenue, TTMFQ, LTM
ttm_gross_profitGross profit, TTMFQ, LTM
ttm_operating_incomeOperating income, TTMFQ, LTM
ttm_net_incomeNet income, TTMFQ, LTM
ttm_op_cash_flowOperating cash flow, TTMFQ, LTM
ttm_capexCapital expenditure, TTMFQ, LTM
ttm_fcfFree cash flow, TTMFQ, LTM
formFormFQ
filedFiledFQ
interest_expenseInterest expenseFQ
ttm_interest_expenseInterest expense, TTMFQ, LTM
daDepreciation and amortizationFQ
ttm_daDepreciation and amortization, TTMFQ, LTM
equityShareholders' equityFQ
current_assetsCurrent assetsFQ
current_liabilitiesCurrent liabilitiesFQ
long_term_debtLong-term debt, noncurrentFQ
debt_currentDebt, current portionFQ
related_party_revenueRevenue from related partiesFQ
ttm_related_party_revenueRevenue from related parties, TTMFQ, LTM
related_party_receivablesDue from related partiesFQ
related_party_payablesDue to related partiesFQ
top_customer_pctCustomer concentration %FQ
top_customer_basisConcentration basisFQ
fiscal_yearFiscal yearFQ
FAQ

Questions.

Where does my key go?

Into the add-in's own storage on your computer, and only ever to capital.sophiaxt.com in the Authorization header. The add-in's code has no key in it. Remove it from the pane any time, or revoke it on your account page.

Do prices update by themselves?

They update when the sheet recalculates and the cached answer has expired: 30 seconds for a live price. Press F9, edit a cell, or use Refresh in the pane.

Does it work on a Mac and in a browser?

Yes: Excel on Windows and Mac with Microsoft 365, Excel 2019 or later on a Mac, and Excel on the web. It needs Excel's shared runtime, which Excel 2016 and 2019 for Windows bought outright don't have.

Can I pull a saved screen?

Yes. =MX.SCREEN("screen:12") runs screen 12 from your account with its own columns; the number is in the screen's address in the app.

What if a company didn't tag a figure?

The cell shows #N/A and says the report has no such figure. We never fill a gap with an estimate.