Knowledgebase
Import Prices Followup 20110106
Posted by Henry Gage on 06 January 2011 06:24 PM
Import Prices Followup 20110106

Software Used: TAPro version 3.7.00
Excel (version 2002, a work horse that I trust)
Notepad (version 5.1 copyright 2007)

Steps:
1. With TAPro... File/Export/Prices...
2. Open with Excel and edit the last column to add price information
3. File Save (as .CSV)
4. I looked at the file using Notepad and here is what I see:

Display Symbol,Research Symbol,Security Type,Price or Rate
AAQ+DE,AAQ+DE.X,Call Option (Equity),10
AAQ+PT,AAQ+PT,Stock,10
AAQ/EE,AAQEE.X,Call Option (Equity),1
AAQ/FE,AAQFE.X,Call Option (Equity),2
AAQ/GE,AAQGE.X,Call Option (Equity),3
AAQ/QT,AAQQT,Stock,20
AAQ/RT,AAQRT,Stock,30

5. If you use a different program make sure it does not corrupt the file with other stuff. If the file appears in the above format it should import.
6. File/Import/Prices...

(172 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako ta.helpserve.com