Tracking Stock Portfolio-Holdings and Sales

[Perrin Parkhurst]

(First Time Tap Forms User) I just imported Bento databases (successfully I think) into Tap Forms. In Bento I had been following several family members’ portfolios and recording: Person “A” (current holdings); Person “A” (sales) … for about 6 or 7 individuals. Tracking the current holdings is fairly straight forward; equity name; number of shares; price; cost basis; date purchased, etc. etc. When recording “stock sales” (since an entire position may NOT be closed out) it becomes a little more challenging because I used to enter the sale date and then had a calculation field (for those positions that WERE sold) that gave me the total “months held”, along with a “cost basis” minus the total sale value–to calculate a profit/loss. The record would “automatically” be moved FROM the current portfolio file to the sold positions file, only for those shares that had both a “sale date” and a “sales amount” … and I could search all “sold” records based on any given calendar year. I know I’m not doing a very good job of explaining what I’m used to tracking in Bento so I guess I’m now just inquiring to see if anyone out there knows about any GOOD portfolio tracking templates that would work in Tap Forms. H-E-L-P.

[Brendan]

Hi Perrin,

It looks like you need to setup some Saved Searches to filter your records by various criteria. Bento called them Smart Folders I think. Tap Forms they’re Saved Searches. So just click on the gear button to the left of the Search field when you have your form selected and you can setup your rules and criteria for how you want your records filtered. You should be able to replicate the way you had it in Bento. Although Bento had a few more filter features than Tap Forms.

For example, you can have Tap Forms automatically move a record from one filter to another if it no longer meets the qualifications of the search rules for the currently selected Saved Search.

There’s a bit of info on Searching in the online user manual.

Thanks,

Brendan

[Perrin Parkhurst]

Thanks for the quick reply. Sounds logical to me. I’ll check things out and dig into the manual under searches and re-post if I have any further “issues”.

[Jason Turo]

What other ways do you suggest tracking holdings and sales other than using Bento? Thanks for the help.

[Perrin Parkhurst]

Greetings,
I’m beginning to realize that my online brokerage account options (from Fidelity) are very robust and do a very good job of “tracking holdings and sales”. The only reason I used Bento in the past was because there were some “family accounts” that don’t automatically pop up when I log in to Fidelity. I was tracking them on my own. Now that Bento support is history it looks like I’ll be using a combination of accessing my own account(s), via online methods … plus Tap Forms for the other family accounts (once I learn how to master creating the “Saved Searches” that Brendan spoke about in his Jan 20th reply #12756 above. Anyway — that’s my plan of attack.

[Author]

Posts