Importing Quotes

Before you import quotes, you'll need to decide whether Venice will read the quotes directly from files or from a database. See Quote Source to set this all up.

You can reach the import quotes dialog by:

This dialog is very versatile and lets you perform several import/export operations:

Import quote files into the Database

To perform this operation:

Click on Files in the Import From area and on Database in the Import To area.

This allows you to import multiple quote files into the database in one operation. Importing quotes into the database can take a while, so please be patient. You need to select the quote type you are importing, see Quote Source for an explanation of these types. When you click Import a dialog will come up and you can select multiple quote files.

Import quote files into Venice

To perform this operation:

Click on Files in the Import From area and on Files in the Import To area.

This allows you to import multiple quote files into Venice in one operation. This operation only tells Venice about the quote files, it doesn't copy them in anyway - so if you delete the original quote files, Venice obviously won't be able to access them anymore.

Import quote files into Venice and the Database

To perform this operation:

Click on Files in the Import From area and on Files and Database in the Import To area.

This operation performs the combination of the above two operations it will import the files into the database and also into Venice. This is useful if you access the files via the database, but would like Venice to be able to cope if the database goes down.

Import quotes from the Internet

To perform this operation:

Click on Internet in the Import From area and on Files and/or Database in the Import To area. Enter a comma or space separated list of symbols you wish to import and the date ranges you wish to import.

This allows you to import quotes directly from the internet and store them in the database and/or in quote files on your hard drive. If you need to use a web proxy, you can configure it in Venice's Preferences.

Export quote files from the Database

To perform this operation:

Click on Database in the Import From area and on Files in the Import To area.

This allows you to export all the quote files from the database back into text files. Each file will contain quotes for a single day. You'll need to specify the format of the quotes in the file you want, see Quote Source for more details. You'll also need to specify the path and file name for the generated files in the text box showing. Each file is named with the date as part of it's file name, you'll need to specify the format of the date.

E.g.

What if the string mm, dd, MMM or yy appears in my destination file but isn't meant to be part of the date string? Well it won't work.