These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

I need help with market data in excel.

First post
Author
Previous Topic Next Topic
Jericho Kandahar
Unicorn Fatale
#1 - 2017-01-22 10:57:57 UTC
I think I have managed to import market data into excel correctly for a specific region/system.
However because I have no experience with excel or databases or programming I am struggling to wrap my head around how to sort it all and pull only the data that I want to see in a clean readable fashion.

Everytime I try something new I get different errors or the data comes out incomprehensible.

I have managed what I am chasing on a small scale in Google sheets, however the project I am working on requires data on all item types and sheets just keeps bogging down with that volume, as well as giving me errors for making too many requests per day.

If someone could point me in the direction of some useful resources, or if someone thinks they could assist me with the project it would be greatly appreciated.

Regards,
Jericho
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2017-01-22 17:44:48 UTC  |  Edited by: Steve Ronuken
https://market.fuzzwork.co.uk/api/ may be of some interest.

Other options include using python to get the market data and push it into the excel sheet.
https://www.xlwings.org/
https://www.youtube.com/watch?v=T4osYwR61Ak

I'd avoid vba, mostly because it's very bad at handling json.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jericho Kandahar
Unicorn Fatale
#3 - 2017-01-22 22:26:18 UTC
Steve, I thought I had searched through most of your stuff, failed to see your API.

if I use that API from your website and I leave out the type Id will it retrieve all? Or would I have to put in all types individually?
Blacksmoke16
Resilience.
#4 - 2017-01-22 22:54:23 UTC  |  Edited by: Blacksmoke16
And no, if you don't specify typeIDs it returns nothing.

Best way to do it would be like get a list of all typeIDs you want, then do a query from Steve's api in group of 900 or so. Would be better than doing each item 1 by 1.