# đź’° \[FREE SERVICE\] Free Trade Spreadsheet đź’° **URL:** \ **Category:** Services\ **Created:** [December 19, 2017, 8:24pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376 "2017-12-19T20:24:06Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [December 19, 2017, 8:24pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/1 "2017-12-19T20:24:07Z")
Beginner Station Trade Sheet that will pull all the items listed from the Eve Marketer API data and crunch the numbers based off your taxes/fees of each trade hub. [https://docs.google.com/spreadsheets/d/1Cxon0qxkeBm-DcRkNQjxUS\_RCRDKNkteGpRpodVwKOk/copy](https://docs.google.com/spreadsheets/d/1Cxon0qxkeBm-DcRkNQjxUS_RCRDKNkteGpRpodVwKOk/copy) **How to Use It** 1. Clone your own copy to your Google Drive 2. Update all your taxes/fees on the Math Tab for all the trade hubs (decimal format), ie if your brokers fee is 7% then your decimal format is .07 3. Type in any item name into the left hand column on the trade tab (press enter to save your change), wait a couple seconds for the sheet to refresh. 4. Choose which buy/sell locations you want to compare 5. Magic! Custom alternations may have a charge. Feel free to clone a copy for your self and poke around. Should help beginners see how a simple sheet runs. Kudos to @Steve_Ronuken for the fuzzworks typeid csv export **Please Report any Bugs! Contact me here/in-game for any questions.** **Discord** [https://discord.gg/5vUQxMP](https://discord.gg/5vUQxMP) ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [December 20, 2017, 9:40pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/2 "2017-12-20T21:40:22Z")
I’ve variablized the brokers/accounting fees on the math tab. All you need to do is fill those in based off your characters skills of the station/fortizar you use and it will dynamically update the fee combination based off the 2 locations selected. ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [January 7, 2018, 6:33pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/3 "2018-01-07T18:33:25Z")
Had someone request access last night. Remember to just clone a copy to your own google drive and use that ---
**Author:** ![HoraceSilver](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/horacesilver/32/42299_2.png) [@HoraceSilver](https://forums.eveonline.com/u/HoraceSilver)\ **Post date:** [January 9, 2018, 6:11pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/4 "2018-01-09T18:11:54Z")
Hi Mate This is exactly what i need, how do i create another column to have JIta Sell and Rens Sell together on the same sheet so i can work out which system sells for more, and visa-versa for Buy. ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [January 9, 2018, 6:14pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/5 "2018-01-09T18:14:02Z")
i’ll have to look a bit later and get back to you ---
**Author:** ![HoraceSilver](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/horacesilver/32/42299_2.png) [@HoraceSilver](https://forums.eveonline.com/u/HoraceSilver)\ **Post date:** [January 9, 2018, 6:19pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/6 "2018-01-09T18:19:11Z")
Ah your wicked, i tried copying and pasting but that didn’t work. I also tried to add more than 152 cells and i couldn’t work it out 🙂 ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [January 9, 2018, 6:36pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/7 "2018-01-09T18:36:46Z")
Yeah the number of rows I have on the trade page is pretty much maxed, so I wouldn’t add any more there ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [January 9, 2018, 6:43pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/8 "2018-01-09T18:43:06Z")
Can you share your cloned version with me and I can edit on yours ---
**Author:** ![HoraceSilver](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/horacesilver/32/42299_2.png) [@HoraceSilver](https://forums.eveonline.com/u/HoraceSilver)\ **Post date:** [January 9, 2018, 9:32pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/9 "2018-01-09T21:32:40Z")
Think i shared it to you. ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [January 9, 2018, 9:44pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/10 "2018-01-09T21:44:15Z")
K all done. The only thing to be aware of, is the profit calculations are processed off the sell swap in column C, but you can use the new Column D to just have a look at what it would be Make sense? ---
**Author:** ![HoraceSilver](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/horacesilver/32/42299_2.png) [@HoraceSilver](https://forums.eveonline.com/u/HoraceSilver)\ **Post date:** [January 9, 2018, 9:45pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/11 "2018-01-09T21:45:26Z")
You absolute legend, that is exactly what i wanted! when i make my billions ill be sending you some isk! ---
**Author:** ![BiIl\_Gates](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/biil_gates/32/51293_2.png) [@BiIl\_Gates](https://forums.eveonline.com/u/BiIl_Gates)\ **Post date:** [January 27, 2018, 4:52pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/12 "2018-01-27T16:52:07Z")
This is amazing! I had a sheet nearly identical to this one, but it ran off Eve-Central (rip) Thanks for this ! ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [January 27, 2018, 5:13pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/13 "2018-01-27T17:13:13Z")
Great name 🙂 ---
**Author:** ![PeBu3oP](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/pebu3op/32/50380_2.png) [@PeBu3oP](https://forums.eveonline.com/u/PeBu3oP)\ **Post date:** [February 1, 2018, 7:32pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/14 "2018-02-01T19:32:59Z")
hi man/pls help me 🙂 how add refresh interval to buy and sell 4 hour’s,or how to refresh price ?Now refresh interval 1 day sry /i bad speak english ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [February 1, 2018, 7:36pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/15 "2018-02-01T19:36:42Z")
You can force a refresh by just changing an item name and pressing enter ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [March 1, 2018, 5:54pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/16 "2018-03-01T17:54:04Z")
Bumpy ---
**Author:** ![DocFry\_Adoulin](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/docfry_adoulin/32/134620_2.png) [@DocFry\_Adoulin](https://forums.eveonline.com/u/DocFry_Adoulin)\ **Post date:** [April 10, 2018, 10:00pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/17 "2018-04-10T22:00:19Z")
Wonderful! /me sings, “It was just what I needed! It calculates all my fees! Just what I needed! A way to make those iskies!” ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [April 10, 2018, 10:12pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/18 "2018-04-10T22:12:34Z")
I use the eve-marketer API, which I believe only looks at NPC stations not player citadels for some items. Looking at the highly traded things like plex, injectors/extractors etc it does check citadels, at least ICY ones ---
**Author:** ![ElMal\_Ote](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elmal_ote/32/71791_2.png) [@ElMal\_Ote](https://forums.eveonline.com/u/ElMal_Ote)\ **Post date:** [May 9, 2018, 4:30pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/19 "2018-05-09T16:30:51Z")
How do i put in something like Nanite Repair Paste or some other ships? ---
**Author:** ![Brock\_Khans](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/brock_khans/32/409174_2.png) [@Brock\_Khans](https://forums.eveonline.com/u/Brock_Khans)\ **Post date:** [May 9, 2018, 4:31pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/20 "2018-05-09T16:31:48Z")
You need to clone the sheet so you have your own version, as the one I link is a view only. Then just write the item/ship name in the column on the left, hit enter, and it will lookup the typeid and then make the market calls. [Next page](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376.md?page=2)