| A | B | |
|---|---|---|
1 | This is an example of a Station Trading sheet using GCES. | Contact @nuadi on tweetfleet.slack.com if you have any questions |
2 | ||
3 | Item Names | Regions Sheet |
4 | You can type in any item name found on the Market Items sheet. Use the find function if needed. | This is here so you can search for a region ID if necessary. |
5 | ||
6 | Orders Sheet | Item ID |
7 | This sheet is here to help you find station IDs. Simply enter the region and item you want to look up, and it will fetch all market orders based on the options provided. You can then copy the station ID out of the location of interest. | This is doing a VLookup on the Market Items sheet. The name must be the full name found and spelled exactly as it appears on that sheet. |
8 | ||
9 | Jita Sell/Buy | Using Other Markets |
10 | These values are updated periodically from CREST. It is unclear how often Google updates dynamic cell values, but if you need the latest data simply change the refresh argument of the appropriate function. | Do you list/trade stuff in other markets? Fine. Through a combination of the Regions and Orders sheets, you should be able to lookup the Region ID and Station ID you're interested in. |
11 | Once you have these two pieces of information you can modify the Settings sheet to insert your new market. Simply give it a unique name, and list the region and station ID in the row. | |
12 | Once you have your market in the Settings sheet, you can change the name of the market at the top of the Station Trading sheet. This will propogate down through all formula. If you need multiple markets, simply duplicate the sheet. | |
13 | ||
14 | Item Limit Warning | Settings |
15 | Google limits you to 20,000 UrlFetchApp calls per day. Every price value fetched from CREST is 1 UrlFetchApp call. | Make sure to update the Settings sheet with your current Accounting and Broker's Relations skill levels. |
16 | Please keep this in mind as you use the sheet so that you don't run into the daily limit. If you do, the sheet will start showing you a price of 0.00 for all items. | |
17 | ||
18 | More Functions | |
19 | This sheet only uses a handful of functions available. Checkout the link below for more documentation on what this sheet's script can do. | |
20 | ||
21 | https://github.com/nuadi/googlecrestscript |