Detailed Spreadsheet for tracking flip history
2 posters
Page 1 of 1
Detailed Spreadsheet for tracking flip history
Hey guys, I made a detailed spreadsheet that I've been using to track my flips over the last few months. it auto fills in info such as return on investment, max profit per 4 hrs, total profit, etc.
There are two sheets in the file. One for individual flips, and one for keeping track of overall item stats. When you complete a instanced flip in the trade log sheet, the item index sheet tallies the profit, and a few other stats that can be useful to look at. using the item index, you can easily see what items are your most profitable, how many you've traded, item indexes, your average trade margins, etc. You'll also need to add the items to the item index manually along with the limit so the trade log sheet can automatically obtain the trade limit and name so it can do math for you. there are a few example items in the sheet already so you can get an idea how to use the sheet.
Let me know if you have any questions, the sheet is quite complicated. Once you get a hang of it though, it proves very useful to be able to automatically have such valuable information at your fingertips.
Hope you find this useful, here's the link to the download:
http://bit.ly/1IsGSBb
you'll have to download it, it will not run in google drive. If you get a popup saying that the sheet uses macros, it does, please enable them. (it uses macros to timestamp sales automatically)
There are two sheets in the file. One for individual flips, and one for keeping track of overall item stats. When you complete a instanced flip in the trade log sheet, the item index sheet tallies the profit, and a few other stats that can be useful to look at. using the item index, you can easily see what items are your most profitable, how many you've traded, item indexes, your average trade margins, etc. You'll also need to add the items to the item index manually along with the limit so the trade log sheet can automatically obtain the trade limit and name so it can do math for you. there are a few example items in the sheet already so you can get an idea how to use the sheet.
Let me know if you have any questions, the sheet is quite complicated. Once you get a hang of it though, it proves very useful to be able to automatically have such valuable information at your fingertips.
Hope you find this useful, here's the link to the download:
http://bit.ly/1IsGSBb
you'll have to download it, it will not run in google drive. If you get a popup saying that the sheet uses macros, it does, please enable them. (it uses macros to timestamp sales automatically)
PizzazyWhale- Tier 1 (Registered)
Re: Detailed Spreadsheet for tracking flip history
It's fine Minato, I should have let you known. I already checked it.
Tuff Tiga- Grandmaster (2000 posts)
Similar topics
» RuneScape 2007 GE Price Tracking!
» AgentPerry's Detailed Firemaking Guide [EOC] [P2p & F2p] [All methods]
» Inactive/Overnight Flipping [DETAILED GUIDE]
» Inhaps GE history
» Spreadsheet v1.7
» AgentPerry's Detailed Firemaking Guide [EOC] [P2p & F2p] [All methods]
» Inactive/Overnight Flipping [DETAILED GUIDE]
» Inhaps GE history
» Spreadsheet v1.7
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|