Home>Extensions>Quote Loader>Price and Control Options

Before you run the Quote Loader you need to set up your securities/currencies with the correct Ticker/ID to allow the program to interrogate the chosen Source.

The first thing to decide is which of the two sources you wish to use for each Security/Currency. You will see a screen like this:

In the Source column (1) select the source from FT (markets.ft.com) or Yahoo (finance.yahoo.com). You do not have to load a particular price. If you wish to set all fields to the same source, right click on the 'Source' heading where you will be presented with a popup menu like this:

Select the option you want.

Once you have determined the source then you need to determine whether or not you require an Exchange (2). Security Ticker codes are often made up of an ISIN code plus a prefix and/or suffix indicating the Exchange for the quotation. Unfortunately both FT and Yahoo have different prefix/suffix for the different exchanges. Therefore you can set the Ticker on the Security to the ISIN code and then tell Quote Loader which Exchange to use. The Quote Loader will then create a ticker code to use from the Ticker on the security and the prefix/suffix on the Exchange.

To select an Exchange left click on the Exchange field for the chosen line. You will be presented with the following screen:

Select the required exchange and click on OK. The exchange code will appear in the Exchange field.

The current list of Exchanges can be found here. If you wish to see the generated ticker code, right click on the Exchange field. You will be presented with the following popup Mneu:

With this menu you can run a test which will issue a request to Rhumba and display a message indicating if this was successful or an error.

You can copy the ticker to the clip board

Or you can copy the chosen exchange to all securities in the table.

Note: Once you have set up your securities/currencies do not forget to save the parameters (8). This is doubly important if you wish to use the Automatic running feature.

You can then run the quotes. You can choose to run the Exchange Rates only by clicking on Get Exchange Rates (3) or run all quotes by clicking on Get Prices (4).

When the Quote Loader is running you will see a screen similar to this:

Initially the colour of the New Price column will be Yellow, it will then turn Green (successful) or Red (unsuccessful) like this:

You will get a message when all quotes have been run.

You will be given the New Price (5), the Trade Date (6), the Trade Currency(7) and the Volume(8) (if available). If the Trade Currency does not match the currency of the Security the original quoted price in the Trade Currency will be shown in brackets. You can edit the New Price and/or Trade Date. These new values will be loaded into the History record within MoneyDance.

You then need to select which prices you wish to update into MoneyDance. Either select the individual lines (10) or click on the 'All' option at the bottom of the screen (11). All lines with a non-zero New Price will be selected. If you want the Volume data to be saved with the price click on 'Include Volume Data' (12). Click on 'Save Selected Values' (13).

Button 14 will export the selected prices to a .csv file (see Selection Criteria). Note: You must have selected the required prices before hand. You do not have to save the prices. If you use this and have 'Export on Save' set you will get 2 files with slightly different times.

Button (15) will close the program.

Prev-Next