💰 [FREE SERVICE] Free Trade Spreadsheet 💰

(Brock Khans) #42

Try ctrl shift v instead of normal ctrl v

(Liute) #43

nvm found solution its some other kind of " " space so i just did copy that space and paste in substitude inside “” and it worked lol.

(Brock Khans) #44

Getting quite a few people requesting access to my trade sheet. You need to be going to File -> Make Copy instead, so you now have your own private copy

Regional price/margin tools?
(Lee Spicer) #45

How would I add a refresh button or what would be a easy way to trigger a refresh of the prices?

(Brock Khans) #46

Just google : auto refresh google sheet

(Ryan B Thiesant) #47

Kinda thinking spamming that will get the feed x’d for good.

(Bubbarabb Stjames) #48

70 @Brock_Khans, how would I go about, or how much would it cost to get this setup for like a region trading setup? including volumes of orders bought and sold the day of the refresh? you can evemail me in game if that makes it easier to respond. Thanks for the awesome spreadsheet!

(Brock Khans) #49

I use evemarketer api. They have the region data , you would just need to add a new call. Right now I only do solar system calls https://api.evemarketer.com/ec/

Not in a position to help beyond that

(Bubbarabb Stjames) #50

cool. thats fine. i aint technically savvy like that so hope you can get to that eventually. thanks anyway man.

(Brock Khans) #51

Still a great sheet to try out for beginners!

(Tzn-Su Tsutola) #52

If I delete a row, how can I add it back later on? I tried just typing an item name there but it doesn’t work.

(Brock Khans) #53

I generally wouldn’t ever delete rows. You may need to add it back into the ranges in some of the formulas

and dragging down the blue square on some of the others.

(Tzn-Su Tsutola) #54

I’ll leave them alone.lol can I leave the row blank? if I currently try it makes all rows stop working.

(Brock Khans) #55

I don’t believe so, if anything just put tritanium in all the ones you don’t care about

(Tzn-Su Tsutola) #56

I did just that, thanks for the tip, with such a small price number it makes it easy to differentiate between my orders and whats “blank” lol

(Tzn-Su Tsutola) #57

On another note how hard would it be for me to add a volume column and figure out how many buy orders are being made vs sell orders, would that be possible or is it wishful thinking.

(CaptainCool) #58

Hero! I really needed this!
But I can seem to add new items to work… I’ve tried just typing the item name in the far left column below the last item(Breacher) but the prices don’t show up.

Have also tried manually putting in the typeID using =vlookup(…), still, don’t work.
Am I doing anything wrong? 22742e416613ccdeb63f8972bbf51618

(Brock Khans) #59

I use the evemarkerter API to supply prices, and currently only get the sell/buy data, however you can look over what is returned in the GET request here https://api.evemarketer.com/ec/ to what information is also available for you to pull down

(Brock Khans) #60

155 rows seems to be the soft/hard limit before googlsheets starts to complain at you for excessive calls in/out of your google sheet. Which is why I stopped there

(Tzn-Su Tsutola) #61

Thanks, now I just need to figure out what it is I’m looking at.lol your sheet has been awesome so far.