![reddit tradeskillmaster reddit tradeskillmaster](https://i.kinja-img.com/gawker-media/image/upload/s--JL_GCJTP--/c_scale,f_auto,fl_progressive,q_80,w_800/iparxbmypues7johnb9s.jpg)
#Reddit tradeskillmaster code#
You can find the source code for the VBA macro here. The google sheets version relies on a script that downloads the pricing data. The Excel version uses a simple VBA macro to call the TSM API. The API call is managed a bit different in the two versions. In the google sheets version you can currently only choose the weighting between dbmarket and minbuyout. You can combine two of them to make your own weighted price. The Excel version supports 4 different price sources (Dbmarket, minbuyout, dbhistorical and dbregionmarket). You can alter the price source in my spreadsheet. This gives us a weighted average of the market value and the current minimum price that weighs the current price higher than DBmarket does. The default price used in the calculations is 66%dbmarket+34%dbminbuyout. This gives us access to several TSM based price sources.
![reddit tradeskillmaster reddit tradeskillmaster](https://vtkwcl.wannaczyprysznic24.pl/templates/64af9ff6ec07d70d68e9adf4e68843a5/img/6c68d1bcd39903ea79a03bf920f4c8cb.jpg)
The pricing data is downloaded from the Tradeskillmaster API.
![reddit tradeskillmaster reddit tradeskillmaster](https://greedygolds.it/wp-content/uploads/2019/09/tsm-classic.jpg)
The main feature is automated calculation of crafting profits. The downloadable excel file has some additional features, but it does not work if you are not using Microsoft Office or if you are not on a Windows-based computer. There are two versions of my spreadsheet available depending on your preferences. The Spreadsheet contains all the crafting professions and their recipes. I have created a Spreadsheet that automatically calculates profits for the major crafts available in Shadowlands professions.