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

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

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

RETURNED - EVE Marketeer - Market Data Aggregation & Information
Author
Previous Topic Next Topic
Gabba Cyno
#381 - 2012-02-01 21:07:51 UTC
Nebu Retski wrote:
=ImportXML("http://www.evemarketeer.com/api/averages/10000043/90/34_35_36/xml";"//average")

This gives me pretty much a column of the average transactions per day for the 3 different items. Now you just make 5 more columns where you change //average with //maximum ...

There might be a better way to do it, but I don't know atm :)



Perfect. Thank you. I was missing the //average at the end.

.
Domi Etymology
Violent Alternatives
#382 - 2012-02-02 13:06:33 UTC  |  Edited by: Domi Etymology
Awesome new tool with the Best Loyalty Points functionality. Is there anyway to restrict it to a certain type? ie: caldari navy LPs, or Amarr Navy, LPs, etc?
Scrapyard Bob
EVE University
Ivy League
#383 - 2012-02-02 13:21:10 UTC
Any ideas / plans yet on adding "virtual" regions to the list of regions? You'd definitely need to do the calculations based only on orders downloaded within the past 7 days.
https://forums.eveonline.com/default.aspx?g=posts&m=623346#post623346

I also figured out why the EVE client was being so piggy about the CPU when doing "history" scans. The market window is very inefficient at drawing those history graphs. Switching to "Show Table" view keeps things humming along nicely.
Scrapyard Bob
EVE University
Ivy League
#384 - 2012-02-02 13:30:30 UTC
Also, the "play" button to start/pause scanning is fine on the left. I've figured out that I can click the "GO" button in the IGB to pause scanning. (Please make sure that you don't auto-restart scanning based on the status of some cookie.)
Scrapyard Bob
EVE University
Ivy League
#385 - 2012-02-02 14:20:37 UTC
What is the \Q/ at the top of the screen for?

One interesting statistic that I'm curious about: What systems have the highest trade volume per day, maybe a list of those where the 7-day moving average puts them into the top 25 systems. Repeated for regions too. The Statistics/Market for the regions is interesting, but since there's a ton of "junk" orders for outrageous prices, the "Sell Total" number isn't very accurate.

Maybe add "7-day transaction total" column to the new statistics/market window. Which might give us a better feel for which regions turn over the most ISK/wk.
6ie
The Kiwis
#386 - 2012-02-02 15:10:42 UTC
Every time I clicked the \Q/ I got 1mill in my bank account
Callean Drevus
Perkone
Caldari State
#387 - 2012-02-02 16:39:18 UTC  |  Edited by: Callean Drevus
6ie wrote:
Every time I clicked the \Q/ I got 1mill in my bank account


Damm! That feature was supposed to be VIP only :P

Will reply to other stuff when not on phone.

Developer/Creator of EVE Marketeer
Callean Drevus
Perkone
Caldari State
#388 - 2012-02-02 18:27:22 UTC
Quote:
Awesome new tool with the Best Loyalty Points functionality. Is there anyway to restrict it to a certain type? ie: caldari navy LPs, or Amarr Navy, LPs, etc?

Not yet, but it is on the backlog :P
Quote:
Any ideas / plans yet on adding "virtual" regions to the list of regions? You'd definitely need to do the calculations based only on orders downloaded within the past 7 days.

I have long been thinking of adding virtual characters, but virtual regions are new. That said, there is no reason not to add them. Are you talking now about arbitrary regions combined, or arbitrary security ratings combined?

As far as I know, the scanner does not auto restart. Have you experienced that behaviour?
Quote:
What is the \Q/ at the top of the screen for?

The Q at the top of the screen is meant to be a quicklist for items and destinations (stations, regions, etc) that you can quickly click or view. So far I have failed to find a satisfactory format though.
You can add some items by clicking on 'add to emk quickbar' on the item information page.
Quote:
One interesting statistic that I'm curious about: What systems have the highest trade volume per day, maybe a list of those where the 7-day moving average puts them into the top 25 systems. Repeated for regions too. The Statistics/Market for the regions is interesting, but since there's a ton of "junk" orders for outrageous prices, the "Sell Total" number isn't very accurate.

And that's with a lot of junk orders already filtered out. It's too bad I can't filter items for which there isn't anything else on the market for reasonable prices.
A 7 day moving average for transactions seems like a very plausible way to check market volume. Will do!

Developer/Creator of EVE Marketeer
Scrapyard Bob
EVE University
Ivy League
#389 - 2012-02-02 22:56:29 UTC
Callean Drevus wrote:
Quote:
Awesome new tool with the Best Loyalty Points functionality. Is there anyway to restrict it to a certain type? ie: caldari navy LPs, or Amarr Navy, LPs, etc?

Not yet, but it is on the backlog :P
Quote:
Any ideas / plans yet on adding "virtual" regions to the list of regions? You'd definitely need to do the calculations based only on orders downloaded within the past 7 days.

I have long been thinking of adding virtual characters, but virtual regions are new. That said, there is no reason not to add them. Are you talking now about arbitrary regions combined, or arbitrary security ratings combined?


Both. But not completely arbitrary, just some major pre-defined groupings. Such as the "hi-sec" price or "market hubs" price.

For instance, on EMD, I can get a price for a Naga across all of hi-sec:
http://eve-marketdata.com/price_check.php?step=Show&type_id=4306&type=sell&region_id=-2

Or just lo-sec:
http://eve-marketdata.com/price_check.php?step=Show&type_id=4306&type=sell&region_id=-3

Or both:
http://eve-marketdata.com/price_check.php?step=Show&type_id=4306&type=sell&region_id=-4

EMD doesn't currently offer a "market hub" option. And it doesn't filter out orders which haven't been updated or downloaded in the past few weeks, so sometimes you get a page of useless information.

Being able to pull an API value for a particular item in a virtual region composed of "all hi-sec, all lo-sec, empire, or null, or market hubs" would be useful as a way of getting a closer valuation of a particular item then just going with the Jita price. While Jita's sell prices are usually the lowest, if there is market manipulation occurring, Jita sell prices can get very whacky. In which case, the long-term value is probably closer to the average of the other (3) market hubs.

So by doing the 5% simulated buy across all (4) market regions or all of hi-sec, I'm hoping that it would give better values for tools like jEvEAssets, EvEHQ, EvEMeep or spreadsheets. Better option then relying on just Jita pricing.

I think a good list of virtual regions would be:

"hi-sec" - any hi-sec station gets included in this price
"lo-sec" - same, but for lo-sec stations
"null-sec" - same, but for null-sec
"empire" - include both hi-sec and low-sec stations
"main market hubs" - roll-up Jita, Amarr, Dodixie and Rens
"main market regions" - hi-sec stations in Domain, Forge, Heimatar and Sinq Laison

I'd suggest filtering out any orders not updated within the past 7 or 14 days, no sense handing out bad information in these roll-up "virtual" regions.
Scrapyard Bob
EVE University
Ivy League
#390 - 2012-02-02 22:59:02 UTC
EMD's market scanner page would sometimes auto-restart, which is why I didn't consider that a viable method of pausing the EMD's market scanning page.

EMK's market scanner page does not automatically restart. This is a good thing.

(Yes, I could close the in-game browser window, but that little "x" can be difficult to hit if the client starts lagging. The "Go" button is a lot larger, and the play/pause button is even bigger.)
Gabba Cyno
#391 - 2012-02-03 05:03:55 UTC
How many IDs can be pulled per importxml?

.
Callean Drevus
Perkone
Caldari State
#392 - 2012-02-03 06:54:44 UTC
Gabba Cyno wrote:
How many IDs can be pulled per importxml?

Here I was thinking you people were all idiots because this information was on the API page, but it's not, so I apologize. Anyway, the limit is 25 per call, and I'll soon add that to the page.

Developer/Creator of EVE Marketeer
Nebu Retski
Lead Farmers
#393 - 2012-02-03 11:11:48 UTC
Callean Drevus wrote:
Anyway, the limit is 25 per call, and I'll soon add that to the page.


From some testing that I did, it seems that there might be a bug on your side. At a certain point the return data is not complete. Whenever I request 16 items I only get the first 15 returned (from 1 item until 15 items everything looks fine though), check for yourself -> http://www.evemarketeer.com/api/info/36_35_34_2268_2305_2267_2288_2287_2307_2272_2309_2073_2310_2270_2306_2307/xml/10000043/sell_lowest5

When requesting 18 or more items, the last 2 items will not be returned.
18 items url -> http://www.evemarketeer.com/api/info/36_35_34_2268_2305_2267_2288_2287_2307_2272_2309_2073_2310_2270_2306_2307_2308_2309/xml/10000043/sell_lowest5

25 (should be the hard limit) items url -> http://www.evemarketeer.com/api/info/36_35_34_2268_2305_2267_2288_2287_2307_2272_2309_2073_2310_2270_2306_2307_2308_2309_2393_2396_3779_2401_2390_2397_3683/xml/10000043/sell_lowest5

Can you confirm this bug or else I should scratch my head a bit more as to why it happens to me :-)
Scrapyard Bob
EVE University
Ivy League
#394 - 2012-02-03 11:45:32 UTC
(chuckle) Oh look, I'm not the only one who can break things!

\Q/

In that 3rd URL, in the sequence "2308_2309_2393", the 2309 is being dropped from the result set.
http://www.evemarketeer.com/item/info/2309

Also in the sequence: 2306_2307_2308, the 2307 is missing
http://www.evemarketeer.com/item/info/2307

Region #43 is Domain.

Now the odd thing is that I have almost the exact same query in one of my sheets, but I'm only pulling 24 at once, and #2307 shows up fine for me (along with 2309).

http://www.evemarketeer.com/api/info/2268_2305_2267_2288_2287_2307_2272_2309_2073_2310_2270_2306_2286_2311_2308_2393_2396_3779_2401_2390_2397_2392_3683_2389/xml/10000043/sell_lowest5
Nebu Retski
Lead Farmers
#395 - 2012-02-03 12:13:04 UTC
Scrapyard Bob wrote:
In that 3rd URL, in the sequence "2308_2309_2393", the 2309 is being dropped from the result set.
http://www.evemarketeer.com/item/info/2309

Also in the sequence: 2306_2307_2308, the 2307 is missing
http://www.evemarketeer.com/item/info/2307


I found what the issue was, so it's not a bug (well it was a little bit, but on my side :-)). You can't have duplicates in your urls (as I had in my url 2*2309 and 2*2307). Once I had removed the duplicate entries I was able to pull 25 in one go.

Thx Bob for pointing it out.
6ie
The Kiwis
#396 - 2012-02-03 12:26:43 UTC
The search that was changed in the last few days doesn't work so well.

Cut/Paste in: Medium Anti-Kinetic Screen Reinforcer I
then you get a drop down of 4 items
click "Medium Anti-Kinetic Screen Reinforcer I"
and it takes you to a page:
Could not find 'Medium Anti-Kinetic Screen Reinforcer I'
Perhaps you meant one of these items? (and list the same 4 items...)

I clicked "Medium Anti-Kinetic Screen Reinforcer I" on the drop down, it knows what i wanted, it should have taken me to the "Medium Anti-Kinetic Screen Reinforcer I" page.
Callean Drevus
Perkone
Caldari State
#397 - 2012-02-03 20:13:21 UTC
@6ie: Absolutely correct :) I built in the second page to allow people to type in arbitrary things like 'caldari carrier' and still have the option of finding whatever they were looking for. The old search was pretty restrictive (though less restrictive than other sites :P).

I agree however, that when you click the dropdown, it should take you to the item immediately. Will fix that.

@API trouble: Ah, yes. The server doesn't like it when you query for the same thing twice. Or rather, it doesn't bother returning it twice. If you really need that functionality it may be better to just query them all independently.

Developer/Creator of EVE Marketeer
Jaqa
Royale Strategic Imperative
#398 - 2012-02-04 22:54:29 UTC
Excellent site--keep up the great work.

The Original Jaqalope Pilot of the Transportosaurus Rex 100% Free Range
Callean Drevus
Perkone
Caldari State
#399 - 2012-02-05 08:20:56 UTC
Thank you.

I added PI information (for PI items) and filtering for the best loyalty point items this weekend (and some small things which I forgot).

Developer/Creator of EVE Marketeer
Scrapyard Bob
EVE University
Ivy League
#400 - 2012-02-05 11:20:14 UTC
When I was trying out the Loyalty point stuff last night... (loving the feature, BTW).

- It proved to be impossible, once you picked a faction and then changed the corp to a specific one within the faction to get the corp drop down to go back to "All" without changing factions and then going back to the same faction.

1. Pick faction
2. Pick corp
3. decide you want to go back to seeing "all" corps, change back to "all"
4. corp-drop down keeps resetting to list the last corp you looked at after submit

(So there's definitely a problem in both the corp/faction pull-downs where you can't get them back to "all".)

- When looking at an item details, the "LP Store" tab was always blank, but only for some items. Some worked, some didn't.

http://www.evemarketeer.com/item/info/27187
http://www.evemarketeer.com/item/info/27231

- Value column in the bestloyaltypoints page may need an option to work off of the 5-day or 7-day or 30-day moving average historical price rather then sell/buy.

http://www.evemarketeer.com/item/info/27231
(This item seems to only ever change hands for 900k to 2.1M ISK, but the 5% number in the Forge is 15M ISK.)

- Because of the length of names on things like Implants, the mouse-over tool-tip text for the Type column links should probably be changed from "View EMK item information" to the name of the page that you are linking to. But at least the columns are resizable.