Version History of MARKET.RTD

Version History of MARKET.RTD

Version 5.34, March 6, 2024

Bug fixes:

  • Yahoo Finance error 429 fixed.

Version 5.33, January 31, 2024

New features:

  • You may temporarily disable data download using the formula:
    =RTD("market.rtd",,"rtd_server_stop_download",1)

Improvements:

  • Removed non-working MSN Money providers.
  • Updated example workbooks.

Bug fixes:

  • Yahoo Finance options cookie-related errors.
  • Poloniex provider errors.

Version 5.32, August 23, 2023

Bug fixes:

  • Yahoo Finance crumb-related errors.

Version 5.31, August 10, 2023

MSN Money providers do not work due to changes on the MSN Money website.

Yahoo Finance providers work. If you have issues, please run the Download Tester from the Market.rtd folder and click Go.
Then send the results to us.

Bug fixes:

  • Yahoo Finance crumb-related errors.

Version 5.30, July 28, 2023

Bug fixes:

  • YahooFinanceSummary shows the Unauthorized error.
  • YahooFinanceAssetProfiles shows the Unauthorized error.

Version 5.29, June 8, 2023

Important notes: Market.rtd authenticates Yahoo Finance requests itself. It does not use Authenticator.exe.

Bug fixes:

  • YahooFinanceQuotes shows #N/A.

Version 5.28, May 31, 2023

Bug fixes:

  • YahooFinanceQuotes shows #N/A on Windows 11.

Version 5.27, May 29, 2023

Important notes: Yahoo Finance protected their API used by the YahooFinanceQuotes provider.
Market.rtd contains a new app, Authenticator.exe, used to acquire the required cookie and crumb.
It launches the app once on opening a workbook that uses the YahooFinanceQuotes provider. You may see a window launch.
If you see #N/A with the error message later, please, run Formula Builder, select YahooFinanceQuotes, and click Go.
You have to see the correct data. Then reopen Excel workbook.

Bug fixes:

  • YahooFinanceQuotes shows #N/A with messages like "Invalid Cookie" or "Invalid Crumb".
  • A window blinks on opening Excel workbook.
  • TradingDate shows #N/A.

Version 5.26, May 26, 2023

Bug fixes:

  • YahooFinanceQuotes shows #N/A with messages like "Invalid Cookie" or "Invalid Crumb".

Version 5.25, May 8, 2023

Bug fixes:

  • YahooFinanceQuotes shows #N/A with messages like "Invalid Cookie" or "Invalid Crumb".

Version 5.24, January 23, 2023

Improvements:

  • Updated examples
  • Updated DBEdit
  • Updated Product Registration Wizard
  • Updated AutoUpdate

Bug fixes:

  • All formulas show #N/A.

Version 5.23, December 13, 2022

Improvements:

  • Removed obsolete providers: MsnMoneyAnalysis, TickerBitstamp, TickerBittrex, TickerCryptopia, TickerCoinMarketCap, TickerGDAX
  • Updated examples
  • Updated DBEdit
  • Updated Product Registration Wizard
  • Updated AutoUpdate

Bug fixes:

  • The AutoUpdate tool reports about DBEdit instead of MARKET.RTD.
  • Big integers are returned as strings.

Version 5.22, July 5, 2022

New features:

  • MARKET.RTD includes the DBEdit tool to check downloaded data in the internal SQLite database.
    Use the following path to open the database:
    %LOCALAPPDATA%\Gartle\Market.rtd\DataCache\market.rtd.db
    Later you can open the file using the recent menu. Also, you can save a workbook in your favorite place.

Improvements:

  • The registration wizard and the AutoUpdate tool are available in Portuguese, Simplified Chinese, Traditional Chinese, Japanese, and Korean.
  • MSN Money Currency provider is removed as the data are not available at MSN Money.

Bug fixes:

  • Historical prices are empty when the decimal separator is comma.

Version 5.21, March 22, 2021

New features:

  • MARKET.RTD includes the AutoUpdate tool to check and install updates.
  • A new rtd_server_path field shows the installation path.

Improvements:

  • MARKET.RTD compiled for .NET Framework 4.7.2.
  • Updated examples

Version 5.20, June 30, 2020

Improvements:

  • YahooFinanceOptions allows enumerating options expiration dates using columns ExpDate1, ExpDate2, and so on.
    Also, it allows getting the previous and the next expiration dates using columns ExpDate-1 and ExpDate+1.
    The total number of active expiration dates is available through the ExpDateCount column.
    You can find a sample of using new formulas in the updated Yahoo Finance Options.xlsx workbook.
  • The registration wizard is available in German.

