Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[orange]

So, I have spent a solid part of the weekend thus far playing with the Eve API and Google Docs Spreadsheets.  I have learned a few things along the way... like URL length is limited to 2048 characters!

This matters because Google Docs has a limit of 50 XML calls.  So, the total number of items I can price based on Eve-Central is limited by these two things and the need to make other calls (like for corporate assets from the API).

This weekend's sheets are focused on capturing corporation asset value and member market information (second sheet).  May even have a basic "market killboard" built for LDIS by the end of the weekend.

What have you built using the API?


Edit: for xpath calls, using parenthesis does what you think it would do.

For example:

Code: [Select]

//row[@duration>0 and (@stationid='1' or@stationid='2')]/@what I want

[purple]

A rather inelegant solution to google's 50 call limit is to create another spreadsheet and use importrange to import the whole first spreadsheet in, giving you another 49 calls to work with.   Very messy though.

[purple]

I'm not so savvy on xpath syntax is there supposed to be a space between or and @ for the second stationID?   Seems like you are doing something like a pivot table, but inside the call.  Neat.    I assume that's for api.eveonline.com/corp/marketorders.xml.aspx?  and it calls for specific corp orders that haven't expired at two specific stations?  Presumably Z-RE and 3KB?   I deduce from there that you intend to compare LDIS's sell order value to the total sell order value of those two stations as a way of showing how much of it's due to the work of your guys?     Lyn might have blown your efforts off, but I noticed Z-R is the 12th largest market in Provi.  Nice work.

Also, I'll show you mine if you show me yours.

[orange]

Well since we are targeting 4TH's stations, I actually call their IDs from the Outpost API and check for orders in all of them.

I have not yet started to worry about how much of 3KB's sales volume is us.   I know Z-R is not LDIS.

The @ on the second station was needed to make it work for me.

[Korsavius]

Forreal doe, I have no idea what is going on.

[John Revenent]

This is Kor in college, I am sorry world.

[orange]

Forreal doe, I have no idea what is going on.

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.   

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

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

[Demion Samenel]

Shiny indeed 

Nice mr.Purple 

[purple]

Shiny indeed 

Nice mr.Purple 

Thanks Demion!

Also, found this guide.
https://www.fuzzwork.co.uk/2013/06/22/importing-price-data-into-spreadsheets/

[orange]

The volume as dates is bothering me.  It also makes it hard to tell how much of the volume was me a few days ago.   

[purple]

The volume as dates is bothering me.  It also makes it hard to tell how much of the volume was me a few days ago.   

Fixed