MARKET.RTD

MARKET.RTD

Getting Started

MARKET.RTD allows loading data from Yahoo Finance, Google Finance, and MSN Money into Microsoft Excel spreadsheets.

Here is a pivot table of available data:

CategoryYahoo FinanceGoogle FinanceMSN Money
Quotes 
Historical Prices
Intraday Prices 
Options Chains 
Financials 
Instruments:
Stocks
Options (US market only)
Futures (US market only)  
Indexes 
Currencies 

You may create refreshable models using Excel RTD formulas like this:

Example of Yahoo Finance Quotes

The report uses formulas like these: 

=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Open")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","High")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Low")
=RTD("market.rtd",,"YahooFinanceQuotesCSV","AAPL","Last")

You may get ready-to-use formulas for any data provider using Formula Builder:

MARKET.RTD Formula Builder - Providers

Also, you may find models for different data providers in the Examples folder of the downloaded package.

MARKET.RTD is an easy-to-use product.

Active your trial after setup. Then open examples from the downloaded package to see the common picture.

Then try Formula Builder and create your models.

When your trial period ends, choose an edition. If you have less than ten tickers, you may register MARKET.RTD for free.

Also, read Using MARKET.RTD to understand the product features deeply.

What's New

Version 5.8, December 15, 2017

Improvements:

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

Version 5.7, December 13, 2017

Improvements:

  • Updates 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:

  • Updates 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 may continue use RealTimeToExcel.

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

We redesign the application, data providers, and the 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 10 tickers.

Paid editions have a new simplified model of limits. The Personal and Standard editions have increased 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 may purchase 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 a 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 may 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 just waste your times.

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

You may try our new products, WEB.RTD and DB.RTD, that have similar, but significantly improved, features and also are simple.

Edition Comparison

FeatureFreePersonalStandardEnterprise
Number of unique tickers in all opened workbooks1010002000Unlimited
Yahoo Finance Data Providers
Google Finance Data Providers
MSN Money Data Providers
One-time price per copy $99$149$199
Commercial usex

You may try all the features during a 15-day trial period.

Install and Uninstall

Installing

Close Microsoft Excel and run setup.exe.

Open Start Menu, All Programs, MARKET.RTD, Register Product to activate a trial.

Updating

Close Microsoft Excel and run setup.exe of a new version.

Uninstalling

To uninstall MARKET.RTD, open Control Panel, Programs and Features, then select MARKET.RTD and click the Uninstall button.

Upgrading from RealTimeToExcel 1.x to 4.x

MARKET.RTD is the next major version of RealTimeToExcel. However, MARKET.RTD is a new product.

So, you may have both RealTimeToExcel and MARKET.RTD installed and test the upgrade with a minimal service interruption.

You may test the upgrade in a trial mode and purchase the upgrade to continue use of MARKET.RTD.

MARKET.RTD has a new server name, market.rtd instead of gartle.rtd, and changes in data provider names. See What's new for details.

System Requirements

Supported Versions of Microsoft Excel:

  • Microsoft Excel 2007, 2010, 2013, 2016

Supported Architectures:

  • x86, x64

Supported Operating Systems:

  • Windows Vista SP2, 7 SP1, 8, 8.1, 10
  • Windows Server 2008 SP2, 2008 R2 SP1, 2012, 2012 R2, 2016

End-User License Agreement

This End-User License Agreement (EULA) is a legal agreement between you (either an individual or a single entity) and Gartle Technology Corporation for any MARKET.RTD software, use examples and documentation (Software) that accompany this EULA.

YOU AGREE TO BE BOUND BY THE TERMS OF THIS EULA BY INSTALLING, COPYING, OR OTHERWISE USING THE SOFTWARE.

IF YOU DO NOT AGREE, DO NOT INSTALL, COPY, OR USE THE SOFTWARE.

