Hey guys, I thought i would share my investment tracker spreadsheet, which i think is pretty nifty if i don't say so myself
https://drive.google.com/file/d/0B-FkThHORDEicDBRMWkyNU54Vmc/edit?usp=sharing
Basically, I love the Brickfolio, but it was just bothering me that some of the new sets were showing up as -100%, as I couldn't view the data accurately, I decided to make my own tracker in excel using the exported CSV file from Brickfolio.
The formulas are all set up, so if you change the the numbers in the quantity, purchase price, or MSRRP columns, everything else including all the percentages cascades down accordingly.
Every fortnight, I scour eBay and update the average market prices per set, this provides me with really accurate indication on the growth % of my inventory.
The second sheet added is just full inventory list, which i'll update once i start selling (i haven't done so yet).
I hope this helps others too here.
Thanks!!