[2022] Monthly Economic Report - July 2022

Greetings fellow spreadsheet makers,

Yesterday was a national holiday over in Iceland, so it’s a little later this month - The Monthly Economic Report for July 2022 is now available!

As usual, you can obtain all the raw data used to generate the graphs here. Happy number crunching!

Hey Gustav Mannfred,
The figure you posted is from the June MER. In the July figure

Hey Gustav - just to note that you’re not going mad - I noticed shortly after the post went up that it directed to the June one rather than the July one - I subsequently changed it, apologies for any confusion. I can see CCP Estimate has responded to your query already, but it is a little clearer in July

=VLOOKUP() Battle of the decade!

Hey Gozer,
I think this could be a useful addition to the MER data dump, a description of the files in the data dump. Will add this to the MER todo list!

But for the ones that you asked about, here is a short description of those:

price_change: The monthly price change of the sub index.
total_value: This months total trade value (volume*price) of the sub index.
price_change_weighted: The monthly price change of the sub index weighted by the trade value of indices within the main index.

entry_sink_value and entry_faucet_value: Are just the actual values, no rounding/flooring/ceiling. In the simplest terms, this is calculated by aggregating transactions between players and NPCs. Transactions from players to NPC is a sink, NPC to players is a faucet.