RealTimeToExcel Providers

RealTimeToExcel Providers

RealTimeToExcel includes providers for Yahoo! Finance, Google Finance and MSN Money.

The tables below show available fields and their synonyms.

You may switch from one provider to another. The field names remain the same.

Note that you may use field names without spaces, dashes or slashes.

For example, ExDividendDate instead of Ex-Dividend Date.

Fields with $ suffixes contain values of the underlying fields converted to numbers including values like 1.23B or 1.23M.

RealTimeToExcel Providers for Stocks

ValueSynonymsKSQQCSWMI
Stock Information
Symbol
Company NameName
Industry
Sector
Stock Exchange
Earnings Date
Trading Information
Last Trade Date
Last Trade Time
Last Trade DateTime
Bid
Ask
Bid Size
Ask Size
BidX
AskX
LastPrice
Change
Change In PercentPercent Change, % Change
Open
High
Low
Volume
Previous ClosePrev Close
Days Range
Stock Price History
Beta
52-Week Change
S&P500 52-Week Change
52-Week HighYear High
52-Week LowYear Low
52-Week High Date
52-Week Low Date
52-Week RangeYear Range
Change from 52-Week HighChange from Year High
Change from 52-Week LowChange from Year Low
% Change from 52-Week HighPercent Change from Year High
% Change from 52-Week LowPercent Change from Year Low
50-Day Moving AverageMA50
200-Day Moving AverageMA200
Change from 50-Day Moving AverageChange from MA50
Change from 200-Day Moving AverageChange from MA200
% Change from 50-Day Moving AveragePercent Change from MA50
% Change from 200-Day Moving AveragePercent Change from MA200
Avg Vol (3 Month)Average Daily Volume
Avg Vol (10 Day)
Valuation Measures
Market Cap
Market Cap $
Enterprise Value
Enterprise Value $
Enterprise Value Date
P/ETrailing P/E, PE, PE Ratio
Forward P/E
Forward P/E Date
PEG RatioPEG
Price/SalesP/S
Price/Book
Enterprise Value/Revenue
Enterprise Value/EBITDA
Estimates
One Year Target Price
Mean Recommendation
EPS Estimate Current YearEPS Est Current Year
EPS Estimate Next YearEPS Est Next Year
EPS Estimate Next QuarterEPS Est Next Quarter
P/E Estimate Current YearPrice/EPS Est Current Year
P/E Estimate Next YearPrice/EPS Est Next Year
Fiscal Year
Fiscal Year Ends
Most Recent Quarter
Profitability
Profit Margin
Operating Margin
Management Effectiveness
Return on Assets
Return on Equity
Income Statement
Revenue
Revenue $
Revenue Per Share
Qtrly Revenue Growth
Gross Profit
Gross Profit $
EBITDA
EBITDA $
Net Income Avl to Common
Net Income Avl to Common $
EPSDiluted EPS, Earnings/Share
Qtrly Earnings Growth
Balance Sheet
Total Cash
Total Cash $
Total Cash Per Share
Total Debt
Total Debt $
Total Debt/Equity
Current Ratio
Book Value Per ShareBook Value
Cash Flow Statement
Operating Cash Flow
Operating Cash Flow $
Levered Free Cash Flow
Levered Free Cash Flow $
Share Statistics
Shares Outstanding
Shares Outstanding $
Float
Float $
% Held by InsidersPercent Held by Insiders
% Held by InstitutionsPercent Held by Institutions
Shares Short
Shares Short $
Shares Short Date
Short Ratio
Short Ratio Date
Short % of FloatShort Percent of Float
Short % of Float DateShort Percent of Float Date
Shares Short (prior month)
Shares Short (prior month) $
Dividends & Splits
Forward Annual Dividend RateDividend/Share
Forward Annual Dividend YieldDividend Yield
Trailing Annual Dividend Rate
Trailing Annual Dividend Yield
5 Year Average Dividend Yield
Payout Ratio
Dividend DateDividend Pay Date
Ex-Dividend Date
Last Split Factor
Last Split Date

See field descriptions at https://help.yahoo.com/kb/finance/SLN2347.html.

RealTimeToExcel Providers for Historical Prices

ValueSynonymsDCGM
Stock Information
Symbol
Trading Information
Date
Open
High
Low
Close
Change
Change in PercentPercent Change, % Change
AdjClose
AdjChange
AdjChange in Percent
Volume
Prev DatePrevious Date
Prev OpenPrevious Open
Prev HighPrevious High
Prev LowPrevious Low
Prev ClosePrevious Close
Prev AdjClosePrevious AdjClose
Prev VolumePrevious Volume

RealTimeToExcel Providers for Options

ValueSynonymsSYGM
Stock Information
Symbol
Stock Exchange
Option Contract Information
Option Code
Strike
Expire DateExp Date, Expiry
Type
Trading Information
Last Trade Date
Last Trade Time
Last Trade DateTime
Bid
Ask
Last
Change
Change In PercentPercent Change, % Change
Open
High
Low
Volume
Open InterestOpen Int
Implied VolatilityImp Vol
Prev ClosePrevious Close
Days Range

RealTimeToExcel Providers for Currencies

ValueSynonymsCSM
Stock Information
Symbol
NameName
Trading Information
Last Trade Date
Last Trade Time
Last Trade DateTime
Bid
Ask
LastPrice
Change
Change In PercentPercent Change, % Change
Open
High
Low
Previous ClosePrev Close
Days Range
Stock Price History
52-Week HighYear High
52-Week LowYear Low
52-Week RangeYear Range
Change from 52-Week HighChange from Year High
Change from 52-Week LowChange from Year Low
% Change from 52-Week HighPercent Change from Year High
% Change from 52-Week LowPercent Change from Year Low

RealTimeToExcel Providers for Financial Reports