Great thank you o7
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
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
where can i find sell tax, sell broker, and buy broker in game?
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
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?
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
how much you thinking?
Lets take this to mail, sent you a mail.
can you send it to ElMal Eto instead this is my alt, ty
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.
For using ESI in google sheets I’d highly suggest 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.
1 Like
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.
I’d take a look over 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
IDk what all this does though. or how to use it. but thanks. im learning.
At the request of someone in my discord. I’ve added a markup column as well.
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
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")
BUMP.
Trade EVE google sheet, that replaces the evecentral api with evemarketer api.
Thank you so much.
1 Like
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.