Bug fixes:

  • The registration wizard raises NullReferenceException.

Version 5.19, February 28, 2020

Gartle Technology Corporation changed its name to Gartle LLC.

Changes:

  • Updated EULA
  • Updated examples
  • Improved registration wizard
  • Improved activation in a virtual environment

Version 5.18, July 10, 2019

Improvements:

  • Updated URLs for MSN Money
  • An updated parser of options from MSN Money
  • Updated examples

Version 5.17, July 25, 2018

New features:

  • A monthly subscription is available.
  • The product tries to activate a new subscription three days before and three days after the expiration.
    It sends requests automatically every 16 hours. You can disable this feature in the finishing step of the registration wizard.

Improvements:

  • Added fields of earnings and dividends in the YahooFinanceQuotes and YahooFinanceSummary providers

Version 5.16, June 22, 2018

The free MARKET.RTD edition is no longer available.

Existing users of the free edition can continue to use it.

Version 5.15, June 7, 2018

Bug fixes:

  • Fixed bugs with codes like BRK-B, BRK-B180720C00195000, and 126.1.BRK/B.NYS.

Version 5.14, May 31, 2018

Bug fixes:

  • Fixed issues with getting historical prices and options with non-US regional settings

Version 5.13, May 25, 2018

Improvements:

  • Removed obsolete providers:
    - GoogleFinanceFinancials
    - GoogleFinanceHistoricalPricesCSV
    - TmxMoneyFinancials
    - YahooFinanceQuotesCSV
  • Updated examples
  • Product Registration Wizard uses HTTPS

Version 5.12, May 24, 2018

Improvements:

  • Updated Product Registration Wizard

Version 5.11, April 23, 2018

New data providers for Canadian stocks:

  • TmxFinancials
  • TmxMoneyQuotes

Data source: tmxmoney.com

Improvements:

  • New and updated examples

Version 5.10, February 7, 2018

New data providers for cryptocurrencies:

  • TickerBithumb
  • TickerCoinMarketCap
  • TickerGDAX
  • TickerGemini

Improvements:

  • Updated Product Registration Wizard
  • Updated examples

Bug fixes:

  • Fixed licensing issues with historical prices

Version 5.9, January 24, 2018

New data providers for cryptocurrencies:

  • TickerBinance
  • TickerBitfinex
  • TickerBitstamp
  • TickerBittrex
  • TickerCryptopia
  • TickerHitbtc
  • TickerKraken
  • TickerPoloniex

Try the CryptoCurrencies.xlsx example first and Formula Builder then to get formulas for all available topics.

Version 5.8, December 15, 2017

Improvements:

  • GoogleFinanceHistoricalPricesCSV loads historical prices starting January 1, 2013.
    You can change the start date in the market.rtd.dll.config file.

Version 5.7, December 13, 2017

Improvements:

  • Updated examples

Bug fixes:

  • Fixed issues with updating.
  • Fixed issues with empty tickers and tickers with trailing spaces.
  • Fixed issues with loading options from Yahoo Finance.
  • Fixed issues with loading options from MSN Money.
  • Fixed issues with loading data from Google Finance.
  • Fixed issues with log file copies.

Version 5.6, November 3, 2017

Yahoo Finance blocked several APIs on November 1, 2017.

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

The YahooFinanceCurrencies uses an alternative Yahoo Finance data source now and loads data by separate requests.

Improvements:

  • Updated examples to address issues with Yahoo Finance and Google Finance changes.
  • The Google Finance Financials provider uses an updated URL.
  • The YahooFinanceCurrencies provider uses an alternative Yahoo Finance data source.

Bug fixes:

  • Registration wizard WebException in the offline mode

Version 5.5, August 22, 2017

Breaking changes:

  • Changed .NET platform from .NET Framework 4.0 Client Profile to .NET Framework 4.5.2
  • Changes in requirements for Windows 7, Windows Server 2008, and Windows Server 2008 R2
  • Removed support of Windows XP

Improvements:

  • Updated examples

Bug Fixes:

  • Issues with a fractional part of dates in Yahoo Finance historical prices
  • Issues with registering products

Version 5.4, August 1, 2017

New data providers:

  • MsnMoneyFundQuotes
  • MsnMoneyFundHistoricalPrices