Your licensing of Software is in accordance with the terms of the EULA in effect at the time of such licensing. By licensing Software, you accept and agree to the EULA in effect at such time.

  1. GRANT OF LICENSE: Gartle Technology Corporation grants you the following rights provided that you comply with all terms and conditions of this EULA:
    1. Trial Period: You may install, use, access, display and run the Software for purposes of evaluation of the Software for a period of fifteen (15) days from the date of installation of the Software to determine if the Software meets your needs. Upon completion of your evaluation or at the end of the 15-day trial period, whichever occurs first, you must do one of four things: either
      1) register the MARKET.RTD Free edition in order to continue use of Software;
      2) purchase license for the MARKET.RTD Personal, Standard or Enterprise edition in order to continue use of Software;
      3) purchase a subscription for the MARKET.RTD Personal, Standard or Enterprise edition in order to continue use of Software;
      or 4) discontinue use of the Software, and uninstall the Software from any and all machines.
    2. Installation and Use: You may install, use, access, display and run one (1) copy of the Software per license, on a non-exclusive basis and without right of sublicense or concurrent use, on a single computer or machine, such as a workstation.
      The commercial use of the MARKET.RTD Personal edition is not permitted, including the use by professional traders and institutional investors.
    3. Software Transfer: You may transfer the Software to a different internal workstation or user so long as you have purchased a License for each such workstation or user. You may not, however, transfer the Software to a Third Party.
    4. Use of Examples: You may install, access, modify and use Software examples, including Microsoft Excel workbooks, databases, SQL codes, and batch files, for your private or company-internal purposes.
  2. LIMITATIONS: You may not use, copy, modify, display, rent, lease, loan, transfer, distribute, download, merge, or make any translation or derivative work of the Software, except as expressly provided herein. You may not reverse engineer, decompile, or disassemble the Software, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation.
  3. INTELLECTUAL PROPERTY RIGHTS AND CONFIDENTIALITY: The Software, including methods, processes and/or techniques utilized therein, is owned by, proprietary to and valuable trade secrets of Gartle Technology Corporation and is protected by Russian Federation copyright law and international treaties. You agree to take no actions that impair or infringe Gartle Technology Corporation's intellectual property rights in the Software. You agree not to remove, efface or obscure any copyright notices, other proprietary markings or confidentiality legends placed upon or contained within the Software.
  4. DISCLAIMER OF WARRANTIES: Gartle Technology Corporation disclaims all warranties concerning the Software and Services (if any), express, implied, or statutory, including without limitation, any warranties, duties or conditions of merchantability or fitness for a particular purpose, warranties of reliability or availability, of accuracy or completeness of responses, of results, of workmanlike effort, of lack of viruses, and of lack of negligence, all with regard to the Software, and the provision of or failure to provide support or other services, information, software, and related content through the Software or otherwise arising out of the use of the Software. Gartle Technology Corporation does not warrant that the Software will operate in combination with other software products selected by you, or that the Software will operate uninterrupted or error-free. Additionally, Gartle Technology Corporation and its suppliers provide the Software and Services AS IS AND WITH ALL FAULTS. THERE IS NO WARRANTY OR CONDITION OF TITLE, QUIET ENJOYMENT, QUIET POSSESSION, CORRESPONDENCE TO DESCRIPTION, OR NONINFRINGEMENT WITH REGARD TO THE SOFTWARE.
  5. NO LIABILITY: TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT SHALL GARTLE TECHNOLOGY CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY SPECIAL, INCIDENTAL, PUNITIVE, INDIRECT, OR CONSEQUENTIAL DAMAGES WHATSOEVER (INCLUDING, BUT NOT LIMITED TO, DAMAGES FOR LOSS OF PROFITS OR CONFIDENTIAL OR OTHER INFORMATION, FOR LOSS OF DATA, FOR BUSINESS INTERRUPTION, FOR PERSONAL INJURY, FOR LOSS OF PRIVACY, FOR FAILURE TO MEET ANY DUTY INCLUDING OF GOOD FAITH OR OF REASONABLE CARE, FOR NEGLIGENCE, AND FOR ANY OTHER PECUNIARY OR OTHER LOSS WHATSOEVER) ARISING OUT OF OR IN ANY WAY RELATED TO THE USE OF OR INABILITY TO USE THE SOFTWARE, THE PROVISION OF OR FAILURE TO PROVIDE SUPPORT OR OTHER SERVICES, INFORMATION, SOFTWARE, AND RELATED CONTENT THROUGH THE SOFTWARE OR OTHERWISE ARISING OUT OF THE USE OF THE SOFTWARE, OR OTHERWISE UNDER OR IN CONNECTION WITH ANY PROVISION OF THIS EULA, EVEN IN THE EVENT OF THE FAULT, TORT (INCLUDING NEGLIGENCE), MISREPRESENTATION, STRICT LIABILITY, BREACH OF CONTRACT OF GARTLE TECHNOLOGY CORPORATION OR ANY SUPPLIER, AND EVEN IF GARTLE TECHNOLOGY CORPORATION OR ANY SUPPLIER HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
  6. LIMITATION ON REMEDIES: Within the first thirty (30) days after your receipt of the Software, should you encounter and report to Gartle Technology Corporation within such time period a reproducible error that causes the Software not to perform in all material respects as set forth in the Software documentation, then Gartle Technology Corporation will, at its sole discretion, either: a) resolve the error or malfunction, and modify or replace the Software (if deemed necessary by Gartle Technology Corporation); or b) allow you to terminate this EULA with respect to the non-conforming Software and, upon your return of the Software to Gartle Technology Corporation, Gartle Technology Corporation shall provide you with the lesser of a) the actual damages incurred by you; or b) the amount you paid for the non-conforming Software. The remedies described in this section shall be your sole and exclusive remedies under this EULA.
  7. GENERAL PROVISIONS
    1. Reservation of Rights and Ownership: Gartle Technology Corporation reserves all rights not expressly granted to you in this EULA. The Software is licensed, not sold.
    2. Consent to Use of Data: You agree that Gartle Technology Corporation and its affiliates may collect and use technical information gathered as part of the Software support services provided to you, if any, related to the Software. Gartle Technology Corporation may use this information solely to improve Gartle Technology Corporation products or to provide customized services or technologies to you and will not disclose this information in a form that personally identifies you.
    3. Links to Third Party Sites: We may link to third-party sites through the use of the Software. The third-party sites are not under the control of Gartle Technology Corporation, and Gartle Technology Corporation is not responsible for the contents of any third-party sites, any links contained in third-party sites, or any changes or updates to third-party sites. Gartle Technology Corporation is not responsible for webcasting or any other form of transmission received from any third-party sites. Gartle Technology Corporation is providing these links to third-party sites to you only as a convenience, and the inclusion of any link does not imply an endorsement by Gartle Technology Corporation of the third-party site.
    4. Additional Software/Services: This EULA applies to updates, supplements, add-on components, or Internet-based services components, of the Software that Gartle Technology Corporation may provide to you or make available to you after the date you obtain your initial copy of the Software, unless Gartle Technology Corporation provides other terms along with the update, supplement, add-on component, or Internet-based services component. Gartle Technology Corporation reserves the right to discontinue any Internet-based services provided to you or made available to you through the use of the Software.
    5. Upgrades: To use Software identified as an upgrade, you must first be licensed for the software identified by Gartle Technology Corporation as eligible for the upgrade. After upgrading, you may no longer use the software that formed the basis for your upgrade eligibility.
    6. Applicable Law: This EULA is governed by the laws of the Russian Federation. Any legal action or proceeding relating to this EULA shall be instituted in a court of arbitration in the Moscow City, Russian Federation. Gartle Technology Corporation and you agree to submit to the jurisdiction of, and agree that venue is proper in, these courts in any such action or proceeding. The prevailing party in any action to enforce this EULA will be entitled to recover its attorney fees and costs in connection with such action.
    7. Waiver: The failure of either party to enforce any of the terms of this EULA shall not be construed as a waiver of future enforcement of that or any other term.
    8. Entire Agreement and Severability: This EULA (including any addendum or amendment to this EULA which is included with the Software) is the entire agreement between you and Gartle Technology Corporation relating to the Software and the support services (if any) and it supersedes all prior or contemporaneous oral or written communications, proposals and representations with respect to the Software or any other subject matter covered by this EULA. To the extent the terms of any Gartle Technology Corporation policies or programs for support services conflict with the terms of this EULA, the terms of this EULA shall control. If any provision of this EULA is held to be void, invalid, unenforceable or illegal, the other provisions shall continue in full force and effect.
    9. Termination: Without prejudice to any other rights, Gartle Technology Corporation may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of the Software and all of its component parts and you will not be entitled to any refund of monies.

