GW2 Commodities Dashboard
This repository holds files for my GW2 Commodities Trading Dashboard.
The goal is to create a dashboard that would do a real life commodities trader proud, with real time data!
Sat Jan 18 - Removed Lump of Tin, Coal and Fabric Spools - these are for sale by merchants.
Sun Jan 19 - Added Divine Lucky Envelopes.
Tue Jan 21 - Created blog template to document the process.
Mon Jan 27 - Added DateDimension table and DateKey foreign keys.
Tue Jan 28 - Populated Trade Post pricing and Job Log tables with DateKey values.
Thur Jan 30 - Added SQL to rank by price, added table to track game events.
Fri Jan 31 - Added gold compute function to SQL.
Sat Feb 1 - Updating gold compute to switch to Copper based methods.
Thur Feb 6 - Added first test SQL functions for Copper math
Sat Feb 8 - First experiments with displaying raw tables and graphs with Chartjs.
Tue Feb 11 - Set API Query to single file from 26 files. Transition time: 21:46 UTC. (Consolidated price)
Wed Feb 12 - Created alpha order book using Python pandas data frames.
Wed Feb 13 - Created alpha user inventory queries.
Tue Mar 10 - Began table truncation design and initial cloud server planning.
Thu Mar 12 - Setup HTML/CSS shell.
Fir Mar 13 - Updated HTML/CSS shell rev 2.