Version History of RealTimeToExcel

Version 4.12.1, November 3, 2017

Yahoo Finance blocked several APIs on November 1, 2017.

The YahooFinanceQuotesCSV provider does not work now. Use YahooFinanceSummary instead.

Improvements:

Updated examples that includes actual providers only.
Updated YahooFinanceHistoricalDays provider.
Updated GoogleFinanceFinancials provider.

Version 4.12, November 9, 2016

Improvements:

New fields of the YahooFinanceKeyStatistics provider:
Earnings Date1, Earnings Date2,
Target High Price, Target Low Price, Target Mean Price, Target Median Price,
Recommendation Mean, Recommendation Key, Number Of Analyst Opinions
Number of rows in the trial period increased to 100 000.
Improved HTML provider and updated FinanzenNet Financials.xlsx.

Bug Fixes:

Fixed YahooFinanceSummary ChangeInPercent values.

Other changes:

Barchart.com improved their website.
However, the HTML provider can't load data now.
Barchart.com examples have been removed.

Version 4.11, November 2, 2016

Improvements:

You can get historical data from tables with auto-increment fields.
1. Get the MAX ID using formulas like this:

=RTD("gartle.rtd",,"<Database provider>","<Database table name>","ID")

2. Get other IDs using formulas.
3. Get values for retrieved IDs:

=RTD("gartle.rtd",,"<Database provider>","<Database table name>",<ID cell reference>,"BID")
=RTD("gartle.rtd",,"<Database provider>","<Database table name>",<ID cell reference>,"ASK")

Version 4.10, September 9, 2016

New Data Providers

New Yahoo! Finance providers allow getting historical prices for currency pairs.

Improvements:

Updated providers and RealTimeToExcel examples.

Bug Fixes:

Updated YahooFinanceFinancials provider.

Version 4.9, July 27, 2016

Improvements:

Updated providers and RealTimeToExcel examples.

Version 4.8, July 19, 2016

Improvements:

Updated YahooFinanceKeyStatistics provider.
Updated YahooFinanceSummary provider.
Updated YahooFinanceIndustries provider.

Known Issues:

YahooFinanceFinancials does not work due to Yahoo! Finance website changes on July 12, 2016.
We are working on resolving the issue.

Version 4.7, July 13, 2016

Improvements:

Updated YahooFinanceOptions provider.

Known Issues:

YahooFinanceKeyStatistics, YahooFinanceSummary, YahooFinanceIndustries, and YahooFinanceFinancials do not work due to Yahoo! Finance website changes on July 12, 2016.
We are working on resolving the issues.
You can use alternative providers including Google Finance and MSN Money providers.

Version 4.6, June 21, 2016

RealTimeToExcel has a new product website, www.stock-data-solutions.com.

Improvements:

The trial period is 30 days instead of 15 days before.
The new Strike~0 data field that returns ATM strike in YahooFinanceOptions, GoogleFinanceOptions, and MsnMoneyOptions providers.
MsnMoneyOptions can work with MSN Money stock codes like 126.1.AAPL.NAS.
The following providers are marked as obsolete: YahooFinanceWatchList, YahooFinanceQuotes, YahooFinanceStocks, YahooFinanceHistoricalData, and MsnMoneyQuotes.
Use new providers instead.

Version 4.5, April 20, 2016

Bug Fixes:

Updated MSN Money providers.
Incorrect values in the MsnMoneyQuotes2 provider for non-US regional settings.

Version 4.4, April 14, 2016

New Data Providers

MsnMoneyQuotes2
Use this provider to get data for international markets from MSN.

Bug Fixes:

Fixed getting MAX values from database tables if no one primary key is specified.

Version 4.3, March 15, 2016

New Data Providers

Improvements:

Fields have multiple synonyms to switch easily between providers.
See new field names here RealTimeToExcel Providers.
New example "1 - Try Me First.xlsx" in the RealTimeToExcel Examples folder that shows all the fields across providers.

Bug Fixes:

Fixed issues with installing on Windows XP.

Version 4.2, February 5, 2016

New Features

New YahooFinanceIndustry data provider with two fields: Sector and Industry.
Data source example: https://finance.yahoo.com/q/in?s=YHOO

Improvements:

New fields of YahooKeyStatistics with the suffix $ that hold numbers from text fields.
For example, if the Revenue field contains text like 234.99B, the Revenue$ field contains 234 990 000 000.
New fields of YahooKeyStatistics: Shares Short (prior month) and Shares Short (prior month)$.
Updated RealTimeToExcel examples.
Improved logging (via TraceDownload settings).

Bug Fixes:

Fixed issues with refreshing data.
Fixed issues with loading historical prices.
Fixed issues with loading options for symbols like ^VIX.
Fixed issues with periodic messages about errors of renaming and deleting files.

Version 4.1, November 11, 2015

New Features

Support for Microsoft Excel 2016 has been added.

Version 4.0, October 20, 2015

Licensing Changes

RealTimeToExcel End User License Agreement has been changed:

The free RealTimeToExcel Express edition has been removed.
Starting RealTimeToExcel 4.0 you can purchase and register RealTimeToExcel Personal, Standard and Enterprise editions only.
During a trial period of 15 days, you can test all the features of the RealTimeToExcel Enterprise edition.

You can continue to use previously registered versions of RealTimeToExcel Express for free forever.

Registering RealTimeToExcel Express of previous versions for new PC will be removed on December 1, 2015.

Please keep your registration email with the activation code to have a possibility to reinstall and activate RealTimeToExcel Express on a registered PC.

You may check your registration email and register once again before December 1, 2015. Do this using the previous versions.

Upgrade Notes

Previous versions of the RealTimeToExcel Personal, Standard or Enterprise editions may be upgraded for free.
Additional actions are not required.
Previous versions of the RealTimeToExcel Express edition are converted to a new trial version with a 15 day period.
After that period, you can purchase and register RealTimeToExcel Personal, Standard or Enterprise, or uninstall RealTimeToExcel 4.0 and install the previous version.
In the last case, if the previous version was registered, you can continue to use it without additional actions.

Download Package Changes

You can install RealTimeToExcel using RealTimeToExcel and RealTimeToDB packages.
The SaveToDB Suite package is not available more.
You can continue to use SaveToDB Wizard Tools for working with RealTimeToExcel installed separately.