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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

In need of an Excel spreadsheet that imports hub prices.

First post
Author
Previous Topic Next Topic
Knitram Relik
State War Academy
Caldari State
#1 - 2016-09-03 02:06:10 UTC
I've used Google Docs with an import from eve-central for a few years now and I hate it.

Anyone got an excel spread sheet that imports from the eve CREST?

I'm kinda looking for something that's plug and play. I'm ok with excel, but when I look at the stuff on fuzzworks, my eyes cross and I start to have a seizure.

"The problem with quotes on the internet is that it's really hard to verify their authenticity." - Abraham Lincoln
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2016-09-03 14:48:05 UTC
have you looked at the api page on market.fuzzwork.co.uk ?

It's not quite live data, but it is fully updated every 30 minutes.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Knitram Relik
State War Academy
Caldari State
#3 - 2016-09-03 21:46:18 UTC
Is there a simple way to pull info I need into an excel sheet from this?

"The problem with quotes on the internet is that it's really hard to verify their authenticity." - Abraham Lincoln
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2016-09-04 17:43:09 UTC
Knitram Relik wrote:
Is there a simple way to pull info I need into an excel sheet from this?



If you're using 2013 or 2016, yes :D just follow the power query instructions.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Knitram Relik
State War Academy
Caldari State
#5 - 2016-09-04 21:11:03 UTC  |  Edited by: Knitram Relik
I have harnessed the power. Thank you so much.

You've got my vote for CSM in perpetuity.

"The problem with quotes on the internet is that it's really hard to verify their authenticity." - Abraham Lincoln
Navin'del Tesla
Midnight Conclave
#6 - 2016-09-05 10:54:54 UTC
For future reference, I have created an excel sheet with Forge, can be adjusted for other regions by changing JitaQuery. Works with Excel 2016 and probably 2013 if you install PowerQuery.

https://dl.dropboxusercontent.com/u/28619097/crest%20import%20Jita.xlsx

http://s000.tinyupload.com/index.php?file_id=82801885319365331543 (in case dropbox link goes inactive)

o7