Is it possible to have a tab with only sell prices for the 5 market hubs and to have the highest sell price for each hub to get highlighted? How would the most optimal sheet look like to buy from sell orders in Jita and sell in other hubs look like?
Hi,is there a way to avoid that the items change positions once you have added an item to the list? Exampl Item A is at position 134 but after adding a item it is at 135.So wen i wanna use the attached pice at that position in other sheets i get a wrong price
The ?Full=true removes the limit of how many prices you get back. With that the site will only return a limited amount of items. I haven’t found that the live?=true gave back updated prices let me knowing it does! But then it would return only a limited amount lines. This is obviously a very over simplified way of pulling live prices without having to go through the api it itself! Feel free to join the discord!
I might have figured it out? Whoever made the evepraisal tool might not have agreed to the updated terms of service? I get this error inside google sheets "The developer of this add-on has not accepted the terms and conditions of G Suite Marketplace. " when I try to add the evepraisal tool back into a new google sheet.
Hi! I've been trying to set up the eve market prices with excel too but I have a problem: the numbers provided by the query are set as "text". When I see your video, your datas are becoming decimal numbers after you split up the column but not for me, do you have any tips to make it work?
@@andtechie5210 Thx for the response but i found a (difficult) way out of my problem. When I tried to do what you said the column will just say "error" cause it didn't recognize the "xxx,xxx,xxx.xx" text as numbers. I actually found a way by making a pannel which remove the dots et comas from the cells and then convert it to numbers. Anyway, thx for the help.
@@francescopiva894 a bit late, but maybe i help somone. 1 you need to be in the menu which he shows at 7:31. 2 you need to right click the column and select "Typ ändern"(german) should be something like change type. 3 There you go to the format you wish it to be in. If that still doesnt work you can instead try the following instead of step 3 4 here you need to choose the one where you can also set the location (you have all the stuff like dezimal, text etc and one should stand out, in german its "mit Gebietsschema"). So the problem for me was that im from germany and here the dezimalsystem basically switches the , and the . (dot) thats why i need to change the location scheme to English(USA)+Dezimal.
Thanks for this, not only was it the top search result, but it worked first try. Much appreciated!
Glad to hear!!!!
Is it possible to have a tab with only sell prices for the 5 market hubs and to have the highest sell price for each hub to get highlighted? How would the most optimal sheet look like to buy from sell orders in Jita and sell in other hubs look like?
You need to pull from all of them,
And then vlook ups to each, sounds pretty simple! Join the discord
Hey, is it possible from the large item list that you have there try to filter items like t2, factions or BP in the excel?
Join the discord I have a mega list of every bp in the game with their materials and qty, based off the SDE from fuzzworks
Hi,is there a way to avoid that the items change positions once you have added an item to the list?
Exampl Item A is at position 134 but after adding a item it is at 135.So wen i wanna use the attached pice at that position in other sheets i get a wrong price
I think what would solve your problem is a vlookup, that formula will find what you need and bring the price back.
Would ?live=true solve the issue of needing new urls each time? not sure how that would work if you need ?full=true.
The ?Full=true removes the limit of how many prices you get back. With that the site will only return a limited amount of items. I haven’t found that the live?=true gave back updated prices let me knowing it does! But then it would return only a limited amount lines. This is obviously a very over simplified way of pulling live prices without having to go through the api it itself!
Feel free to join the discord!
@@andtechie5210 can I have the discord link pls
@@zaron8614 discord.gg/5T8JeeFs
@@andtechie5210 me too pls, that one is expired :(
@@Dyhrrr discord.gg/qHFG2dWb
Nice video!
Thanks for your job.
Can you tell me if it's possible to have the prce history of some item from jita or amarr?
Thanks for you reponse!
I don’t know exactly on pulling that,
Have you tried evemarketer.com
Hi I misunderstood your question,
Yes just do it twice. Once for jita other for amarr
Are the prices update automatic? Or i have to do the page query every time?
Do search every time, but the process of splitting things is already done you just need the new url
I might have figured it out? Whoever made the evepraisal tool might not have agreed to the updated terms of service? I get this error inside google sheets "The developer of this add-on has not accepted the terms and conditions of G Suite Marketplace.
" when I try to add the evepraisal tool back into a new google sheet.
May be so, all I know right now is that it works if you already have it
Awesome, thanks.
Hi! I've been trying to set up the eve market prices with excel too but I have a problem: the numbers provided by the query are set as "text". When I see your video, your datas are becoming decimal numbers after you split up the column but not for me, do you have any tips to make it work?
You set them as numbers in the menu after you load them I believe. Do you have a time stamp ?
@@andtechie5210 Thx for the response but i found a (difficult) way out of my problem. When I tried to do what you said the column will just say "error" cause it didn't recognize the "xxx,xxx,xxx.xx" text as numbers. I actually found a way by making a pannel which remove the dots et comas from the cells and then convert it to numbers. Anyway, thx for the help.
I have the same problem. How did you solved it?
@@francescopiva894 a bit late, but maybe i help somone.
1 you need to be in the menu which he shows at 7:31.
2 you need to right click the column and select "Typ ändern"(german) should be something like change type.
3 There you go to the format you wish it to be in.
If that still doesnt work you can instead try the following instead of step 3
4 here you need to choose the one where you can also set the location (you have all the stuff like dezimal, text etc and one should stand out, in german its "mit Gebietsschema").
So the problem for me was that im from germany and here the dezimalsystem basically switches the , and the . (dot) thats why i need to change the location scheme to English(USA)+Dezimal.
@@srgfreaky dont even remember what the video was about🥲 but thank you for answering