EVE-Online RP Discussion and Resources > EVE Guides, Mechanics & Gameplay

Who plays with the API?

<< < (2/3) > >>

John Revenent:
This is Kor in college, I am sorry world.

orange:

--- Quote from: John Revenent on 05 Dec 2013, 03:11 ---Forreal doe, I have no idea what is going on.

--- End quote ---

Just tangential discussions of spreadsheet craziness.

For example, Wyke Mossari built this awesome PI spreadsheet.  The "important bit" for most people is on the initial tab column K, M, and N.  However, the "open" spreadsheets reference the locked spreadsheets, which is where the "magic happens" and the x-path calls are generated and called from eve-central.

purple:
I noticed that the 'stock station' feature on EMD actually gives you sales data on each item for that stations region.   This would be REALLY AMAZING to have in a spreadsheet.   We could do actual market reseach and analysis on every freakin' region. If we had it, but they only offer The Forge's data in API...

However, it occurs to me that xpath allows us to pull data from a website,  shouldn't it be possible then to build a call that strips the daily value form say...

http://eve-marketdata.com/stock_station.php?step=Recommend2&solarsystem_name=Motsu&only_profitable=1

 ???

purple:
Some fellow over at failheap made this thing

https://docs.google.com/spreadsheet/ccc?key=0ApSkt6CQOux_dHk2TXNKWmJDakZTTGNCLXFCMHoxdVE&usp=drive_web#gid=32

Neat looking but reverse engineering it requires more work than I'm willing to invest atm.

purple:
Victory!

I discovered that the item price history API from EMD does in fact give an items daily sales volume for each region.   In addition to volume it also lists price high, low and average for said item in said region.   

To show why this is awesome a made a spreadsheet that vaguely predicts price trends for tritanium in the providence region.  Blue over orange combined with positive histogram means price is probably going up.   Maybe.   :bear:

https://docs.google.com/spreadsheet/ccc?key=0ApSkt6CQOux_dHNEd2ZiYUliQzZ2MVVLUkMzeFpYb1E&usp=sharing

Edit:  Wheeee math  http://www.youtube.com/watch?v=J4iODLa9hYw

Navigation

[0] Message Index

[#] Next page

[*] Previous page