# 💰 \[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:** 2
**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:33pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/21 "2018-05-09T16:33:13Z")
Great thank you o7 ---
**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:44pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/22 "2018-05-09T16:44:32Z")
2 More questions, first how do i delete some items so it isn’t cluttered with stuff that i’m not selling, and how do i see my broker buy and sell values ---
**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:55pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/23 "2018-05-09T16:55:12Z")
> [@Brock\_Khans](#): > > 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 You can either delete the item name in the rows you don’t care about ( it will show a nice red error though) Or you could just delete that whole row ---
**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, 5:08pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/24 "2018-05-09T17:08:02Z")
where can i find sell tax, sell broker, and buy broker in game? ---
**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, 5:22pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/25 "2018-05-09T17:22:53Z")
oh, in teh station you plan to use, just act like you’re going to sell an item, or act like you’re going to setup a buy order, and it shows in that dialog box ---
**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, 5:45pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/26 "2018-05-09T17:45:29Z")
sorry, final question, but is there a way to make it so it will show the price to buy something directly form 2 market hubs, like 2 column Cs that both show sell values in 2 systems so i can see what i can buy and sell quickly? ---
**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, 5:49pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/27 "2018-05-09T17:49:05Z")
You would have to duplicate one of the buy columns, and add some new variables as well. I did that for someone a couple months ago, I could probably figure it out again. Maybe charge this time 🙂 I’d just need edit access to your copy ---
**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, 5:51pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/28 "2018-05-09T17:51:02Z")
how much you thinking? ---
**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, 5:56pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/29 "2018-05-09T17:56:35Z")
Lets take this to mail, sent you a mail. ---
**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, 6:01pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/30 "2018-05-09T18:01:21Z")
can you send it to ElMal Eto instead this is my alt, ty ---
**Author:** ![Imustbecomfused](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/imustbecomfused/32/140896_2.png) [@Imustbecomfused](https://forums.eveonline.com/u/Imustbecomfused)\ **Post date:** [May 12, 2018, 5:21pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/31 "2018-05-12T17:21:46Z")
So I copied this and at made it into my own list. Learned a few things about conditional formating, and coloring my sheets… 😛 I like to color, its so pretty! Haha, just wanted to say thanks. Is there a chance you can make a basic sheet for what a player would need to access his assets? or a CEO for his corp assets? Using the new ESI and all here and Im slowly making progress if any at all. cheers. PS Ill send you a little donation for your work. ---
**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 12, 2018, 6:11pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/32 "2018-05-12T18:11:37Z")
For using ESI in google sheets I’d highly suggest [https://github.com/Blacksmoke16/GESI](https://github.com/Blacksmoke16/GESI) takes about 5-10 minutes to setup, and then you can call all the esi endpoints by just doing `=characters_character_attributes("brock khans")` as an example. ---
**Author:** ![Imustbecomfused](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/imustbecomfused/32/140896_2.png) [@Imustbecomfused](https://forums.eveonline.com/u/Imustbecomfused)\ **Post date:** [May 12, 2018, 7:20pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/34 "2018-05-12T19:20:25Z")
Thanks. I am in fact learning GESI atm. and I love that guide that they had to get started. I ran into a couple errors, and some i figured out, and others helped too. Im currently stuck because I dont have a basic overview of how ESI works and about endpoints, I have much to research still. I was working a trade sheet you offered here,. Thanks for the tips and Ill be sure to google all that stuff. ---
**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 12, 2018, 7:28pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/35 "2018-05-12T19:28:31Z")
I’d take a look over [https://esi.evetech.net/ui/](https://esi.evetech.net/ui/) to get an understanding of what each endpoint returns, all those endpoints are callable from GESI, you will just have to massage the data ---
**Author:** ![Imustbecomfused](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/imustbecomfused/32/140896_2.png) [@Imustbecomfused](https://forums.eveonline.com/u/Imustbecomfused)\ **Post date:** [May 12, 2018, 7:55pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/36 "2018-05-12T19:55:14Z")
IDk what all this does though. or how to use it. but thanks. im learning. 🙂 ---
**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 14, 2018, 9:12pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/37 "2018-05-14T21:12:57Z")
At the request of someone in my discord. I’ve added a markup column as well. ---
**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:** [June 8, 2018, 6:05pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/38 "2018-06-08T18:05:14Z")
Did a long overdue typeid update, it now has the most recent items from the game as of the Abyssal Expansion! If you have made your own and need to update the typeids, just delete everything in the typeid2 tab, and paste in the contents of [https://www.fuzzwork.co.uk/resources/typeids.csv](https://www.fuzzwork.co.uk/resources/typeids.csv) ---
**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:** [June 9, 2018, 5:39pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/39 "2018-06-09T17:39:33Z")
Scratch all that, thanks to the pointer of someone else the typeid2 tab now just automagically imports from the fuzzworks csv, so no more manual updating. For those who have their own sheet you can do this by deleting everything in the typeid2 sheet and in the top left cell (A1) just paste in `=Importdata("http://www.fuzzwork.co.uk/resources/typeids.csv")` ---
**Author:** ![Ryan\_B\_Thiesant](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ryan_b_thiesant/32/293156_2.png) [@Ryan\_B\_Thiesant](https://forums.eveonline.com/u/Ryan_B_Thiesant)\ **Post date:** [July 4, 2018, 9:29am UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/40 "2018-07-04T09:29:13Z")
BUMP. Trade EVE google sheet, that replaces the evecentral api with evemarketer api. Thank you so much. ---
**Author:** ![Liute](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/liute/32/257518_2.png) [@Liute](https://forums.eveonline.com/u/Liute)\ **Post date:** [August 13, 2018, 9:53pm UTC](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376/41 "2018-08-13T21:53:49Z")
Hi, i want to ask question about google docs spreadsheet, when i copy numbers from game and paste in sheet, for example eve copy numbers with spaces if its thousands for example 8 854 instead of 8854 i tried to remove with substitute but for some reason it doesn’t work with copy values from game but works with just value if i write it or copy from other source. Any tips how to fix that? I’m trying to create a sheet where i paste values and i get numbers. [Previous page](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376.md?page=1) [Next page](https://forums.eveonline.com/t/free-service-free-trade-spreadsheet/46376.md?page=3)