Trial Version Limitations

You can use MARKET.RTD Enterprise during a 15-day trial period for free.

You have to activate the trial.

When the trial period has expired, you have the following options:

  1. To register the MARKET.RTD Free edition for free.
  2. To purchase a license and register the MARKET.RTD Personal, Standard or Enterprise edition.
  3. To purchase a subscription and register the MARKET.RTD Personal, Standard or Enterprise edition.
  4. To stop the use and remove MARKET.RTD from a computer.

See also

Using MARKET.RTD

Concept

MARKET.RTD allows loading quotes, historical prices, key statistics, financials, option chains for Yahoo Finance, Google Finance, and MSN Money.

For example, you may create reports like this:

Example of MSN Money Quotes

or this:

Example of Yahoo Finance Options

In both cases, you use regular RTD formulas like:

=RTD("market.rtd",,"MsnMoneyQuotes",,"AAPL","Last")

=RTD("market.rtd",,"YahooFinanceOptions","AAPL180119C00120000","Bid")

The formulas have the following rules:

=RTD("market.rtd",,"<provider>"[,<Parameter1>[,<Parameter2>[,<Parameter3>]]],"<Data Field>")

market.rtd is an RTD server name.

<provider> is name of a data provider like MsnMoneyQuotes or YahooFinanceOptions.

