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:
Help Desk Software by Kayako ta.helpserve.com