These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Free Trading Sheet
Author
Previous Topic Next Topic
CJ Alland
CB Trading
#1 - 2015-01-01 14:01:37 UTC  |  Edited by: CJ Alland
In case anyone wanted a spreadsheet for trading, doesn't know how to make one and doesn't want to have to pay.

It's not amazing. You can build off it though.

https://docs.google.com/spreadsheets/d/15ZeNosF1RCkCznE1eqiIHEbSiPGgpKR0LrrN1s5PU2c/edit?usp=sharing

Choice between Jita, Amarr and Dodixie.

Assuming broker fee and Transaction tax is 0.75%


The item choices are blank but you can easily pick them.

Using http://www.eve-markets.net/list?listid=703 to pick items might be helpful


Donations are appreciated but not required.




If anyone has any spreadsheet ideas send them my way.
Jerry T Pepridge
Meta Game Analysis and Investment INC.
#2 - 2015-01-01 14:10:37 UTC
i couldnt change anything or type anything is there something wrong with the sharing. is it sposed to be typed or drop boxes?

not being able to change the tax is a small issue tho

thanks, great for set & forget traders :p

@JerryTPepridge
CJ Alland
CB Trading
#3 - 2015-01-01 14:12:56 UTC  |  Edited by: CJ Alland
It's currently sent as view only. I'll make it editable but then someone could destroy it.

If you want to use it make a copy.

I'll make it editable so you can test it.

https://docs.google.com/spreadsheets/d/1myz6VN34zzjRlYWb6I5_fBYWOJDVq_GSaKjkIt5KPR0/edit?usp=sharing


In regards to the dropdown boxes. If you start typing it'll give suggestions.

But you can just click on the drop down, and scroll through.
Jerry T Pepridge
Meta Game Analysis and Investment INC.
#4 - 2015-01-01 14:21:52 UTC
Jerry T Pepridge
Meta Game Analysis and Investment INC.
#5 - 2015-01-01 14:23:29 UTC
not sure dude i punched in nanoribbon it did the "lookup thing" but no prices

@JerryTPepridge
CJ Alland
CB Trading
#6 - 2015-01-01 14:26:58 UTC
Yeah, it's meant to be on the next line. If you look at the hidden sheets it might make more sense.


When you add a new item make sure there isn't a gap between the item before.
Jerry T Pepridge
Meta Game Analysis and Investment INC.
#7 - 2015-01-01 14:33:42 UTC
CJ Alland wrote:
Yeah, it's meant to be on the next line. If you look at the hidden sheets it might make more sense.


When you add a new item make sure there isn't a gap between the item before.


thanks ill work on it some ;)

@JerryTPepridge
CJ Alland
CB Trading
#8 - 2015-01-01 14:38:09 UTC
np, you might have to add items to the TypeID list if they don't show up
Makhpella
Bad Taste.
#9 - 2015-01-01 15:22:51 UTC
Wow free stuff, cool. I give you 100 Internet Credits.

Can I resell it?
CJ Alland
CB Trading
#10 - 2015-01-01 15:28:51 UTC
not sure you'll be able to resell it when it's free but sure give it ago. I'll take 50% commission. :)
CJ Alland
CB Trading
#11 - 2015-01-01 21:53:12 UTC
Jerry T Pepridge wrote:
http://i.imgur.com/vavLaMS.png


Ha just realised you posted in that guys thread about a 20b pledge and that's what the 20b writing was :S
Mireilee Aldes
Viziam
Amarr Empire
#12 - 2015-01-01 22:18:10 UTC
I am kind of new at the whole spreadsheet thing, but I take this spreadsheet is for station trading only? and in order to to make it inter-regional trading, you would have to duplicate Prices tab, change the duplicate name to Prices2, change its vlookup to a different system number, and then change Trade tab's sale column to reflect Prices2's values...?
CJ Alland
CB Trading
#13 - 2015-01-01 22:29:43 UTC
Mireilee Aldes wrote:
I am kind of new at the whole spreadsheet thing, but I take this spreadsheet is for station trading only? and in order to to make it inter-regional trading, you would have to duplicate Prices tab, change the duplicate name to Prices2, change its vlookup to a different system number, and then change Trade tab's sale column to reflect Prices2's values...?


I have a spreadsheet for just that. I can try to fix it if you want it.
CJ Alland
CB Trading
#14 - 2015-01-01 22:37:23 UTC
Mireilee Aldes wrote:
I am kind of new at the whole spreadsheet thing, but I take this spreadsheet is for station trading only? and in order to to make it inter-regional trading, you would have to duplicate Prices tab, change the duplicate name to Prices2, change its vlookup to a different system number, and then change Trade tab's sale column to reflect Prices2's values...?



Turns out it was just easier to mod the spreadsheet that I was sharing already. Finished the change. Hopefully that will be useful?

I also have my first spreadsheet for inter-regional trading but it is only purchasable.

http://i.gyazo.com/4e4e16f6a1899e848ce4fc56531407a8.png

http://i.gyazo.com/8ca50c7c0b660f4806fe81f0ff3afebe.png
Mireilee Aldes
Viziam
Amarr Empire
#15 - 2015-01-01 22:49:22 UTC
Yeah that works, thanks!
Also your other spreadsheet seems like a a more extensive version of http://darkshadowindustries.com/marketfeed
CJ Alland
CB Trading
#16 - 2015-01-01 22:52:03 UTC
Mireilee Aldes wrote:
Yeah that works, thanks!
Also your other spreadsheet seems like a a more extensive version of http://darkshadowindustries.com/marketfeed


Yeah kinda I guess. But I used it too find minerals to buy and look for the best place to sell them.
Jerry T Pepridge
Meta Game Analysis and Investment INC.
#17 - 2015-01-02 05:21:44 UTC
CJ Alland wrote:
Jerry T Pepridge wrote:
http://i.imgur.com/vavLaMS.png


Ha just realised you posted in that guys thread about a 20b pledge and that's what the 20b writing was :S


hang about some more :p

@JerryTPepridge