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

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

Market Discussions

 
  • Topic is locked indefinitely.
 

Google Doc Spreadsheet

First post
Author
Previous Topic Next Topic
Shepherd Ellipse
Iron Whales
Goonswarm Federation
#1 - 2014-11-14 08:25:41 UTC  |  Edited by: Shepherd Ellipse
So like everyone else asking this question/s.

I am making a spreadsheet to pull the prices of times from evecentral to my spreadsheet.

My issue I have is it doesn't want to pull all the items. I get a constantly "loading" cell or an NA cell because of things not loading.

this is the importxml I am using.

=IMPORTXML("http://api.eve-central.com/api/marketstat?typeid=22&regionlimit=10000002","//buy/max")

the above works on most items most of the time but not all which makes the whole sheet not work.

Does anyone know what my problem might be ? If you need any other information I can provide please let me know.

Is there a limit on how many times my IP can pull from eve central this way? If that might be a problem.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2014-11-14 12:16:45 UTC
Shepherd Ellipse
Iron Whales
Goonswarm Federation
#3 - 2014-11-15 01:57:44 UTC
I appreciate the reply but I am not sure I how to use if values.

I have 1 google doc. with 8 tabs.


Summary: This have pulls from the calculations tab to show in one neat place.

Ore: where you imput how much ore you want to sell to the corp

Ice: where you imput how much ice you want to sell to the corp

Minerals: same as above

Salvage same as above

PI same as above

Reference: is the page with the importxml lets use Arkonor: id 22 import from jita region
=IMPORTXML("http://api.eve-central.com/api/marketstat?typeid=22&regionlimit=10000002","//buy/max")

Calculations: all the math. Arkonor :......=(Ore!B2*Reference!C3)


Now it does not want to pull that item at all. I will use that same code for lets say Bistot
=IMPORTXML("http://api.eve-central.com/api/marketstat?typeid=1223&regionlimit=10000002","//buy/max")

and it works just fine.

I get a constant loading cell or NA
TheSmokingHertog
Julia's Interstellar Trade Emperium
#4 - 2014-11-15 15:53:32 UTC
Shepherd Ellipse wrote:
So like everyone else asking this question/s.

I am making a spreadsheet to pull the prices of times from evecentral to my spreadsheet.

My issue I have is it doesn't want to pull all the items. I get a constantly "loading" cell or an NA cell because of things not loading.

this is the importxml I am using.

=IMPORTXML("http://api.eve-central.com/api/marketstat?typeid=22&regionlimit=10000002","//buy/max")

the above works on most items most of the time but not all which makes the whole sheet not work.

Does anyone know what my problem might be ? If you need any other information I can provide please let me know.

Is there a limit on how many times my IP can pull from eve central this way? If that might be a problem.


I would always advise to use the "IfError" in this kind of cells, or in a buffer between the import and the calculations. IfError will not break your output if some of the underlying connection have (temporary) errors in them.

"Dogma is kind of like quantum physics, observing the dogma state will change it." ~ CCP Prism X

"Schrödinger's Missile. I dig it." ~ Makari Aeron

-= "Brain in a Box on Singularity" - April 2015 =-
Shepherd Ellipse
Iron Whales
Goonswarm Federation
#5 - 2014-11-15 19:12:57 UTC
Thank you I will look into that.