jin.5048 Posted June 2, 2019 Share Posted June 2, 2019 hi!!i've been looking into ways i can keep a record of my transaction history in table format (excel) so that i can see individual profits and calculate accumulative profit automatically - i've seen people talking about excels they've made, but all of these require inputting the information for each trade, not something you want to do when you have hundreds each day! GW2BLTC also offers a similar feature - 'flipping history', but i've found it quite problematic as it does not record that far back making it difficult to track total accumulative profitany advice on this would be great Link to comment Share on other sites More sharing options...
Leo.3428 Posted June 9, 2019 Share Posted June 9, 2019 @"jin.5048" - I haven't played with the API yet but I'll try to help. The wiki at https://wiki.guildwars2.com/wiki/API:2/commerce/transactions states that the transaction history is only 90 days.So you will have to maintain the full history on your computer or server by having a script query the API periodically and add to your stored data - suggesting a database here if you have hundreds of transactions a day. And backups. Not sure Excel can handle that big data, but I may be wrong.Next, generating meaningful reports is a matter of fetching from the stored data and doing the math on it. How precisely you do it depends on which programming language or reporting system you use.I hope this helps! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now