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...
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.
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
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
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.
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...
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??
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)
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?
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?
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!
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.
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?
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?
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.
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! ;)
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?
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")
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.
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?
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.
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!
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...
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,""))
=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.
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.
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.
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.
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
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*.
You are really good at what you do, kudos and thanks for the help!
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
Excellent Spreadsheet-FU !!! Will use!
Once again thank you for this update I have a feeling I will use these spreadsheets alot
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.
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...
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??
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)
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?
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?
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?
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!
im wondering is there a xml command to get the daily amount sold of a item too? some sort of "average/sold" maybe??
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.
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
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?
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?
apparently its because eve online changed to crest so the imports are different....... im getting the same issues as well
Thanks for the tutorials :) Question: Is there a way to get the quantity of buy/sell orders?
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.
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?
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 I was wondering if the api data also includes the volume moving per day? Kinda like what the tab shows in-game.
Great video. Thank you!
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?
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?
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")
fixed?
Olivier Terwindt Nope
You have $B3:B26 where it should be $B3:$B26. See if that works.
it does! (: thx mate
No problem :)
How can you get it to do commodities and Minerals and such?
Hey what about listing contracts How do I access them. Maybe show my production and manufacturing.
Any tips for Excel 2013? Bit too green to get it working by trial and error
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.
Is there a place where your final spreadsheet is available online?
Good Job DB ones agen a good vid all can follow and understande. ty and fly safe.
G
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?
just amazing.. thanks very much for sharing
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.
Anyone have a link for how to do these things via excel?
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!
Fixed it on the 10th attempt lol
doing the code for the buy and sell sections doesnt work how hes showing anymore, how do i fix this?
=IF(Buy_Dropdown="Jita Buy";Jita;IF(Buy_Dropwn="Amarr Buy";Amarr)) It changed from , to ;
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...
I keep getting #N/A for the SELL BUY MARGIN TAX NET NET% boxes
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,""))
=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.
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.
You're incredible!
Very good stuff, keep going o7
How do you refresh the Sell and Buy data?
F5 in the Browser
Getting issues, saying "Did not find value " in VLOOKUP evaluation" any ideas?
I fixed that, but now Im getting an error message saying "Could not fetch URL http:api.eve...etc"
Adam Ross
Im getting the same issue
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?
Adam Ross Im getting the same error did anyone find a fix
Warren Reid did you rind a resolutions
This was super helpful thanks mucho for everything
anyone have the V2.0 that we can copy ?
=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 :(
Thank you!
Keep it up!
Your CONCATINATE should read CONCATENATE - you have an "i" where you should have an "e" :) that may be why.
awesome. :D
спс
ok i found the link to it : docs.google.com/spreadsheet/ccc?key=0Arbwr19jS9tSdFA5bnptV0NYeG9VVGJIODVYUU13eWc#gid=0
How do you copy this?
Moar pls.
what happened to this guy ?
Dodixie 30002659, Rens 30002510
mathefff23 ware did you find them I have been looking for over and hour
Was a long time ago, sorry, don't remember. Surely on the EVE forum somewhere.
Ok thanks