Configuring Markets

Configuring Markets

MARKET.CSV allows loading data for any exchange supported by Yahoo Finance, Google Finance, or MSN Money.

Different markets have different time zones and trading hours that requires configuring.

MARKET.CSV by default is configured for US stock exchanges.

If you load data for exchanges in one country only, you may edit default settings.

If you load data for exchanges in several countries, you have two options:

  1. Create folder copies for different exchanges.
  2. Create configuration files for different exchanges.

The first way is simple. Just copy the folder and edit configuration files and import SQL codes.

The second way seems better as you have all the data in the same folder. It is described below.

Copy the application configuration file, market.csv.exe.config, to a file for your market and change settings.

Change, at least, the following settings:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    ...
    <add key="MarketOpen" value="09:30:00 -05:00" />
    <add key="MarketClose" value="16:00:00 -05:00" />
    <add key="MarketTimeZone" value="-05:00" />
    <add key="DownloadFolder" value="downloads" />
    <add key="ZipFolder" value="zip" />
    ...
  </appSettings>
</configuration>

For example, you may set the following settings for London Stock Exchange (uk.config):

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    ...
    <add key="MarketOpen" value="08:00:00 +00:00" />
    <add key="MarketClose" value="16:30:00 +00:00" />
    <add key="MarketTimeZone" value="+00:00" />
    <add key="DownloadFolder" value="downloads\uk" />
    <add key="ZipFolder" value="zip\uk" />
    ...
  </appSettings>
</configuration>

After that, you may run market.csv.exe with the created configuration file like this:

market.csv.exe download YahooFinanceQuotes symbols\uk-symbols.txt /config=configs\uk.config

market.csv.exe reparse  YahooFinanceQuotes /config=configs\uk.config
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.