Configuring Markets in MARKET.CSV

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 require configuring.

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

If you load data for exchanges in one country only, you can 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's shown 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 can 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 can 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