Retail Investor Transactions

TipRanks’ Investor Transaction feed provides non-PII visibility into the actions performed in over 660,000 portfolios using the TipRanks SmartPorfolio tool.

Retail investors signed into this tool are able to track their portfolios, get timely market insights, compare their own personal performance to other investors on the platform, receive notifications on earnings, dividends, important news items along with detailed portfolio analysis insights which include asset allocation, geo allocation, sector distribution and more.

TipRanks’ Investor Transaction feed is a unique and fully comprehensive data set of retail investors transactions captured from within the SmartPortfolio. It's a unique feed that combines individual investor transactions from multiple brokerage platforms.

This data feed is available via files uploaded to Snoflake/FTP on an hourly basis. Each transaction contains the following data fields:

- ExecutionTimeStamp – the timestamp in which the transaction has been recorded.
- EffectiveDate – this is the official record date of the transaction.
- UserReportedDate – users can feed in a historical date for the transaction and, if they do, it will be available in this column.
- Ticker, ISIN, FIGI, SecurityName – identifiers of the security.
- PortfolioID – this is a unique ID of the portfolio.
- UserID – this is a unique ID of the user.
- Action – the action that was performed in the trasnaction, can be one of 6 options.
- PrevNumOfShares – the number of shares the user had prior to the transaction
- SharesTraded – the number of shares the user traded in this transaction
- NewNumOfShares – the number of shares the user had after the transaction was completed
- PortfolioCreationDate – the date in which the portfolio was first created.
- OperationID – an internal ID of the transaction. This can help you keep track on which transactions were already consumed / processed when you’re pulling this data.