Programming languages: Object Pascal Tools & Technologies: Borland Delphi 7.0 Enterprise, MS Excel, OLE Automation, Wininet API

Short project description

This tool receives stock data from the Archipelago website and displays it in a nice format in Excel.

It implements following features:

• The application retrieves stocks from http://www.archipelago.com/
• It allows selecting type of stock for import or selecting all stocks.
• Data copying to Excel spreadsheet for future data analysis.
• Data import process is quick, it takes less than 15 seconds to retrieve and copy data (couple hundreds of records).
• It provides settings to set up how often the stock data will be updated.
• Also there exist settings to set up how to export data to Excel (Excel file name, spreadsheet name, coordinates in spreadsheet for data export).

The application is implemented as a single Win32 application. It connects to the site via HTTP protocol using Wininet API. This allows to use existing network settings to connect to the Internet (for example proxy settings). The application uses Ole Automation and Excel object model to copy data to Excel spreadsheets.