Importing your transactions into EquityStat

Do you have a lot of transactions that you need to import into EquityStat that you don’t want to manually enter? If so then you can use EquityStat’s import feature to import these transactions.

To import your transactions first get these transactions into a CSV (comma separated variable) file. The easiest way to generate a CSV file is to use Excel or any other spreadsheet application. With Excel you can enter your data into a spreadsheet and then save the file as a CSV file.

The CSV file must be in a certain format for you to import your transactions into your portfolio. The first line in the file must identify what each column is. The following column indentifiers are valid – Symbol, Date, TranType, Quantity, Price, Amount, Commission.

The valid values for the TranType column are Buy, Sell, Div, Rediv (Re-invested Dividend), Longcg (Long-Term Capital Gain), Shortcg (Short-Term Capital Gain), Relongcg (Re-Invest Long Term Capital Gain), Reshortcg (Re-Invest Short Term Capital Gain).

If you have a TranType value of Div then you will need an Amount column and you will not need the Quantity and Price column. If you have a TranType value of something other than a non re-invested dividend or non re-invested capital gain, you will need a Quantity and Price column. All rows must have a Symbol and Date column.

Here is a screen shot of a sample Excel file in the proper format.

Import Transactions into EquityStat's Stock Portfolio Tracker
Import transactions into EquityStat

Once you have your data entered in your spreadsheet, save it as a CSV file.

Next, login to your portfolio and  click the New menu and choose Import Transactions.  Then from the Import page, upload your CSV file from your computer.  The transactions that will be imported will then be displayed.  If everything is correct, continue the import process.

If you have any questions with how to do an import, feel free to contact our support desk by clicking the Help link from our home page.

EquityStat – Who, What and Why?

Who is EquityStat?

EquityStat is a powerful yet easy to use investment portfolio application. It was developed by investors for investors. The old adage “necessity is the mother of invention” was the driving force behind the founding of EquityStat. We found that the existing tools necessary to track, manage and financially evaluate investments were inadequate.

Why EquityStat?

EquityStat wanted a way to track and manage all of our investments in one application from the cloud. As many investors know, your investments are scattered about many brokerages, mutual funds and retirement plans. Our goal was to create an application where investors could manage all of their investments in a single location. In addition we wanted to be able to access investments from any computer or device. Whether at home, work or at the accountant’s office, we wanted to be able to access our investment portfolio.

What is EquityStat?

  • Manage all of your Financial InvestmentsHandles all of your stock, bond, ETF and mutual fund investments from all of your brokerages
  • Track the Performance of your InvestmentsAnalyze your individual investments and your overall portfolio
  • Generate Tax ReportsSupports IRS tax reporting requirements
  • View your Investment Portfolio on all of your DevicesWeb based portfolio management tool that you can view on any computer or tablet