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.
 

Spreadsheet again! market queues into excel
Author
Previous Topic Next Topic
Jason McCoy
Deep Core Mining Inc.
Caldari State
#1 - 2012-08-12 21:05:08 UTC
OK I'm sure this question has been asked, sadly I have no clue how to search for it. I've been looking around and I'm just horrible.

I want to queue market prices in my spreadsheet that's it.

Region - The Forge
I a few materials, example ore minerals and moon goo.

I don't need exact code, just where to learn how to make this happen. Please point me into the right direction, I SEEK YOUR GUIDANCE oh GREAT ONES!
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2012-08-12 21:29:59 UTC
Jason McCoy
Deep Core Mining Inc.
Caldari State
#3 - 2012-08-12 21:44:06 UTC
Thank, ive been reading that page for a bit, and im still confused. Either way Im sure I can figure it out with lots of practice.

Is there a list somewhere with the type IDs and region IDs?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-08-12 22:03:09 UTC
http://www.fuzzwork.co.uk/resources/typeids.csv
http://www.fuzzwork.co.uk/resources/regionids.csv


(both also available in zip files. just change the extension)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2012-08-12 22:35:06 UTC
Now that I'm a trifle less busy:

Which spreadsheet package? It makes a fair difference on how you'd import stuff.

Googledocs, you want to search for importxml here. That should get you plenty of example.
Excel you put together an appropriate URL, and then use 'import from web'

Open office is a bit of a pain with XML. go look at the APIs for eve-marketdata and eve-marketeer. They provide alternate formats.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Jason McCoy
Deep Core Mining Inc.
Caldari State
#6 - 2012-08-12 22:50:12 UTC
Steve Ronuken wrote:
Now that I'm a trifle less busy:

Which spreadsheet package? It makes a fair difference on how you'd import stuff.

Googledocs, you want to search for importxml here. That should get you plenty of example.
Excel you put together an appropriate URL, and then use 'import from web'

Open office is a bit of a pain with XML. go look at the APIs for eve-marketdata and eve-marketeer. They provide alternate formats.

yeah im using excel and im building the proper URL. I just need to get that url correct and only use the information im looking for.

In excel 2007

click on a cell
data tab
from web - second from left to right
enter the url
import
and hit ok
then i start deleted columns that I dont care for.