Parameters and data fields depend on data providers.

You may get formulas using Formula Builder. In the first step, you select a provider:

MARKET.RTD Formula Builder - Providers

In the next steps, you configure formulas and paste them into Excel spreadsheets.

MARKET.RTD Formula Builder - Formulas

Open Formula Builder using Start, All Programs, MARKET.RTD, Formula Builder.

See the Formula Builder description here.

Also, you may find formatted reports in the Examples folder of the downloaded package.

Refresh Intervals

You may change the refresh interval (in seconds or as hh:mm:ss) of any provider using the formula like this (15 minutes):

=RTD("market.rtd",,"YahooFinanceQuotes","rtd_RefreshInterval",15*60)

Do not make a lot of requests to the website. Otherwise, the website may ban your IP.

Tickers

Use Yahoo Finance, Google Finance or MSN Money websites to find tickers:

Examples

You may find examples in the Examples folder of the downloaded package.

Use these examples as templates or to troubleshoot formulas and loading data.

Tick Fields

You may use special tick fields. Just add the :tick suffix to the data field name.

For example:

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last:tick")

Tick values:

Tick ValueMeaning
1The value is changed up
0The value is unchanged
-1The value is changed down

Tick fields can be used for conditional formatting of the underlying fields or as independent columns.

Monitoring

You may use special data fields to monitor downloading data.

For example:

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastUpdate")

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastError")

The formulas above show the last data update time and the last error code for the AAPL ticker.

See a complete list of the special data cells here.

Configuring

You may change some of the application settings.

The most useful setting is the Yahoo! API key that allows refreshing data more frequently.

You may open the file using Start Menu, All Programs, MARKET.RTD, Configuration File.

Formula Builder

MARKET.RTD Formula Builder builds RTD formulas for the specified provider.

You may start it using Start, All Programs, MARKET.RTD, Formula Builder.

Formula Builder looks like this:

MARKET.RTD Formula Builder

First of all, select a provider:

MARKET.RTD Formula Builder - Providers

Then select parameters in the second row and click the Go button. You will see the formulas like this:

MARKET.RTD Formula Builder - Formulas

You may customize the formula layout (Row, Column, or Absolute), formula style (A1 or RC) and the formula separator (comma or semicolon).

Then click Copy Formulas, create a new worksheet and paste formulas at cell A1.

MARKET.RTD Formula Builder - Excel worksheet

Then you may format a worksheet as you need or copy formulas to your reports.

Note about formula parameters. In the example above, formulas use parameter values from cells B3-B5.

So, you may copy columns and change stock tickers or reports columns.

For example, the formatted report may look like this:

Example of Google Finance Financials

You may find this and other ready-to-use forms in the Examples folder of the downloaded package.

Data Providers

