FAQTechnical Queries
Why do some functions give me NA or N/A instead of a value?
You may get N/A or NA when there is no information for a given stock. This may have many causes. For example. The particular stock may not have information at a given time. The Stock in question may be in a different stock market to the ones you have subscribed to. There are many reasons that this might happen. Please ask our support team to look into it, we would be more than happy to help.
Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Stock screens
Public saved screens
Top 100 Gainers Today
Top 100 losers Today
Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Call: 1-877-778-8358
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONSGet started today
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started todayTop MarketXLS Rank stocks
Dick's Sporting Goods Inc
110.57
USD
8.33
(8.15%)
83
Rank
Optionable: Yes
Market Cap: 8,841 M
Industry: Specialty Retail
52 week range
63.45 142.78
Academy Sports and Outdoors Inc
45.32
USD
2.41
(5.62%)
79
Rank
Optionable: Yes
Market Cap: 3,614 M
Industry: Beer, Wine, and Liquor Stores
52 week range
25.10 51.51
Annaly Capital Management Inc
19.40
USD
-1.20
(-5.83%)
77
Rank
Optionable: Yes
Market Cap: 8,363 M
Industry: REIT - Diversified
52 week range
5.45 22.78
STORE Capital Corporation
31.63
USD
0.13
(0.41%)
75
Rank
Optionable: Yes
Market Cap: 8,941 M
Industry: REIT - Diversified
52 week range
24.48 36.13
Waste Connections Inc.
137.68
USD
-1.75
(-1.26%)
73
Rank
Optionable: Yes
Market Cap: 37,037 M
Industry: Waste Management
52 week range
113.50 148.20
Penske Automotive Group Inc.
100.84
USD
4.30
(4.45%)
73
Rank
Optionable: Yes
Market Cap: 7,684 M
Industry: Auto & Truck Dealerships
52 week range
88.58 126.93
General Mills Inc.
77.97
USD
-0.69
(-0.88%)
72
Rank
Optionable: Yes
Market Cap: 44,923 M
Industry: Packaged Foods
52 week range
59.14 81.24
Addus HomeCare Corporation
93.29
USD
1.34
(1.46%)
72
Rank
Optionable: Yes
Market Cap: 1,500 M
Industry: Medical Care
52 week range
68.57 108.11
National Research Corporation
39.70
USD
0.18
(0.46%)
71
Rank
Optionable: No
Market Cap: 948 M
Industry: Diagnostics & Research
52 week range
30.93 52.36
Williams-Sonoma Inc. (DE)
123.31
USD
2.12
(1.75%)
69
Rank
Optionable: Yes
Market Cap: 8,226 M
Industry: Specialty Retail
52 week range
101.58 223.32
