Yahoo Finance data selectors

Yahoo Finance abounds with data for each market stock or crypto. Bellow are the configured data selectors you can use within your =IMPORTFROMWEB( ) function; just pick them up directly in our Yahoo Finance scraper template or use them by yourself in your own spreadsheet.

To use the =IMPORTFROMWEB function, you need to input the selector into the function or refer to a cell / range of cells that contain selectors. For example, if you are looking for the volume and the market cap of a company’ stock, just write:

=IMPORTFROMWEB("url", "volume, marketCap")
=IMPORTFROMWEB(A2,B1:C1)
SelectorsDescription
shortRatiowidely-used tool by short selling hedge funds and other portfolio managers in the stock market
websitewebsite
volumevolume $$ exchanged on the share during the day
forwardPEversion of the ratio of price-to-earnings that uses forecasted earnings for the P/E calculation
priceToSalesvaluation ratio that compares a company’s stock price to its revenues
exDividendDateusually set one business day before the record date
heldbyInsidersthe total number of shares owned by a firms board of directors, executives, and senior officer
marketCapthe total dollar market value of a company’s outstanding shares of stock
dividendYieldThe dividend yield is a financial ratio that tells you the percentage of a company’s share price that it pays out in dividends each year.
earningsDatethe date of the next release of a company’s financial report
floatthe act of moving a currency to a floating exchange rate
symbolsymbol related to the company’s name in the financial markets
sharesShortshares that have been sold in the open market, with the assumption that the stock price will go down
previousCloseshare price at the close of business the day before
sectorsector of the company
trailingPErelative valuation multiple that is based on the last 12 months of actual earnings
trailingPErelative valuation multiple that is based on the last 12 months of actual earnings
bidrefers to a two-way price quotation that indicates the best potential price at which a security can be sold and bought at a given point in time
askrefers to a two-way price quotation that indicates the best potential price at which a security can be sold and bought at a given point in time
payoutRatioproportion of earnings a company pays its shareholders in the form of dividends, expressed as a percentage of the company’s total
openprice at the opening of the stock market
phonephone name
perTTMpe ratio
noOfAnnalystsNextYearNumber of analysts next year
noOfAnnalystsNextQuarternumber of analysts for the next quarter
noOfAnnalystsCurrentYearNumber of analysts for the current year
noOfAnalystsCurrentQuarterNumber of analysts for the current quarter
exchangeNamename of the market place where the shares are sold
pegRatio5ymeasures of the value of a company against its earnings and growth rate
entrepriseValuemeasure of a company’s total value, often used as a comprehensive alternative to equity market capitalization
ebitdameasure of a company’s overall financial performance
52WeekLowlowest price over the last 52 weeks
dayLowlowest price of the day
exDividendDatelast dividend date
priceToBookIt compares a company’s market price to its book value
industryindustry of the company
52WeekHighHighest price over the last 52 weeks
dayHighhighest price of the day
profitMargingauges the degree to which a company or a business activity makes money, essentially by dividing income by revenues
fullTimeEmployeeFull-time employee number listed in the company
lastSplitFactorexplanation of the split of the stock
1yTargetEstestimate of the price in one year
dividenddistribution of profits by a corporation to its shareholders
bookValuePerSharedifference between that company’s total assets and total liabilities, and not its share price in the market
descriptiondescription of the company
dividendDatedate of the next dividend
lastSplitDatedate of the last split
fiscalYearEndsdate of the fiscal year
regularMarketPricecurrent market price
namecompany name
statecompany is located in this state
countrycompany is located in this country
citycompany is located in this city
grossProfitcalculated by subtracting the cost of goods sold from revenue
epscalculated as a company’s profit divided by the outstanding shares of its common stock.
netIncomeAvitoCommonbottom-line profit belonging to the common stockholders
avgVolumeaverage volume $$ traded on the stock
avgEstimateNextQuarterAverage estimate for the next quarter
avgEstimateCurrentYearaverage Estimate Current year
avgEstimateCurrentQuarterAverage Estimate Current Quarter
revenueamount of revenue
adressadress of the company
beta5Y5 years of historical price data
avgEstimateNextYear
lowEstimateCurrentQuarter
lowEstimateNextQuarter
lowEstimateCurrentYear
lowEstimateNextYear
highEstimateCurrentQuarter
highEstimateNextQuarter
highEstimateCurrentYear
highEstimateNextYear
yearsAgoEpsEstimateCurrentQuarter
yearsAgoEpsEstimateNextQuarter
yearsAgoEpsEstimateCurrentYear
yearsAgoEpsEstimateNextYear
noOfAnalystsCurrentQuarter
noOfAnalystsNextQuarter
noOfAnalystsCurrentYear
noOfAnalystsNextYear
avgEstimateCurrentQuarter
avgEstimateNextQuarter
avgEstimateCurrentYear
avgEstimateNextYear
lowEstimateCurrentQuarter
lowEstimateNextQuarter
lowEstimateCurrentYear
lowEstimateNextYear
highEstimateCurrentQuarter
highEstimateNextQuarter
highEstimateCurrentYear
highEstimateNextYear
yearAgoSalesCurrentQuarter
yearAgoSalesNextQuarter
yearAgoSalesCurrentYear
yearAgoSalesNextYear
salesGrowthCurrentQuarter
salesGrowthNextQuarter
salesGrowthCurrentYear
salesGrowthNextYear
epsEst3monthAgo
epsEst6monthAgo
epsEst9monthAgo
epsEst12monthAgo
epsActual3monthAgo
epsActual6monthAgo
epsActual9monthAgo
epsActual12monthAgo
epsDifference3monthAgo
epsDifference6monthAgo
epsDifference9monthAgo
epsDifference12monthAgo
suprise3monthAgo
suprise6monthAgo
suprise9monthAgo
suprise12monthAgo
currentEstimateCurrentQuarter
currentEstimateNextQuarter
currentEstimateCurrentYear
currentEstimateNextYear
7daysAgoCurrentQuarter
7daysAgoNextQuarter
7daysAgoCurrentYear
7daysAgoNextYear
30daysAgoCurrentQuarter
30daysAgoNextQuarter
30daysAgoCurrentYear
30daysAgoNextYear
60daysAgoCurrentQuarter
60daysAgoNextQuarter
60daysAgoCurrentYear
60daysAgoNextYear
90daysAgoCurrentQuarter
90daysAgoNextQuarter
90daysAgoCurrentYear
90daysAgoNextYear
upLast7Days
upLast30Days
downLast7Days
downLast30Days
currentQtr
nextQtr
currentYear
nextYear
next5Years
past5Years
%ofSharesHeldbyAllInsider
%ofSharesHeldbyInstitutions
%ofFloatHeldbyInstitutions
numberofInstitutionsHoldingShares
institutionOwnershipHolder
institutionOwnershipShares
institutionOwnershipDateReported
institutionOwnershipOut
institutionOwnershipValue
fundOwnershipHolder
fundOwnershipShares
fundOwnershipDateReported
fundOwnershipOut
fundOwnershipValue
entrepriseToRevenue
entrepriseToEbitda
52WeekChange
sp500_52WeekChange
50DayMovingAverage
200DayMovingAverage
AvgVol3m
AvgVol10d
sharesOutstanding
impliedSharesOutstanding
heldbyInstitutions
short%ofFloat
short%ofSharesOutstanding
sharesShortprior
forwardAnnualDividendRate
forwardAnnualDividendYield
trailingAnnualDividendRate
trailingAnnualDividendYield
5YearAverageDividendYield
mostRecentQuarter
operatingMargin
returnonAssets
returnonEquity
revenuePerShare
quarterlyRevenueGrowth
dilutedEPS
quarterlyEarningsGrowth
totalCash
totalCashPerShare
totalDebt
totalDebtPerEquity
currentRatio
operatingCashFlow
leveredFreeCashFlow
keyExecutivesName
keyExecutivesTitle
keyExecutivesPay
keyExecutivesYearBorn
auditRisk
boardRisk
compensationRisk
shareHolderRightsRisk
overallRisk
totalESGRiskscore
environmentRiskScore
socialRiskScore
governanceRiskScore
significantControversylevel