Hi! my app has a series of user-generated data (trade type, stock symbol, open/close dates, buy/sell prices, etc.) and I’m wondering if it’s possible to display the most frequently used stock symbol in a summary table? Also, is it possible to display the symbol with the highest calculated profit along with that profit amount?
I can display trade type amounts because there are only 5 to choose from. But since the stock symbol will be different for every user, I’m having trouble figuring out how to display most frequently used per user. Thanks!
And you mentioned that you’d want to display these in a table - sort of like a “Top Ten Symbols” or something like that? I suppose there could ultimately be hundreds or even thousands of these, yes?
I have an idea in my head how this could work, but I just want to ensure I have a clear understanding first.
Yes, a “Top 10” would be awesome! OriginallyI was just thinking of the “Top 1” but a list of the top few would be better for the user. Yes, there could be hundreds of symbols.
For the profit per symbol, I don’t have a specified column yet as I didn’t know how to set it up. Right now I have columns for the symbol and profit per trade. But not one for total profit for just one symbol.
… and then do a rollup through that relation, taking a sum of the profit
That same relation can also be used to get a count of trades per symbol. But coercing that into a “Top Ten” table requires a little more work. It’s late here, so I’ll think on that one and come back to you with an option tomorrow (unless somebody else jumps in before then).
Wow. Still trying to wrap my head around this solution
So it looks like this would be an overall list of most frequent items, which is very useful. In addition to displaying number of trades, I suppose I could rollup the total profits from each ticker symbol?
I guess the follow up question would be is it possible to sort this based on month. For example, the user selects a month and now sees top symbols for that month only with trade numbers and total profits from that symbol.
I’m using elements from your solution along with @Robert_Petitto 's leaderboard video, and I can get as far as listing top ticker symbols with total profits, but those are lifetime profits, not a user-selected month display. That seems to be my next hurdle…
I’m able to filter the tickers by month and sum their profits in this demo app using your steps. But it’s dependent on the index column, right? I’m imagining numerous users each using a different set of stock tickers, so this would mean I need an index column of a couple of hundred rows?
Or at least have these rows added if the ticker isn’t already in the trade table?
As long as you’re using a user specific column to hold your filter choice, then you only need enough rows to cover the maximum number of symbols that any single user would have. Maybe that’s only a dozen or so?