MARKET.RTD loads data from Yahoo Finance, Google Finance, and MSN Money.

You may test any provider using Formula Builder. Use tickers that you use on the provider website.

Here is a pivot table of available data:

CategoryYahoo FinanceGoogle FinanceMSN Money
Quotes 
Historical Prices
Intraday Prices 
Options Chains 
Financials 
Instruments:
Stocks
Options (US market only)
Futures (US market only)  
Indexes 
Currencies 

Compliance

Complying with Yahoo! Terms of Services

Yahoo Finance publishes delayed quotes and financial data free of charge for non-commercial use.

MARKET.RTD default settings comply with Yahoo! Terms of Services.

See important documents about Yahoo Finance data use:

Complying with Google Finance Terms of Services

MARKET.RTD loads data from the Google Finance website using undocumented features.

See important documents about Google Finance data use:

Complying with MSN Money Terms of Services

MARKET.RTD loads data from the MSN Money website using undocumented features.

See important documents about MSN Money data use:

Application Fields

Application fields allow getting information about application settings, downloads, and value changes using RTD formulas.

Server Fields

Formula format:

=RTD("market.rtd",,"<Data field>")

For example:

=RTD("market.rtd",,"rtd_server_Version")
=RTD("market.rtd",,"rtd_server_DataCacheDirectory")

Complete list of fields:

FieldMeaning
rtd_server_VersionThe MARKET.RTD version
rtd_server_RegistrationInformation about the registered edition and trial period
rtd_server_DataCacheDirectoryThe DataCacheDirectory configuration value
rtd_server_TimeZoneThe TimeZone configuration value
rtd_server_DateTimeThe current date and time adjusted to the server time zone
rtd_server_DateThe current date adjusted to the server time zone
rtd_server_TimeThe current time adjusted to the server time zone

Tick Fields

You may use special tick fields for number data fields. Add the :tick suffix to the data field name.

Example:

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last:tick")

Tick values:

Tick ValueMeaning
1The value is changed up
0The value is unchanged
-1The value is changed down

Tick fields can be used for conditional formatting of the underlying fields or as independent columns.

Data Provider Fields

Use the following fields to get the information for data providers:

FieldMeaning
rtd_RefreshIntervalThe refresh interval (get and set)
rtd_LastUpdateThe date and time of the last update
rtd_LastUpdateDateThe date of the last update
rtd_LastUpdateTimeThe time of the last update
rtd_LastErrorThe last error code (see codes below)
rtd_LastMessageThe last error message

For example, if a data formula is

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","Last")

you may add formulas to monitor data status:

=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastUpdate")
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastError")
=RTD("market.rtd",,"YahooFinanceQuotes","AAPL","rtd_LastMessage")

Also, you may change the refresh interval (in seconds or as hh:mm:ss) using the formula like this (15 minutes):

=RTD("market.rtd",,"YahooFinanceQuotes","rtd_RefreshInterval",15*60)

Do not make a lot of requests to the website. Otherwise, the website may ban your IP.

LastError Codes

The rtd_LastError field returns the following codes:

ValueMember name Description
0SuccessNo error was encountered
14TimeoutNo response was received during the time-out period for a request
15ProxyNameResolutionFailureThe name resolver service could not resolve the proxy host name
400BadRequestThe request could not be understood by the server due to malformed syntax
401UnauthorizedThe request requires user authentication
403ForbiddenThe server understood the request but is refusing to fulfill it
404NotFoundThe server has not found anything matching the Request-URI
407ProxyAuthenticationRequiredThis code is similar to 401 (Unauthorized) but indicates that the client must first authenticate itself with the proxy
408RequestTimeoutThe client did not produce a request within the time that the server was prepared to wait
500InternalServerErrorThe server encountered an unexpected condition which prevented it from fulfilling the request
503ServiceUnavailableThe server is currently unable to handle the request due to a temporary overloading or maintenance of the server

Application Settings

MARKET.RTD loads application settings from the market.rtd.dll.config file located in the local application folder like

C:\Users\<Your user name>\AppData\Gartle\MARKET.RTD\market.rtd.dll.config

You may open the file using Start Menu, All Programs, MARKET.RTD, Configuration File.

