Maintenance for the week of December 23:
· [COMPLETE] NA megaservers for maintenance – December 23, 4:00AM EST (9:00 UTC) - 9:00AM EST (14:00 UTC)
· [COMPLETE] EU megaservers for maintenance – December 23, 9:00 UTC (4:00AM EST) - 14:00 UTC (9:00AM EST)
· [COMPLETE] NA megaservers for maintenance – December 23, 4:00AM EST (9:00 UTC) - 9:00AM EST (14:00 UTC)
· [COMPLETE] EU megaservers for maintenance – December 23, 9:00 UTC (4:00AM EST) - 14:00 UTC (9:00AM EST)
Master Merchant export example
Revry
Soul Shriven
I've recently come back after being away from the game for a while. I love playing the economy, but because I've been away I wasn't sure what was selling well overall. The Master Merchant tooltips are fantastic to give info when you know what you should look at. And while the summary info is great, I was looking for a bit more.
What I really wanted was a way to slice up the data a bit more than what's in the game. So I quick hacked together a way to export the data out of the Master Merchant saved variable files as a whole, and then used a Google Sheets doc to do a bit of digestion. I did this mostly for myself, but I wrote a thread on the forums a long time ago about Master Merchant and people seemed to really like it. So I figured I would share this too in case anyone is interested. I'm not sure if this is the best way to do this. There's a Windows application out there that seems to provide a view of the info too, but I'm on a Mac so that didn't work out great for me.
The first part is getting the data out of the files that Master Merchant uses for storage. Those are the SavedVariables files, and there are 16 of them named MM00Data.lua through MM15Data.lua. I actually installed a Lua interpreter on my Mac (you can just 'brew install lua' if you're on a Mac with Homebrew and want to use the same setup). I'm assuming it's possible to install a Lua interpreter on a Windows machine and do the same thing, but that's something I don't have great advice for yet.
I put the source of the Lua program into a paste: pastebin.com/W2tGEkfZ
If you have a Lua interpreter just put that program into a directory and name it sales_export.lua, and copy your MM00Data files into the same directory. Run it to generate a flat export of all the data: lua ./sales_export.lua > sales_export.txt
That generates a file with one line per sale entry from the MM database. I'm extracting just the info I was interested in so far (which guild the sale was from, item name, sale value, item quantity and quality). Cause lots of the item names have comas and other special characters in them, I delimited the fields in the file using ~. Google Sheets will normally detect that, but you might want to tell it explicitly when you do the import.
The next part was the Google Sheet: ESO Sales History
You should be able to copy that Sheet to your own Google account and import your own data if you want to try it out. There are two tabs in the sheet. The first tab is an import of the raw data from the Lua script (named sales_export). And the second tab is a digestion of the raw data, giving a summary of the sales by item and guild sorted by total gold of the sales (named market_volume).
The second tab is driven by a query in the A2 cell, and will update based on whatever is on the sales_export tab. So to use your own data you can just import (using file -> import on Google Sheets) the data from the Lua script output. When you import just make sure you're on the sales_export tab and you tell the import to "Replace current sheet" in the import options. I normally also explicitly set separator character to custom and put in ~
If everything worked well you'll have a list of what items have the highest market volume for each guild, meaning the most total gold in sales. That's important info for me because I want items I know have high liquidity as flipping targets when I'm wandering the world. I would much rather find the items that sell a few dozen a day at 5k gold as flipping targets than the ones that sell at 25k but only once every month (actually, I want a bit of a mix, but that's a topic for another post :-)
Hopefully that's helpful to someone, good luck trading!
What I really wanted was a way to slice up the data a bit more than what's in the game. So I quick hacked together a way to export the data out of the Master Merchant saved variable files as a whole, and then used a Google Sheets doc to do a bit of digestion. I did this mostly for myself, but I wrote a thread on the forums a long time ago about Master Merchant and people seemed to really like it. So I figured I would share this too in case anyone is interested. I'm not sure if this is the best way to do this. There's a Windows application out there that seems to provide a view of the info too, but I'm on a Mac so that didn't work out great for me.
The first part is getting the data out of the files that Master Merchant uses for storage. Those are the SavedVariables files, and there are 16 of them named MM00Data.lua through MM15Data.lua. I actually installed a Lua interpreter on my Mac (you can just 'brew install lua' if you're on a Mac with Homebrew and want to use the same setup). I'm assuming it's possible to install a Lua interpreter on a Windows machine and do the same thing, but that's something I don't have great advice for yet.
I put the source of the Lua program into a paste: pastebin.com/W2tGEkfZ
If you have a Lua interpreter just put that program into a directory and name it sales_export.lua, and copy your MM00Data files into the same directory. Run it to generate a flat export of all the data: lua ./sales_export.lua > sales_export.txt
That generates a file with one line per sale entry from the MM database. I'm extracting just the info I was interested in so far (which guild the sale was from, item name, sale value, item quantity and quality). Cause lots of the item names have comas and other special characters in them, I delimited the fields in the file using ~. Google Sheets will normally detect that, but you might want to tell it explicitly when you do the import.
The next part was the Google Sheet: ESO Sales History
You should be able to copy that Sheet to your own Google account and import your own data if you want to try it out. There are two tabs in the sheet. The first tab is an import of the raw data from the Lua script (named sales_export). And the second tab is a digestion of the raw data, giving a summary of the sales by item and guild sorted by total gold of the sales (named market_volume).
The second tab is driven by a query in the A2 cell, and will update based on whatever is on the sales_export tab. So to use your own data you can just import (using file -> import on Google Sheets) the data from the Lua script output. When you import just make sure you're on the sales_export tab and you tell the import to "Replace current sheet" in the import options. I normally also explicitly set separator character to custom and put in ~
If everything worked well you'll have a list of what items have the highest market volume for each guild, meaning the most total gold in sales. That's important info for me because I want items I know have high liquidity as flipping targets when I'm wandering the world. I would much rather find the items that sell a few dozen a day at 5k gold as flipping targets than the ones that sell at 25k but only once every month (actually, I want a bit of a mix, but that's a topic for another post :-)
Hopefully that's helpful to someone, good luck trading!
0