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 can switch from one provider to another. The field names remain the same.

Note that you can 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