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.
 

Google Sheet and eve central prices

First post
Author
Previous Topic Next Topic
Rock Onzo
Galactic Deep Space Industries
Brave Collective
#1 - 2015-05-21 08:48:39 UTC
Hello

The corp that i am in have a ore buyback spreadsheet that uses the imported data from eve central as of today it isn't importing the data the link that i use is:

=ImportXML("http://api.eve-central.com/api/marketstat?typeid="&JOIN("&typeid=",E1)&"&usesystem=30000142","//sell/min")

were the E1 refers to the cell with the item id

can anyone help me get this sorted out

thanks
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-05-21 12:13:41 UTC
importxml has been flaky for quite a while.


https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs

may be of interest, for an alternate way to get prices. It's not a direct replacement, as it pulls /all/ the price data back (and breaks if you try only to pull one type's prices), but it would allow you to have, say, a tab with all the ore types you want to query, and another with all the price data. Which you can then use vlookup to query.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Rock Onzo
Galactic Deep Space Industries
Brave Collective
#3 - 2015-05-21 19:25:04 UTC
Thankyou

i am looking at that but being a complete noob when it comes to programming i have no idea how to put this in place
Zad Murrard
Frozen Dawn Inc
Frozen Dawn Alliance
#4 - 2015-05-22 16:09:47 UTC
Few things to help things work better.

1) Make sure the amount of importXML calls in your document is minimized, ie. if you are fetching many //sell/min, do them in one call instead of one call for each
2) ImportXML2, at least few different versions of this one are out there.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-05-22 17:21:42 UTC
Rock Onzo wrote:
Thankyou

i am looking at that but being a complete noob when it comes to programming i have no idea how to put this in place



https://youtu.be/wNIfpPOOo0M?t=10m6s

:)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Rock Onzo
Galactic Deep Space Industries
Brave Collective
#6 - 2015-06-05 20:12:42 UTC
thankyou so much for your help i have got it all sorted with your script and it has made it so much easier to get the prices and i now bring in jita, amarr, dodixie, hex and rens
Rock Onzo
Galactic Deep Space Industries
Brave Collective
#7 - 2015-06-19 19:40:14 UTC
just a quick question im using your script and its great but i want to have a different tab for each trade hub is this possible and if so how
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2015-06-20 18:19:29 UTC
just create a new tab, and put in the regionid as a second parameter to the function? (or systemid, if you're using the loadsystemprices one. They just default to the forge and jita)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Barrak
The Painted Ones
#9 - 2015-06-22 19:41:11 UTC
I've run into a similar problem today.

Been slowly building up my spread sheet and making a nice little profit from it. But after two days away it will not pull any data at all...

I noticed that EvE-Central was incredibly slow today and not sure if the two are linked (I pull from EC)

I'm just looking at the script that Steve posted and the video link. But at the moment all I'm getting is a "need typeids" but I've no idea where to put them. The video starts about half way through. Was that the intended time to watch from?

Seeing as I put a lot of effort into my other spread sheet is it likely to work again?

I'm currently learning Python but it is very slow going.
Devilen
Shadovar Inc.
#10 - 2015-06-23 01:14:53 UTC
Yeah looks like Eve-Central's servers has to much traffic and they gave out. Looks like they are still loading data into the Database I would say give them 24 hours and it should be back to normal.
Barrak
The Painted Ones
#11 - 2015-06-23 14:08:17 UTC
thanks. Just checking now and again and it still seems down.

Kind of extra motivation to push harder through my python training.

If I built a table with Python would i still pull through EC?

(I am at the very (very) begining of my programing journey).
Kaladr
Viziam
Amarr Empire
#12 - 2015-06-23 15:23:36 UTC
Everything was fine, and then tanked, and is now fine again (tm).

We're adding capacity the (old fashioned, non-elastic-cloud) way soon to help alleviate the load on the three+ year old database server pair.

Also, there are a few features in the pipeline for faster price updates on hot items. Stay tuned to this forum!

Creator of EVE-Central.com, the longest running EVE Market Aggregator
Devilen
Shadovar Inc.
#13 - 2015-06-23 21:48:52 UTC
Barrak wrote:
thanks. Just checking now and again and it still seems down.

Kind of extra motivation to push harder through my python training.

If I built a table with Python would i still pull through EC?

(I am at the very (very) begining of my programing journey).



Not really sure what you are trying to create Barrak. Also are you wanting to save it to your computer to look up again incase the site goes down again?