Making multi-regional chest price list?

[myxal]

Cheers.

 

About a year ago, I made the chest-value/skin-price calculator spreadsheet. (TL;DR: You make your private copy, where you enter your Steam name, the spreadsheet loads your inventory - assuming it's public - and gives you a price-per spool on every purchasable chest, given your currently-owned skins, highlights the cheapest/most expensive ones, where you're missing the fewest spools, etc.)

 

The recent pricing-changes churn finally prompted me to do something about the price input/update methods, and I addressed the #1 requested feature - showing prices from other regions, though it's not entirely completed. So here's the good news:

• The spreadsheet can now store prices from multiple regions at once, and picking any particular is done by a simple drop-down selection in the Chests sheet.
• The prices are calculated from base price and sale percentage, so updating on sales is going to be a lot easier.

Now the bad news:

• I can't actually get the prices from regions other than my own (without sketchy means like burner accounts, switching regions, etc). I made a simple lua function which I can put in customcommands.lua and after calling it within the game, it generates a list of known chests (packs), with base prices, sale percentages and sale prices (where applicable) - as a CSV file in the game's user folder (~/Documents/Klei...). I'm not sharing it (yet). as I'd love to hear from mods/devs (paging @ImDaMisterL) if it's OK to share the function and ask users from other regions to contribute the data. A sample of the output is shown in the attached image.
• The output data currently seems to be in no particular order. I'll see what I can do so that the order matches the spreadsheet.