Configuration file example:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <appSettings>
        <add key="StorageType" value="SQLite"/>
        <add key="DataCacheDirectory" value=""/>
        <add key="TimeZone" value="Eastern Standard Time"/>
        <add key="YahooConsumerKey" value=""/>
        <add key="YahooConsumerSecret" value=""/>
    </appSettings>
</configuration>

Configuration parameters:

StorageType
This string value defines where to store downloaded data: an SQLite database or the file system.
Possible values: SQLite (default) and Folder.
The files are located in the DataCacheFolder.
DataCacheDirectory
This string value allows changing the cache directory of downloaded data.
The default value is %USERPROFILE%\AppData\Local\market.rtd\DataCache on Windows Vista and later,
and %USERPROFILE%\Local Settings\Application Data\market.rtd\DataCache on Windows XP.
TimeZone
The string value is used to adjust the PC time used in the rtd_LastUpdate, rtd_LastUpdateDate, and rtd_LastUpdateTime fields.
The default value is Eastern Standard Time.
See available time zones at http://technet.microsoft.com/en-us/library/cc749073(v=ws.10).aspx.
YahooConsumerKey
This string values used to specify Yahoo! API Consumer Key. See below.
YahooConsumerSecret
This string values used to specify Yahoo! API Consumer Secret. See below.

You may get application settings using RTD formulas.

Yahoo! API Key

Yahoo! specifies the following usage limits:

  • 1000 calls per hour for IP authenticated users.
  • 10000 calls per hour for applications identified by Access Key.

So, you may increase the usage limits. Do the following steps:

  1. Get your Yahoo! API Key at https://developer.yahoo.com/apps/.
  2. Specify Consumer Key and Consumer Secret in the configuration file.
  3. Restart Excel.
@..\source\support

Troubleshooting

Microsoft Excel shows #N/A values
#N/A means that the data is "Not available."
Possible reasons are
1. An error server in the formula. Check the correct value: "market.rtd".
2. An error in arguments. Check the provider, symbol, and the data field.
3. A bad ticker. Check the ticker at http://finance.yahoo.com/.
4. Data absent in a data source. For example, Open, DaysHigh, and DaysLow can be not available during non-trading hours.
The data are not being refreshed
Add formulas to monitor data status: rtd_LastUpdate, rtd_LastError, rtd_RefreshInterval.
See the description in Application Fields.

Product Registration

MARKET.RTD requires registration to start a trial and to use it after the trial period.

To register, open Start Menu, All Programs, MARKET.RTD, Register Product.

Selecting Edition

You may register the trial version for free; the product code is not required.

To register the MARKET.RTD Personal, Standard, or Enterprise edition fill in the product code received after purchasing.

MARKET.RTD Registration - Select the edition

Licensee Data

Please fill in the registration form like this:

MARKET.RTD Registration - Fill personal data

The Next button is enabled when all the required fields are filled.

Don't forget to check the required field about the personal data use.

Online Registration

This step allows you to check your email address. If the email is valid, click Next.

You may return to the previous step using the Back button.

MARKET.RTD Registration - Check the email

After clicking the Next button, the MARKET.RTD connects to the registration server.

If the connection is successful, the final step screen is shown.

If any error occurred during connection, you might try to register the product later or try to register the product by email.

MARKET.RTD Registration - The final step

You may set the registration for all users of the computer. This action requires administrator privileges.

Click Finish.

Registration by Email

If you choose the Register by email option on the Licensee Data step, the following screen is displayed:

MARKET.RTD Registration - Check and start the registration email

The Next button starts the default email program, creates a registration email, and activates the next step.
Don't forget to send the email.

If starting of the email program has failed, you may create the registration email manually using the shown registration data.
Please carefully copy the To, Subject, and the Message fields.

The registration server sends the reply in a couple of seconds; but you may close the dialog box and open it again, in the same step.

Please copy the activation code from the received registration email and paste it into the Activation code field.

MARKET.RTD Registration - Paste the activation code

The Next button is enabled when the activation code is valid.

Click Next to continue.

The wizard checks the registration data and confirms the registration.

MARKET.RTD Registration - The final step

You may set the registration for all users of the computer. This action requires administrator privileges.

Click Finish.