You can import ticker symbols into your StockMarketEye Watchlists via Comma-separated values (CSV) files. You can create CSV files via most spreadsheet applications such as Microsoft Excel or OpenOffice.org Calc.
StockMarketEye reads your stock symbols from the CSV file, one symbol per line. Optionally, you may include additional columns in each line in order to specifiy additional information for the symbol. The table below lists the columns accepted by StockMarketEye.
NOTE: The order of the columns in the CSV file must be the same as that specified in the table below.
NOTE: You may include a “header” line, but it is not required. If the “header” line is included, the first cell must contain the word “symbol” or “ticker”.
Bold column names are mandatory. Others are optional.
| Ticker Symbol | Watch Start Price | Watch Date | Comment | Name |
You can download an example CSV watchlist file here.
In your spreadsheet application, the file to import will look something like this:
The following table describes the columns of the CSV file in greater detail.
| Column | Usage | Description |
|---|---|---|
| Ticker Symbol | Mandatory | The ticker symbol to add to the Watchlist. You can find valid ticker symbols using StockMarketEye’s built-in ticker symbol lookup. import will not warn about symbols for which it can not retrieve quotes or historical data. This column is mandatory and must always contain a value. |
| Watch Start Price | Optional | The starting watch price. If not specified, the current last-trade price will be used. |
| Watch Date | Optional | The date on which you started watching this stock. Typically this corresponds to the date on which the stock traded at the Watch Start Price. If not specified, the current date will be used. Available date formats are:
|
| Comment | Optional | Any comments you want to remember about this particular security. This column is optional and can be left blank. |
| Name | Optional | The name of the company or fund represented by the ticker symbol. This column is optional and can be left blank. |
Once you have created a CSV file containing your ticker symbols, you can import it into StockMarketEye with the following steps.
