No video
EVE For Billionaires: Episode 5 - Dynamic Spreadsheeting Part 2
Follow us on Twitter!
/ ebinsider
In this episode we revisit our gdocs spreadsheet from the previous lesson and expand to give you further flexibility and versatility in design, including on-the-fly buy or sell location swapping.
Typename to TypeID CSV by Fuzzysteve:
www.fuzzwork.co.uk/resources/t...
Tradesheet Version 1.0 gdocs reference:
goo.gl/2Klfi
ImportXML for Excel:
stackoverflow.com/questions/14...
Music provided royalty free by Kevin MacLeod (incompetech.com)
Like and subscribe for more quality content!
Пікірлер: 93
This is probably the first tutorial I have viewed that actually managed to change the way I do business. Brilliantly done, brother!
Finally got a nice sheet going on after learning some basics on sheeting and a huge thanks to all you who make tutorial content for us scrubs...
Thank you so damn much for this. Spent a lot of isk on different guides that really didn't meet my expectations but you just helped me make my own spreadsheet for trading. You are the man...
Great video. I really like the way you explain everything.
You are really good at what you do, kudos and thanks for the help!
Once again thank you for this update I have a feeling I will use these spreadsheets alot
Excellent Spreadsheet-FU !!! Will use!
Change the item names to reflect the items you wish to use... and ensure that the item name matches what your TypeID list has for it + that it is in fact in the list with a valid ID.
Correct you are. I realized too late that the fix I prepped wasn't stable enough for a lesson build, and still had issues. I believe I've got a solution now, and will publish it as a very brief intro to my next segment on the topic of: *edited for top secret*.
Great videos, i hope you continue making them... Meldro i also had the issue of sorting I gave up as well but implemented more conditional formatting so that the larger the margin the bolder the green... not perfect but works ok
Great video. Thank you!
From what i could see at a quick glance, you can pull volume but it's the total number of that item up for sale and for purchase not how many had actually been sold/purchased
Question: Didn't you say at the end of part one that you were going to show how to retrieve data from eve central even if one of the item spaces is blank? Other than that, I love how you keep improving your implementation of the code for efficiency and ease of use. This is great stuff.
Awesome tutorial! I've been playing around and have tried to add market history data but I can't figure out how to end the vlookup what should I replace min/max with?
just amazing.. thanks very much for sharing
Great Video, thumbs up really informative and well presented. Is it possible to recreate this on a separate sheet in an easy way, other then having to copy and paste and re-input the maths formulas and ranges??
Thanks for the tutorials :) Question: Is there a way to get the quantity of buy/sell orders?
You're incredible!
Hey I was wondering if the api data also includes the volume moving per day? Kinda like what the tab shows in-game.
I assume its something along the lines of "usesystem" to "useregion" and of course the corresponding ID for that region. You could signify the station as well as they have ID's but again - dunno if "usestation" is a valid quiry...
Thank you!
Very good stuff, keep going o7
I know this is 7 years later but I just thought I'd throw this out there. Is there any way to do this exact same thing but for EvE Echoes?
This was super helpful thanks mucho for everything
im wondering is there a xml command to get the daily amount sold of a item too? some sort of "average/sold" maybe??
are you able to get the way the sell/buy works with jita and amarr but have it on regional level so for example The Forge Sell and Sinq Laison Buy?
Keep it up!
Thanks for doing these. I don't have any experience with api or doing spreadsheets like this but is there a way to units sold over X number of days? Like how you can see the graph in game.
Any tips for Excel 2013? Bit too green to get it working by trial and error
Dude, Love the spreadsheet! One question, how come it seems to go wonky if you repeat an item? For example, when I set the Name of the second battleship to Abaddon, the numbers don't match the row above and the list removes the bottom row of data? Again, excellent video!
If you make a mistake when typing an item or leave an item cell blank, that entire sell will be null and will need to be redone
Is there a place where your final spreadsheet is available online?
Excellent Job. Quick question though. When i change the drop down to Dodixie at typeid 30002659 i get an error. But the Jita one works. Any idea?
Good Job DB ones agen a good vid all can follow and understande. ty and fly safe. G
How can you get it to do commodities and Minerals and such?
use the same format you have here then just add a SUM command to a cell of your choice with the range for that command being the output of the "Sell" column for those items... Example using the SS of the spreadsheet on this video at the beginning... say all the t1 BS' is the list of your ship and all the items you want to see the total cost of =SUM($D3:$D14) If you want to see each market at the same time, just add additional columns per market and repeat (not sure if works with dropdown)
I'm looking into how to make a Spreadsheet to input all the modules and the ship, and be able to look on each market and see how much it will cost to purchase it all from that market, Could have multiple benefits. If you have any tips on how to do this it would help greatly.
Anybody any ideas i have this error "error: The data could not be retrieved. Please check the URL." I tried a few downloads of the trade sheet version 1 which had the same error after download before i touched the sheet. I done the vid tutorial in part 2 above to with everything exactly right. I even got version 2 from the link from steven L below and it still comes up with the same error.
Anyone have a link for how to do these things via excel?
There seems to be a limit of 50 rows due to, "ImportRange formulas: 50 cross-workbook reference formulas". I'm not sure about a work around for this. Maybe have a Trade 2 sheet?
Thank you for your time and effort in putting this video together. You've saved the world from a lot of bald people who would have pulled their hair out! ;)
Hey what about listing contracts How do I access them. Maybe show my production and manufacturing.
I'm trying to make a Tradesheet 3.0 that also shows the volume of each item on the market.I understand the general steps of making this work, and I know that EVE Online Market Data also includes information on volume, but what would I use in place of "//buy/max" or "//sell/min/"? Once I know that it's as simple as following steps. From there I can create a new color coded column for volume that will help me pinpoint the best deals in each and every system. Any advice?
@Calcearius
7 жыл бұрын
Did you figure this out in the end? I'm having the same issue.
I as well am recieving a "Data could not be parsed. Please make sure the URL point to a valid XML of HTML" This is the command =ImportXML(CONCATENATE(Sell_Swap,TypeID&JOIN(TypeID,$B3:B26)), "//sell/min")
@LuxembourgOnline
10 жыл бұрын
fixed?
@ericchambers2617
10 жыл бұрын
Olivier Terwindt Nope
@samuelalessi8477
10 жыл бұрын
You have $B3:B26 where it should be $B3:$B26. See if that works.
@LuxembourgOnline
10 жыл бұрын
it does! (: thx mate
@samuelalessi8477
10 жыл бұрын
No problem :)
Did anyone get this working with Excel 2013? I tried =FILTERXML(WEBSERVICE(CONCATENATE(Sell_Swap,TypeID&JOIN(TypeID,$B3:$B26))),"//sell/min") but it doesn't work.
My values wont change when i switch dropdown and are also just plain wrong in the first place. I've checked everything else; I've checked that each line of code is copied and I've even troubleshot other parts to make sure they work. The problem I've come across is in the concatenate section here's what i have: =ImportXML(CONCATENATE(Sell_swap,TypeID&JOIN(TypeID,$B3:$B26)), "//sell/min") changing Sell_swap to Jita results in no change. Am I missing something?
Is anyone having the problem with the importXML? im getting error: The data could not be parsed. Please make sure the URL points to valid XML or HTML. i dont know how to fix it, ive copied everything 100% the same, and it still not working...
anyone have the V2.0 that we can copy ?
doing the code for the buy and sell sections doesnt work how hes showing anymore, how do i fix this?
@theoddvictor8962
4 жыл бұрын
=IF(Buy_Dropdown="Jita Buy";Jita;IF(Buy_Dropwn="Amarr Buy";Amarr)) It changed from , to ;
Hi guys, I am also having problems. My error in the box underneath the dropdown Sell Field is "Wrong number of arguments to ImportXML" Any advise appreciated!
@jasonmcnie691
10 жыл бұрын
Fixed it on the 10th attempt lol
you should host a website and have some sort of forum.. gathering place..
I am having the same problem. I THINK he is saying DEL forward slash sell slash min. not forward slash forward slash sell. No idea how to get the "DEL" into the formula. Maybe Delta? I dunno. I can not get it it to work either and the video does not make it clear what he is typing in.
This was pretty good, but wow..what happened? One year later and no future episodes.
@lolzomgz1337
9 жыл бұрын
One year later and no anything. Look at the channel name...surely there was meant to be more?
@shitmandood
9 жыл бұрын
Somebody at EVE HQ must've capped him..
@sloandaddyslim
9 жыл бұрын
somehow accidentally joined his corp :) he said he was going to get back to this, but he is certainly qualified is all i say
I keep getting #N/A for the SELL BUY MARGIN TAX NET NET% boxes
How do you refresh the Sell and Buy data?
@SvenTeresniak
10 жыл бұрын
F5 in the Browser
How do we setup the Sell/Buy Price Swap Groups to allow data for Jita/Dodixie/Rens/Amarr/Hek? =IF(Sell_Dropdown="Jita Sell",Jita,IF(Sell_Dropdown="Amarr Sell",Amarr,""))
@User198303
10 жыл бұрын
=IF(Sell_Dropdown="Jita Sell",Jita,IF(Sell_Dropdown="Amarr Sell",Amarr,IF(Sell_Dropdown="Dodixie Sell",Dodixie,IF(Sell_Dropdown="Rens Sell",Rens,"")))) Name and define Dodixie and Rens exactly like you did with the other systems. Make sure when you have done in the math section to visit the "trade" page right click on the drop down menu select "Data Validation" and add to the Jita Sell,Amarr Sell,Dodixie Sell,Rens Sell. Click save and it should work flawlessly.
=ImportXml Formula doesn't work just returns (Xpath query returned no response) Anyone else have this problem and have a fix for it, I'm lost :(
awesome. :D
I´m stuck at 7:15. =IMPORTXML(CONCATENATE(Sell_Swap,TypeID&JOIN(TypeID,$B3:$B26)),"//sell/min") which leads to ERROR: Import Internal Error. Anybody got any idea why?
@gartheason6371
10 жыл бұрын
I am getting the same error unless I change $B3:$B26 to just $B3. Anyone have any thoughts as to why it is not wanting to take the range in the formula?
@seymourbutts3635
10 жыл бұрын
apparently its because eve online changed to crest so the imports are different....... im getting the same issues as well
Getting issues, saying "Did not find value " in VLOOKUP evaluation" any ideas?
@Witchking101
10 жыл бұрын
I fixed that, but now Im getting an error message saying "Could not fetch URL http:api.eve...etc"
@jcinnz
10 жыл бұрын
Adam Ross Im getting the same issue
@warrenreid8509
9 жыл бұрын
Adam Ross Did you find a resolution to this issue, because I'm running into the same error now.. maybe the server is down or something?
@travhull2006
9 жыл бұрын
Adam Ross Im getting the same error did anyone find a fix
@travhull2006
9 жыл бұрын
Warren Reid did you rind a resolutions
спс
Your CONCATINATE should read CONCATENATE - you have an "i" where you should have an "e" :) that may be why.
ok i found the link to it : docs.google.com/spreadsheet/ccc?key=0Arbwr19jS9tSdFA5bnptV0NYeG9VVGJIODVYUU13eWc#gid=0
@umad3546
9 жыл бұрын
How do you copy this?
Moar pls.
what happened to this guy ?
Dodixie 30002659, Rens 30002510
@travhull2006
9 жыл бұрын
mathefff23 ware did you find them I have been looking for over and hour
@mathefff23
9 жыл бұрын
Was a long time ago, sorry, don't remember. Surely on the EVE forum somewhere.
@travhull2006
9 жыл бұрын
Ok thanks