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.
 

Eve-central api with Google Spreadsheet

First post
Author
Previous Topic Next Topic
Sonic Fast
Greyhaven Logistical Merchants
#1 - 2014-12-03 07:03:50 UTC
Hello!

So I'm trying to import the selling and buying prices of minerals.

So I'm using this:

=ImportXML("http://api.eve-central.com/api/marketstat?typeid=34&typeid=35&typeid=36&typeid=37&typeid=38&typeid=39&typeid=40&usesystem=30002053";"//buy/avg")


But the thing is that the output is as following:
05.19
10.36
53.37.00
107.11.00
515.13.00
411.15.00
732.15.00


But just changing format will break it and make it completely different.

I want them to numbers so it says
5.19
10.36
53.37
107.11
515.13
411.15
732.15


Is there something i'm missing or do I have to start removing the last ".00" by myself?

Thank you!
Kaladr
Viziam
Amarr Empire
#2 - 2014-12-03 07:11:49 UTC
Are you in a locale which uses "." as a numeric delimiter? Google docs may be getting confused in this case.

Creator of EVE-Central.com, the longest running EVE Market Aggregator
Sonic Fast
Greyhaven Logistical Merchants
#3 - 2014-12-03 07:24:18 UTC
Good point.

Thank you that fixed it :)
That i never thought about that...
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-12-03 12:33:30 UTC
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs may also be of interest. importxml is somewhat flaky.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Natasha Donnan
Deep Core Mining Inc.
Caldari State
#5 - 2014-12-03 15:12:03 UTC
Steve Ronuken wrote:
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs may also be of interest. importxml is somewhat flaky.


Somewhat flaky is the understatement of the year :)

Creator of the W-Space KB Comparison

Soldarius
Dreddit
Test Alliance Please Ignore
#6 - 2014-12-03 18:38:52 UTC
I strongly support using Steve's script. It works much better. It's also customizable if you are so inclined, whereas the importXML function is not.

http://youtu.be/YVkUvmDQ3HY
AlertForce
The First Foundation
Legion of xXDEATHXx
#7 - 2014-12-25 22:14:07 UTC
Steve Ronuken wrote:
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs may also be of interest. importxml is somewhat flaky.



Not previously used scripts. How to install it?
quikfingrs
Salamander Researches And Industries
#8 - 2014-12-26 13:47:41 UTC
http://eve-prosper.blogspot.co.uk/2014/07/building-better-spreadsheets-crius.html?m=1


If you go here itl show you how to set up scripts in the back ground all you need to do is put in Steves script and read the small print at the top of the script page to get it to work.

These two guys rock tbh with out these two guys I wouldn't have understood exactly what the hell to do when crius happand lol