Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
A Little Girl
42
|
Posted - 2011.09.07 13:38:00 -
[1] - Quote
Hiya! Would some super special smart person please help me! I have figured out how to pick up market logs and export them regularly. I also know how to import each individual export file into Excel as a csv file.
While I can semi/automate the first part I do not know how to automatically import them into Excel. Perhaps using macros? I really don't know Excel things I'm afraid So I hope it makes sense what I would like to achieve. To have an Excel sheet which automatically pulls data from a market log export file.
Example would be very helpful! |
Kandreath
De Re Metallica Epsilon Shimmy Alliance
2
|
Posted - 2011.09.07 22:01:00 -
[2] - Quote
It could be that it's early in the morning and my second coffee hasn't kicked in yet , I'm a little confused about *which part* you need help with.
I'll describe what I do and perhaps that might help you.
I collect market logs to try and figure out trade opportunities. (Oh man I missed a sweet one last night, by the time i found it, someone else had picked it up).
Anyhooo I digress!
I use an autodumper to collect the market logs scraped from the cache. I found the information on how to do that here: http://www.eveonline.com/ingameboard.asp?a=topic&threadID=598006 (look for where the thread starts describing autdumping.) - By the way EMS is pretty good for finding the best by and sell items if you have a specific item in mind.
I then copy the contents of each file into one big mother csv file using a good old dos command "copy" like this: "copy ..\*.txt .\marketorders.csv"
I then use an application I wrote in C++ to get the best trades for every item I've collected.
I used CSV because I use Openoffice and importing is simply the standard text import that excel supports also.
Does any of this help you at all? |
A Little Girl
42
|
Posted - 2011.09.08 06:07:00 -
[3] - Quote
Hi! Yes that is exactly what I am trying to do! I already have autodumper working but I am stuck at the part where you bring the data together and then sort it in Excel.
So I can make the big .csv file like you no problem. Can you help with the sorting algorithm? I am not asking for your program - unless you want to share it which will make me a very happy bunny! - but just some help on how to do the sorting and then I can write my own program.
If you don't want to make the info public please email me? Thanksies!
|
Kandreath
De Re Metallica Epsilon Shimmy Alliance
2
|
Posted - 2011.09.08 10:55:00 -
[4] - Quote
The only reason I wouldn't like to share my trade finding tool is that it continues to surprise me with some unexpected bugs. It's not very resilient if you feed it junk. By putting the tool out there, I'd also assume responsibility for maintenance and bug fixing. - I simply don't have the time for that effort.
As for the algorithm I'm happy to share what I do. - It's no big deal.
- I read all the orders from the merged CSV file.
- Ignore any lines that didn't look like a valid order,
- As I read the orders I create two lists. One for the bids(buy), and one for the sell orders.
- Now I have the two lists I purge all the orders which have expired and which are in systems with security less than I want to go to (carebear alert!). - And yes, the orders exported by eve and autodumper do include recently expired orders.
- I then sort the two lists. - Bids are sorted highest to lowest price, sell orders sorted lowest to highest.
Sooo now finally I'm ready.
- I work my way through each item in the sell order list and find it in the buy order list. Because the lists are sorted, the first I land on in each list is the biggest difference (which is biggest profit for each item).
- I then simulate the sale between the two orders including updating sell/buy volumes in the lists.
- I put the simulated sale into a new list (sales).
- I stay on the sell order and work my way down buy order list until it volume is all gone.
- I walk through the market order lists finding items for sale, then finding those items in the buy list, simulating sales until I get to the end.
- Now I sort the sales list by profit (biggest to smallest) - and output that as a CSV.
The sale list has other items which will tell me about the quality of the trade. Thinks like capital required, percent profit and volume required to carry.
All done!
What I'd like to do is figure out how many jumps are between the trades but I don't have the motivation for A* coding at the moment.
Hopefully this helps you.
|
A Little Girl
42
|
Posted - 2011.09.08 11:09:00 -
[5] - Quote
Ahhh it sounds so simple now I thought I might have to play around with bubble sorts and stuff. It makes sense to split it into seperate lists and compare/index them that way *slaps forehead*
So great you helped! I will see what I can hobble together myself now, thanks muchly! |
Kandreath
De Re Metallica Epsilon Shimmy Alliance
2
|
Posted - 2011.09.08 21:41:00 -
[6] - Quote
A Little Girl wrote:Ahhh it sounds so simple now Yeah - There is a lot going on but the methods are all simple. The hardest bit was figuring out if an order had expired. (Not familiar with date / time functions).
A Little Girl wrote: I thought I might have to play around with bubble sorts and stuff.
bubble sort, ahhh yes. I'd never use bubble sort for anything serious. In fact, I'm soooo lazy these days I looked into the STL's for C++ and I use the list container and the sort method.
it's as simple as : orderlist.sort(comparepriceLowtoHigh);
You define your compare function for complex types and it does the hard thinking for you. To be honest: without the STL's I'd have lost the will to complete it. I can't be bothered these days making list methods from scratch.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |