Pages: [1] 2 3 4 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.01.29 16:41:00 -
[1]
Edited by: Goncyn on 29/01/2008 16:41:23 EVE Asset Manager is a program that will download your characters' assets from the EVE API, then let you view and search them. It is a .NET 2.0 application. Current features:
- Combines asset data from all your characters and all corporations of which your characters are Directors.
- Search your assets using customizable search fields.
- Save and load sets of search parameters.
- Generate Materials, POS Fuel, and Ship Loadouts reports in HTML.
Download links, instructions, and other information: http://wiki.heavyduck.com/EveAssetManager
News and release announcements: http://www.heavyduck.com/
I look forward to comments and suggestions. Also, I'd like to thank Jack Toad for uploading the trinity static data export in SQLite3 format, because he saved me a lot of time and effort.
Note: this program requires that you use your Full API Key. I encourage you to study its behavior with a program such as TCPView to verify that it never sends your API Keys to any website but eve-online.com.
|
Jessamine
Investment Relations Limited
|
Posted - 2008.01.29 18:56:00 -
[2]
Downloading now, this looks promising. Been looking for a dload version since I found Bellatroix's online one...
inEvE Stats |
Kazri DelRae
|
Posted - 2008.01.29 19:23:00 -
[3]
This is wickedly cool. Two things. Where are you pulling prices from? I'm assuming eve-central.com and is there a possibility of making custom reports as in "Show all my large guns and ammunition" just as an example.
Very excellent, kudos on your excellent work.
|
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.01.29 19:46:00 -
[4]
Originally by: Kazri DelRae This is wickedly cool. Two things. Where are you pulling prices from? I'm assuming eve-central.com and is there a possibility of making custom reports as in "Show all my large guns and ammunition" just as an example.
Kazri, thanks for the kind words.
I am pulling prices from eve-central, yes, limited to region The Forge, using their "avg_price" field. My app will cache these prices for 24 hours.
As for custom reports, I plan to add a general "Current search results to HTML" type of report. I will probably make it grouped by item Category name with subheadings by Group name, how does that sound?
|
Kaska102
Caldari
|
Posted - 2008.01.29 21:05:00 -
[5]
Program looks nice, but I first ran it then tried to do an import immediately, and I get a System.Data.SqLite error "No such table: assets". I havent looked at the source but I'm guessing on an import it expects the assets table to be there but thats create somewhere when the keys are input.
|
Kazri DelRae
|
Posted - 2008.01.29 21:06:00 -
[6]
Would it be possible to pull eve-central data and disregard extraneous ones? I think your data is getting skewed by low/highball marketing. Perhaps check the mode and disregard anything of more than 50% difference and then avg that?
Probably something eve-central should do and put that in the stream instead of having the third-party program do it. Just a thought!
Love it and keep up the good work, you aren't toiling in obscurity!
|
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.01.29 21:23:00 -
[7]
Originally by: Kaska102 Program looks nice, but I first ran it then tried to do an import immediately, and I get a System.Data.SqLite error "No such table: assets". I havent looked at the source but I'm guessing on an import it expects the assets table to be there but thats create somewhere when the keys are input.
Hmm, I thought I had accounted for this, but perhaps not. I'll see if I can reproduce it later. Thanks for the bug report!
Originally by: Kazri DelRae Would it be possible to pull eve-central data and disregard extraneous ones? I think your data is getting skewed by low/highball marketing.
The eve-central web service provides only aggregates, so I can't do any additional computations. Here's what the data I am fetching looks like:
<?xml version="1.0" encoding="utf-8" ?> <!-- Automatically generated data from EVE-Central.com --> <market_stat> <typeid>34</typeid> <avg_price>2.4291076221050001</avg_price> <total_volume>105391176172</total_volume> <avg_buy_price>2.05939127812043</avg_buy_price> <total_buy_volume>66657465007</total_buy_volume>
<stddev_buy_price>0.52072237023705903</stddev_buy_price> <max_buy_price>3.71</max_buy_price> <min_buy_price>0.17000000000000001</min_buy_price>
<avg_sell_price>3.2201859950662701</avg_sell_price> <total_sell_volume>38734696817</total_sell_volume> <stddev_sell_price>2494812.9563761698</stddev_sell_price>
<max_sell_price>100000000.0</max_sell_price> <min_sell_price>1.0</min_sell_price> </market_stat> If you think it would provide a more accurate picture of market value to use avg_sell_price instead of avg_price, then I can experiment with that.
|
Gamajan
|
Posted - 2008.01.30 02:12:00 -
[8]
I have same error as Kaska 'no such table: assets'.
|
Gamajan
|
Posted - 2008.01.30 03:03:00 -
[9]
Sorry my fault - I used limited API key :(
|
Jessamine
Investment Relations Limited
|
Posted - 2008.01.30 16:54:00 -
[10]
Edited by: Jessamine on 30/01/2008 16:55:09 Edited by: Jessamine on 30/01/2008 16:54:26 Honestly I would use the average sell price, seeing as people put up tons of bogus buys hoping that people will be to lazy to move or check prices and it really pulls down the average. Of course there are inflated sell orders too (who hasn't seen a shuttle for 9m instead of 9k) but on the whole I think I see more of an issue with deflated buy orders (and that data dump for trit supports this, the avg sell is much more representative of cost than the avg buy, imo)
Maybe include the option to use one/the other/both? I'm not a programmer so I don't mean to introduce a world of difficulty on you. Would be nice if EVE just exported past market data instead of just the buy/sell orders. That way we could see real volume throughput and affecting those prices would require a lot more effort than just a huge buy order at a rock bottom price.
Edit: I got the error where it coudn't find the assets table too. I hdan't imported them yet after entering the API key. |
|
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.01.30 17:35:00 -
[11]
Thanks for the feedback on the pricing, Jessamine. For the next version, I'll swap to using the avg_sell_price and you guys can see how you like it. I'm trying not to introduce any options right now, I need to program some more UI for that which I will get to later.
Last night, I improved the database initialization code that was causing those "assets table not found" errors. There are a few more things I want to fix, but I should be ready to release a new version in a few days.
|
Samantha Watanabe
|
Posted - 2008.01.31 14:30:00 -
[12]
Would it be possible to make a per station asset report? I do a bit of trading in a somewhat busy area and if this thing could tell me the estimated isk value of my posessions on a per station basis, and I could sort the returns by that value, it would take a lot of the guess work out of my time and allow me to simply go pick up stuff from the top stations on the list. You would basically be my personal hero if you did this :)
|
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.02.01 03:40:00 -
[13]
Originally by: Samantha Watanabe Would it be possible to make a per station asset report? I do a bit of trading in a somewhat busy area and if this thing could tell me the estimated isk value of my posessions on a per station basis...
This is certainly possible, but I'm a little wary of making that many requests to eve-central for the prices. Anyone with a reasonable amount of stuff is going to have at least several hundred item types, if not a few thousand. Currently, only the Materials report has pricing, so there's a built-in limit of however many item types there are in the Material category. I'll ask the eve-central operator what he thinks about it.
|
Samantha Watanabe
|
Posted - 2008.02.01 23:13:00 -
[14]
What about using the base price in absense of an actual price?
|
Gamajan
|
Posted - 2008.02.02 04:01:00 -
[15]
I've got few suggestions for improvement! 1. I guess it would be very useful if there will be an option of exporting current query results as a list in HTML format (possibly with item highlights and data on mouse over, etc.). 2. Add some query fields such as item's meta level (to make possible to filter results using this meta level field).
|
Selene D'Celeste
Caldari The D'Celeste Estate
|
Posted - 2008.02.03 07:54:00 -
[16]
1) use baseprice in reports 2) reports - baseprice value of assets per station, baseprice value of assets per item type, number of items of each type owned 3) allow export to CSV 4) ??? 5) Profit!
=D
|
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.02.05 08:31:00 -
[17]
Version 1.5.0
- Added 'Manage Saved Queries' dialog. - Added option to use a saved search in the Report Options dialog. - Added CSV export. - Added 'Assets by Category' report. - Added 'Assets by Location' report. - Added basePrice and metaLevel columns and search fields. - Added price info/disclaimer to applicable reports. - Added ability to use cached XML data when contacting the API fails. - Added awareness of Outposts for purposes of getting location names. - Changed to use avg_sell_price instead of avg_price for Materials report. - Tweaked report output to validate as XHTML 1.1 with minimal warnings. - Tweaked formatting of Ship Loadouts report headings. - Tweaked formatting of numeric columns. - Fixed a few situations that could lead to a missing assets table in the local cache.
http://wiki.heavyduck.com/EveAssetManager
|
Jessamine
Umbra Legion
|
Posted - 2008.02.05 19:02:00 -
[18]
Changes look neat downloading and comparing now!
Custom Corporations for Hi-Sec POS Anchoring - All Empires Available!
inEvE Stats |
Jessamine
Umbra Legion
|
Posted - 2008.02.05 19:23:00 -
[19]
Possible bug: When I export to a materials report I get a price breakdown of my rogue drone components/ salvage. However, when exporting to 'Assets by Category' or 'Assets by Location' the isk value of both of these is zero.
Keep up the great work!
Custom Corporations for Hi-Sec POS Anchoring - All Empires Available!
inEvE Stats |
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.02.05 20:21:00 -
[20]
Originally by: Jessamine When I export to a materials report I get a price breakdown of my rogue drone components/ salvage. However, when exporting to 'Assets by Category' or 'Assets by Location' the isk value of both of these is zero.
The 'Materials' report uses pricing data from eve-central. The 'Assets by ...' reports use the baseprice of the item.
|
|
Jessamine
Umbra Legion
|
Posted - 2008.02.05 20:58:00 -
[21]
Originally by: Goncyn
Originally by: Jessamine When I export to a materials report I get a price breakdown of my rogue drone components/ salvage. However, when exporting to 'Assets by Category' or 'Assets by Location' the isk value of both of these is zero.
The 'Materials' report uses pricing data from eve-central. The 'Assets by ...' reports use the baseprice of the item.
That explains that, is there a reason for the disparity? Seems strange to have them parsing from different prices.
Custom Corporations for Hi-Sec POS Anchoring - All Empires Available!
inEvE Stats |
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.02.05 22:09:00 -
[22]
Originally by: Jessamine That explains that, is there a reason for the disparity? Seems strange to have them parsing from different prices.
Only what I posted a few days go, that I was concerned about hitting eve-central rapid-fire for several hundred prices. The 'Materials' report contains a limited number of item types, and those types are the ones most influenced by market pricing, so it makes sense to use the eve-central data there.
I added a line at the top of each report indicating where the prices come from, so it shouldn't be too confusing.
|
Selene D'Celeste
Caldari The D'Celeste Estate
|
Posted - 2008.02.07 02:53:00 -
[23]
You work fast, A+, will buy again =D
Actually, if you're ever in game and bored, shoot me a convo and I'd love to chat about this program and its uses =)
|
Big Al
The Aftermath
|
Posted - 2008.02.07 13:55:00 -
[24]
Awesome program, great work!
|
Valeo Galaem
New Eden Advanced Reconnaissance Unit
|
Posted - 2008.02.07 20:34:00 -
[25]
.NET apps make Linux users cry...
I'll hijack a Windows computer and try it out.
Thar be Pirates
You are not authorised to hack into CONCORD's mainframe Your Wallet has been emptied!
CONCORD Encryption Methods |
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.02.07 21:06:00 -
[26]
Originally by: Valeo Galaem .NET apps make Linux users cry...
Theoretically, it should be possible to port this application to Mono (and thus be cross-platform). I'm not sure how far along the Mono project is with implementing .NET 2.0, so I'd have to do some research. My application does not use P/Invoke at all, so the only sticking point for mono compatibility would be the System.Data.SQLite assembly, which contains native win32 code. I'll have to check whether a compatible SQLite interface is available for Mono.
If you're interested, I can coordinate a little testing with you to see if we can get this bad boy running on Linux.
|
Ssoraszh Tzarszh
Minmatar The Royal Engineers
|
Posted - 2008.02.08 14:11:00 -
[27]
A very nice tool, easy way to find some assets out of game and plan some way of off-loading them ;-)
I have found a glitch i think, the tool marks BPC's with the BPO price making the grand total of your isk value a bit on the high side. For example a few Battleship BPC's worth no more than 2 mil are rated around the 1 bil mark ;-)
To be honest i dont know if it is even possible to differentiate between a copy or an original via the api?
PS: the bad thing this tool does is that it made me realise i have soo mutch is stuck in hostile stations that it almost made me cry :P
|
Xaroth Brook
Minmatar BIG Ka-Tet
|
Posted - 2008.02.08 14:38:00 -
[28]
Originally by: Goncyn
Originally by: Valeo Galaem .NET apps make Linux users cry...
Theoretically, it should be possible to port this application to Mono (and thus be cross-platform). I'm not sure how far along the Mono project is with implementing .NET 2.0, so I'd have to do some research. My application does not use P/Invoke at all, so the only sticking point for mono compatibility would be the System.Data.SQLite assembly, which contains native win32 code. I'll have to check whether a compatible SQLite interface is available for Mono.
If you're interested, I can coordinate a little testing with you to see if we can get this bad boy running on Linux.
MONO has SQLite stuffs as well, so that shouldn't be a biggy tbh.
your main issue would be the crap with System.Windows.Forms and alike, as the last time i worked with MONO it was a pile of fedoes(by lack of being able to name that more accurately due to censorfilter)... so unless they improved that by a ton it'll be your main issue.
It was like a baby, it landed on my lap and was helpless and totally defenseless. Then I shot it and bragged about it on a killboard.
|
Bambi
Existentialist Collective
|
Posted - 2008.02.08 14:52:00 -
[29]
1.4.x was cool so I hope 1.5 has lots of new goodies.
I found my long lost ammo BPO's thanks to this app, all hidden away in a shuttles hold. I presumed I lost these about 2 years ago!!
|
Goncyn
Nomadic Wayfarer Syndicate Te-Ka
|
Posted - 2008.02.08 15:13:00 -
[30]
Originally by: Ssoraszh Tzarszh I have found a glitch i think, the tool marks BPC's with the BPO price making the grand total of your isk value a bit on the high side. For example a few Battleship BPC's worth no more than 2 mil are rated around the 1 bil mark ;-)
To be honest i dont know if it is even possible to differentiate between a copy or an original via the api?
Unfortunately, no, it is not possible to differentiate between copies and originals via the API. I recommend you exclude the Blueprints category when running baseprice reports if you are looking for a reasonable "ballpark" estimation of your total worth. You could, for example, just add a single "And Category Not Equals 'Blueprint'" field, then use the "Save Query" button to save this as "No Blueprints." Then choose the "Use a saved query: 'No Blueprints'" option when generating these reports.
I know that's not ideal, but it's the best we can do with what the API gives us at the moment.
|
|
|
|
|
Pages: [1] 2 3 4 :: one page |
First page | Previous page | Next page | Last page |