![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
I've built a poker results tracker in Excel.
It records date, site, game variation and betting structure, whether the session was a tournament or cash game, how long the session lasted, what the buy-in and cashout was, etc. This lets it do stuff like %InTheMoney, %ReturnOnInvestment, Profit|Loss cumulative and per hour, etc, as raw data and summarised in pivot tables and graphs.
So what's the problem?
At least one site lets you play in a choice of currencies. So I included a currency field and exchange rate table, and it converts to £ for the cumulative figures.
One might want to do the conversion using the exchange rate at the time of the session, but that doesn't really work unless you cash out from the site at the end of every session, since you only really make what you can cash out, howeveer much it looked like when you won|lost it. So, you might just adjust the exchange rate figures occasionally and let it recalc the figures, to get a "what's it worth now?" number. But then what do you do if you do cash out? You'd need to fix the figures for that particular site at that point. But you might not take out _all_ the cash, or _exactly_ the cash you'd won. And if you remove the data that correspond to the money you just cashed out, to get round those problems, then the record is no longer complete.
I can't decide which way to go to deal with this, so I'm open to suggestions.
One simple way of sorting it would be to dump the currency stuff altogether, fiddle the original data for the only session I ever played in £, and only play in $ in the future. Most sites hold your deposit in $ - it's just one particular UK-based one I've used that doesn't, and it's entirely possible I may never play there again for real money. Except of course my offline games are in £. Doh! I could keep the online and offline stuff separate, I suppose. Sigh.
It records date, site, game variation and betting structure, whether the session was a tournament or cash game, how long the session lasted, what the buy-in and cashout was, etc. This lets it do stuff like %InTheMoney, %ReturnOnInvestment, Profit|Loss cumulative and per hour, etc, as raw data and summarised in pivot tables and graphs.
So what's the problem?
At least one site lets you play in a choice of currencies. So I included a currency field and exchange rate table, and it converts to £ for the cumulative figures.
One might want to do the conversion using the exchange rate at the time of the session, but that doesn't really work unless you cash out from the site at the end of every session, since you only really make what you can cash out, howeveer much it looked like when you won|lost it. So, you might just adjust the exchange rate figures occasionally and let it recalc the figures, to get a "what's it worth now?" number. But then what do you do if you do cash out? You'd need to fix the figures for that particular site at that point. But you might not take out _all_ the cash, or _exactly_ the cash you'd won. And if you remove the data that correspond to the money you just cashed out, to get round those problems, then the record is no longer complete.
I can't decide which way to go to deal with this, so I'm open to suggestions.
One simple way of sorting it would be to dump the currency stuff altogether, fiddle the original data for the only session I ever played in £, and only play in $ in the future. Most sites hold your deposit in $ - it's just one particular UK-based one I've used that doesn't, and it's entirely possible I may never play there again for real money. Except of course my offline games are in £. Doh! I could keep the online and offline stuff separate, I suppose. Sigh.
There are 5 comments on this entry. (Reply.)