You have to pay a monthly fee to Yahoo and a one time fee of 59.95 Euro for RTQDownloader. There are no other costs! If you need real-time quotes for India only, then no subscription is needed. To get real-time quotes, sign in Yahoo Finance with your MarketTracker account and tick off the option “Keep me signed in”.

Yahoo provides free (15 minute) delayed quotes. On http://finance.yahoo.com/exchanges you can see a list with all exchanges that are supported by Yahoo. If you only want delayed quotes then no subscription is needed.

Creating/Editing Alerts

You can set up alerts to trigger certain actions when a stock in your portfolio meets certain criteria. They can be based on the Last, Bid or Ask price. RTQDownloader can alert you in a variety of ways: Popup Window, Audio or via EMail.

Update MetaStock charts automatically

Following steps are necessary to update one or more charts in MetaStock automatically:

• Set up MetaStock into No Vendor position.
   
• Make sure that the option "Automatically update MetaStock chart" in the Download->Options dialog is on.
   
• Start "MetaStock Professional Offline Mode"
   
• Open the charts you want to display. e.g.: By default RTQDownloader stores the quotes of the Dow Jones Index in the "C:\MetaStock\DOW 30" directory.
   
• Start RTQDownloader and select the "Dow 30.mld" list for updating. In couple of seconds renewal of charts should start.
   
• The update function is not limited to the "Dow 30" symbl list. You can use as many symbol lists as you want.

DDE support

The real-time quotes can also be accessed via DDE. This makes it very simple to store the quotes e.g. in Excel sheets and make analysis tasks there. The quotes can also be accessed from any other program supporting DDE.

Following information is needed to make a DDE connection with RTQDownloader:
Server name: RTQ.
Following topics are supported: Bid, Ask, Close, Volume
Following items are supported: Each security in a download list is an item. e.g. MSFT, NET, ^DJI, 519000.DE etc.

If you want to access the “Bid” price of Microsoft (MSFT) you have to paste following string into an Excel sheet (or any other program supporting DDE connections):
RTQ|Bid!MSFT
Ask price:
RTQ|Ask!MSFT
Close price:
RTQ|Close!MSFT
Volume:
RTQ|Volume!MSFT
Total Volume:
RTQ|VolumeTotal!MSFT

Some programs do not support a DDE string containing a “^”, “.” or a “,” character. That is the reason why the DDE symbol may differs from the “Download symbol”. Here are some examples:

If the symbol is “519000.DE” you have to use following DDE string:
RTQ|Close!DE519000

If the symbol is “^DJI” you have to use following DDE string:
RTQ|Close!DJI

Generally a DDE string has the following format: Server name|Topic!Item

How to display stock quotes in Excel

It is possible to display stock quotes in Excel using RTQDownloader. Following steps are necessary to establish a DDE link between Excel and RTQDownloader:

• Start RTQDownloader. Make sure that you are using the symbol list “Dow 30”.
• Start Excel and create an empty workbook.
• Let’s assume that you want to display the “Close” price of the Dow Jones Index and from Microsoft. Paste following DDE strings into an Excel cell:
  =RTQ|Close!DJI
  =RTQ|Close!MSFT
  
  
  
  If the values do not update properly please use the “Edit->Links” menu. Make sure that you have selected all links (see the picture below) and click on the “Update Values” button.
  
  
  
  There is no limit on the number of symbols you can use. You can use as many symbols as you want.

Next time when you open this workbook you will be asked if you want to update the values:



Make sure that you have started RTQDownloader. Click on the “Update” button.