Recording my trading history — Guild Wars 2 Forums

Recording my trading history

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 profit

any advice on this would be great

Comments

  • Leo.3428Leo.3428 Member ✭✭
    edited 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!

©2010–2018 ArenaNet, LLC. All rights reserved. Guild Wars, Guild Wars 2, Heart of Thorns, Guild Wars 2: Path of Fire, ArenaNet, NCSOFT, the Interlocking NC Logo, and all associated logos and designs are trademarks or registered trademarks of NCSOFT Corporation. All other trademarks are the property of their respective owners.