New examples:

  • Google Finance Historical Prices Chart.xlsx
  • MSN Money Fund Historical Prices Chart.xlsx
  • MSN Money Funds.xlsx
  • MSN Money Historical Prices Chart.xlsx
  • Yahoo Finance Historical Prices Chart.xlsx

Improvements:

  • Significantly improved performance of getting historical prices
  • Updated MsnMoneyQuotes provider
  • Updated Formula Builder
  • Changed default refresh intervals

Version 5.3, July 5, 2017

New data providers:

  • MsnMoneyAnalysis

Improvements:

  • YahooFinanceHistoricalPrices loads prices for five years.
  • Updated registration wizard
  • Updated installer
  • Improved diagnostic messages

Version 5.2, May 31, 2017

Improvements:

  • Removed YahooFinanceHistoricalPricesCSV provider disabled by Yahoo Finance.
    Use YahooFinanceHistoricalPrices, GoogleFinanceHistoricalPricesCSV, or MsnMoneyHistoricalPrices instead.
  • Updated examples
  • Updated installer
  • Updated documentation

Version 5.1, May 11, 2017

Improvements:

  • Spanish translation in the RegisterProduct wizard
  • Improved documentation

Version 5.0, May 1, 2017

MARKET.RTD 5.0 is a major upgrade of RealTimeToExcel.

The new name reflects the main application role, loading market data using RTD formulas.

Marker.rtd has a new name of the RTD server: market.rtd instead of gartle.rtd. You can continue using RealTimeToExcel.

Existing users can install MARKET.RTD as a new product, test it, and purchase the upgrade. See upgrade notes.

We redesign the application, data providers, and documentation.

We have tried to make the product as simple as possible to make the learning curve much shorter.

Licensing Changes

MARKET.RTD has a new free edition that allows getting data for ten tickers.

Paid editions have a new simplified model of limits. The Personal and Standard editions have increased the limits of updated tickers.

See Edition Comparison.

Registration is required to start a trial.

MARKET.RTD is available as a subscription.

Major upgrades become paid. You can purchase the Upgrade Warranty with new purchases to get major upgrades for free.

New features:

  • Formula Builder
  • Redesigned and improved data providers
  • Rewritten documentation
  • Simplified model of edition limits
  • Subscription model
  • SQLite as storage for loaded data

New data providers:

  • YahooFinanceFutures
  • YahooFinanceIntradayPrices15m
  • YahooFinanceIntradayPrices30m
  • YahooFinanceIntradayPrices60m

Renamed data providers:

  • GoogleFinanceHistoricalCSV -> GoogleFinanceHistoricalPricesCSV
  • MsnMoneyHistorical15min -> MsnMoneyIntradayPrices15m
  • MsnMoneyHistorical5min -> MsnMoneyIntradayPrices5m
  • MsnMoneyHistoricalDays -> MsnMoneyHistoricalPrices
  • MsnMoneyHistoricalMonths -> MsnMoneyHistoricalPricesMonthly
  • MsnMoneyHistoricalWeeks -> MsnMoneyHistoricalPricesWeekly
  • MsnMoneyQuotes2 -> MsnMoneyQuotes
  • YahooFinanceHistorical1min -> YahooFinanceIntradayPrices1m
  • YahooFinanceHistorical5min -> YahooFinanceIntradayPrices5m
  • YahooFinanceHistoricalCSV -> YahooFinanceHistoricalPricesCSV
  • YahooFinanceHistoricalDays -> YahooFinanceHistoricalPrices
  • YahooFinanceHistoricalMonths -> YahooFinanceHistoricalPricesMonthly
  • YahooFinanceHistoricalWeeks -> YahooFinanceHistoricalPricesWeekly
  • YahooFinanceIndustry -> YahooFinanceAssetProfiles (improved)
  • YahooFinanceKeyStatistics -> YahooFinanceSummary
  • YahooFinanceSummary -> YahooFinanceQuotes

We understand that this change breaks existing models.

However, existing users can use MARKET.RTD and RealTimeToExcel together and upgrade the models without service interruption.

Removed data providers:

  • GoogleFinanceOptions
  • MsnMoneyQuotes
  • YahooFinanceHistoricalData
  • YahooFinanceQuotes
  • YahooFinanceStocks
  • YahooFinanceWatchList
  • HTML provider
  • Database providers

We removed these providers as they have issues and waste your time.

We removed the HTML and database providers from the MARKET.RTD product to make it simple.