Updated latest GitHub version again including roughly 3-4 days of log data in the auction database. I'm just going with a basic console UI for now. May use Tkinter and make a proper GUI eventually.
Still looking for help if anyone wants to work on developing this.
One of the things I really wanted to do with this program was be able to do live analysis of EC auctions. This latest release is the start of a framework for that analysis.
Here is an example output from just now. Auctions are compared against a list of alert conditions in addition to being logged in the database. If they match an alert condition they are shown in the console output.
Output below shows examples of two alert conditions. One is that the price is below the 30 day average. The other is that the seller has lowered the price of the item compared to their previous auctions.
The (I1.0 M5.0) portion of an alert is the item's buy volume and the average item buy volume. Buy volume is the number of times that item was seen in "WTB" auctions.
For example:
(I5.0 M5.0) Lavendyr : blood point @ 2000 : below 30 day avg: 2271.0
This means the item blood point was seen in "WTB" for 5 unique people over the last 30 days of data. The average for all items seen in "WTB" is 5 unique people. Since most items are never seen in WTB this indicates that the item should sell pretty easily since it meets the average of all WTB items. The item is also below the 30 day average of 2271 meaning this is very likely a good purchase if you want a blood point or possibly to resell.
Quote:
X:\GitRepos\P99Auctions>auctions.py --active-only
[P99Auctions]
[Reading Config]
[Finding Logs]
Found 18 potential log files.
[Identifying Active Log]
Sleeping 3 seconds to allow logging...
No log found...
Sleeping 3 seconds to allow logging...
eqlog_Oppositemule_project1999.txt is active.
(I1.0 M5.0) Found : ebon mace @ 6000 : below 30 day avg: 6818.0
(I3.0 M5.0) Oobleck : sarnak emblazened tabard @ 50 : below 30 day avg: 77.0
(I1.0 M5.0) Trisol : bone legplates @ 30 : below 30 day avg: 35.0
(I5.0 M5.0) Lavendyr : blood point @ 2000 : below 30 day avg: 2271.0
(INone M5.0) Nadelaw : charred guardian breastplate @ 250 : below 30 day avg: 317.0
(I2.0 M5.0) Downstairs : dusty breastplate @ 200 : below 30 day avg: 288.0
(I3.0 M5.0) Oobleck : sarnak emblazened tabard @ 50 : below 30 day avg: 77.0
(I2.0 M5.0) Downstairs : dusty breastplate @ 200 : below 30 day avg: 288.0
(I1.0 M5.0) Sonnyboy : shield of the slain unicorn @ 15 : below 30 day avg: 26.0
(I1.0 M5.0) Sonnyboy : shield of the slain unicorn @ 15 : price descending: 20
(I1.0 M5.0) Sunil : ebon mace @ 6000 : below 30 day avg: 6731.0
(I1.0 M5.0) Sunil : ebon mace @ 6000 : price descending: 6500
(I2.0 M5.0) Florel : lute of the gypsy princess @ 70 : price descending: 75
(I3.0 M5.0) Viceruhl : kobold hide boots @ 50 : below 30 day avg: 65.0
|