Blog / How do I import my portfolio transactions into a FAST Graphs portfolio?

How do I import my portfolio transactions into a FAST Graphs portfolio?

You must first export your transactions into a spreadsheet.

Next you must first create a portfolio for your specified stocks.

From there, hit the “Edit B/S” tab and follow the directions below:

excel

To import an excel buy/sell sheet into FAST Graphs after you have defined the symbols:

Create the excel sheet to match the FAST Graphs Headers:

You must import all six columns even if you do not have information in a column.

The column order is:

Ticker             By/Sl               Trade Date      Shares             Total Amt  or  Per share

Sample Excel sheet:

Total or
Ticker By/Sl Trade Date Shares Amt Per Share
aapl by 2/4/2013 500 8137.45
ctsh by 9/30/2009 250 4853.63
afl by 10/5/2009 115 43.048

Notice you don’t have to put the per share in if you have the total amt or visa versa.

Copy only the information regarding the trades.  Do not copy any headers:

aapl by 2/4/2013 500 8137.45
ctsh by 9/30/2009 250 4853.63
afl by 10/5/2009 115 43.048

And make sure you have SIX (6) columns even if the Per share is empty.

Copy, paste and hit update.