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 Docs XML Questions
Author
Previous Topic Next Topic
Sarah Aeskiras
Doomheim
#1 - 2014-01-23 15:52:24 UTC
I'm building my Google Docs spreadsheet for trading, I can't find any good definitive resources for using xml calls other than the various older posts I have come across about the subject.

Currently I know how to pull buy/sell prices and orders, such as:

=importXml("http://api.eve-central.com/api/marketstat?&hours=24"&J2&"&usesystem=30000142&minQ=1","//buy/volume")

I am right now specifically wondering if you can call transaction quantities like you see in the market table, not just total available buy orders.

Is there a website listing all the types of things you can call with xml and how it goes at the end? (Like just the "//buy/volume" or "//sell/max")

Thanks in advance!
Wafflehead
Garoun Investment Bank
Gallente Federation
#2 - 2014-01-23 16:46:08 UTC  |  Edited by: Wafflehead
Sarah Aeskiras wrote:
I'm building my Google Docs spreadsheet for trading, I can't find any good definitive resources for using xml calls other than the various older posts I have come across about the subject.

Currently I know how to pull buy/sell prices and orders, such as:

=importXml("http://api.eve-central.com/api/marketstat?&hours=24"&J2&"&usesystem=30000142&minQ=1","//buy/volume")

I am right now specifically wondering if you can call transaction quantities like you see in the market table, not just total available buy orders.

Is there a website listing all the types of things you can call with xml and how it goes at the end? (Like just the "//buy/volume" or "//sell/max")

Thanks in advance!


Firstly this belongs in EVE Technology Lab

Secondly there are TONS of posts regarding this
http://bit.ly/1cZqIvJ

The 'things' that can go on the end are 'things' that are present in the API. You may want to read up on XML Schema / Files (google this too)
Sarah Aeskiras
Doomheim
#3 - 2014-01-23 18:20:16 UTC
Wafflehead wrote:
Sarah Aeskiras wrote:
I'm building my Google Docs spreadsheet for trading, I can't find any good definitive resources for using xml calls other than the various older posts I have come across about the subject.

Currently I know how to pull buy/sell prices and orders, such as:

=importXml("http://api.eve-central.com/api/marketstat?&hours=24"&J2&"&usesystem=30000142&minQ=1","//buy/volume")

I am right now specifically wondering if you can call transaction quantities like you see in the market table, not just total available buy orders.

Is there a website listing all the types of things you can call with xml and how it goes at the end? (Like just the "//buy/volume" or "//sell/max")

Thanks in advance!


Firstly this belongs in EVE Technology Lab

Secondly there are TONS of posts regarding this
http://bit.ly/1cZqIvJ

The 'things' that can go on the end are 'things' that are present in the API. You may want to read up on XML Schema / Files (google this too)


Thanks.... I guess.....

I'm glad you got a chance to use the nifty little "Let me google this for you" link, but I have already googled that, and many variations of that, many times. So not really helpful.

I didn't know they were called XML Schema, so that was helpful!

Since I haven't ran across pulling transaction history in the posts I've looked at, I'm guessing you can't do that? Or Eve-Central doesn't have that information. If someone could just answer the bolded question, or help point me to where I can get that information from, it would be much appreciated!

Mods can move this if needed, didn't realize technology lab was were this belonged.
Wafflehead
Garoun Investment Bank
Gallente Federation
#4 - 2014-01-23 18:30:23 UTC
Sarah Aeskiras wrote:

Thanks.... I guess.....

I'm glad you got a chance to use the nifty little "Let me google this for you" link, but I have already googled that, and many variations of that, many times. So not really helpful.

I didn't know they were called XML Schema, so that was helpful!

Since I haven't ran across pulling transaction history in the posts I've looked at, I'm guessing you can't do that? Or Eve-Central doesn't have that information. If someone could just answer the bolded question, or help point me to where I can get that information from, it would be much appreciated!

Mods can move this if needed, didn't realize technology lab was were this belonged.


Using google within the first 5 links there is..
Trade volume from eve-marketdata into Google Docs ... 2 posts 1 Jan 2014
https://forums.eveonline.com/default.aspx?g=posts&m=4061965

http://eve-marketdata.com/developers/google_docs.php
http://eve-marketdata.com/developers/index.php

90% of the time there is no need to post a new thread. Search the forums http://eve-search.com/ or use google. Ensure that the question has not already been answered already.
TheSmokingHertog
Julia's Interstellar Trade Emperium
#5 - 2014-01-23 19:41:11 UTC
Wafflehead wrote:
Sarah Aeskiras wrote:

Thanks.... I guess.....

I'm glad you got a chance to use the nifty little "Let me google this for you" link, but I have already googled that, and many variations of that, many times. So not really helpful.

I didn't know they were called XML Schema, so that was helpful!

Since I haven't ran across pulling transaction history in the posts I've looked at, I'm guessing you can't do that? Or Eve-Central doesn't have that information. If someone could just answer the bolded question, or help point me to where I can get that information from, it would be much appreciated!

Mods can move this if needed, didn't realize technology lab was were this belonged.


Using google within the first 5 links there is..
Trade volume from eve-marketdata into Google Docs ... 2 posts 1 Jan 2014
https://forums.eveonline.com/default.aspx?g=posts&m=4061965

http://eve-marketdata.com/developers/google_docs.php
http://eve-marketdata.com/developers/index.php

90% of the time there is no need to post a new thread. Search the forums http://eve-search.com/ or use google. Ensure that the question has not already been answered already.


Do you know most people have a google bubble with a personalized search page? So, if your search has these results based on your search history, it doesn't mean that this person would have the same results.

But I think we still have to thank you for helping the author, even if he is in the wrong forum.

"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 =-
Wafflehead
Garoun Investment Bank
Gallente Federation
#6 - 2014-01-23 19:58:42 UTC
As far as I am aware the above only takes effect when you are logged in. The search results from not being logged in 'should' be the same for other people (unless you are running some sort of addon to improve searches).
Oiras Isimazu
State War Academy
Caldari State
#7 - 2014-01-23 21:24:42 UTC
I was mixing Edit with Google Sheets (from *.xls Excel spreadsheet) for Google Docs XML...

I might be able to make them load from Google Docs if saved in Google Drive.
Perhaps it would work if I tried to upload then in Google Docs.