![]() The “SCM converted price” column will fill itself. In the "Bought" tab you will put your items that you bought at the price you paid for it, the amount you bought, if you bought it on the SCM or with RLM and preferably the date on which you bought into the table.There are multiple tabs within the sheet: If you sold something you will need to enter where you did so and it will adjust the RLM price to SCM value if you sold something on a 3rd party site. If you bought something you will be asked if that purchase was done in Real Life Money (RLM from now on) or in Steam Community Market (SCM from now on) value. The “Portfolio” tab works in Steam Community Market prices. "Gamma 2 Case", "StatTrak™ Desert Eagle | Cobalt Disruption (Factory New)" or "Galil AR | Cerberus (Field-Tested)". Wherever in the Excel sheet you put an items name you need to use the name it has on the Steam Market as well, f.e. ![]() If you dont get new prices, simply close the excel sheet for a while and then it should be able to refresh the prices. The Steam Market API unfortunately likes to ban you out, that's why I made it that way. It will refresh the 185 oldest prices (and items that don't have a price yet) every 5 hours and whenever you start the sheet. It is intended to be opened from time to time and keeping it open for at least 15 minutes to let the price updating algorithm do its thing. There are a lot of items already in the sheet, but you can add your own items into it or delete the items I put into it without any problems. In my opinion it has some redeeming qualities, such as convenience. It has no issues with multiple purchases of items at different prices. ![]() I want to release my Excel sheet built to track your investments with automatically refreshing price updates. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |