Hi Jack, Congratulations, glad to have you aboard with Newport. With the existing files, you should probably write down the Portfolio Control, Cash Reserve and # of Stock Shares and your original total value (stock and Cash Reserve). You'll need this as a minimum when you install and load your stock into Newport.
There are two ways you can proceed. One is to simply start your Newport files as if you are just getting started today. The other is to actually build the history as you have managed the stock in your Excel spreadsheet. Although this requires more work, it's more satisfactory since you immediately have historical graphs which you can view. Bob Norman has written a description of how to do this at:
execpc.com which should lead you successfully.
If you choose the "easy" way, then there's still one thing I'd recommend. First use Newport's ADD A STOCK and fill in the blanks with the ORIGINAL starting position. This would be your initial number of shares at the original price and the cash reserve at the start. Then, I'd suggest you using the next two weeks to consolidate all the buys and sells that you've had along the way. Use one week for the grand total of all shares purchased at the average price and the following week to consolidate the total sales at their average price. This should get the account up to speed. From that point, just make sure that the Portfolio Control matches your current Excel spreadsheet. (Use SHIFT+F4 in Newport to bring up PC).
One further thing, if you set the date of your computer back two full weeks before installing, then you can accomplish this mini-history building and not have to wait three weeks to enter current prices. Remember, Newport records the date of installation in its files, so it's important to set the computer date BEFORE you install the program.
Hope this helps. Please let me know if I can help further.
Best regards, Tom |
