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.
 

How to pull your Buy Orders onto Google Spreadsheets
Author
Previous Topic Next Topic
Cody Rasr
Goat Watch Inc. Look at all them herds
#1 - 2014-03-04 01:58:45 UTC
Hi,

I am trying to figure out how to pull my buy orders onto a Spreadsheet. I want it to work just like when you pull Jita prices or whatever your looking up. I know how to pull data from eve-central but didn't know if there was a way to have it also pull my buy orders only and auto update the same way.
TheSmokingHertog
Julia's Interstellar Trade Emperium
#2 - 2014-03-04 10:36:26 UTC
I don't know about the API, but in the order overview export, all orders are marked with a 1/0 on the EVE_OA_ID and EVE ID combo, the EVE_OA_ID for buy orders is 0 and for saleorders its 1, the EVE_ID is reversed for both. Maybe that helps you.

"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 =-
Raano Thorson
Full Armor of God
#3 - 2014-03-04 11:08:24 UTC
Let me know if ya figure it out! For now I use https://www.eve-mogul.com and it does it for me to calculate profits, tracks buy/sell orders and all transactions.

Now, they work with a large group of clients vs just your own personal spreadsheet that only pulls your data but its somewhere to start.

It would be nice to be able to make personalized reports with the spreadsheet you are talking about. I'm an excel novice at best so I just leave it to the guys and gals at eve-mogul.

Good luck!
Rhivre
TarNec
Invisible Exchequer
#4 - 2014-03-04 12:29:43 UTC
http://wiki.eve-id.net/APIv2_Char_MarketOrders_XML is the call you are after

Bid is the output which determines buy or sell

Fluffy Bunny Pic!

Soldarius
Dreddit
Test Alliance Please Ignore
#5 - 2014-03-04 15:13:25 UTC
in your spreadsheet you need to use the importXML function to make the market API call listed above. That will get the info you need.

http://youtu.be/YVkUvmDQ3HY
Cody Rasr
Goat Watch Inc. Look at all them herds
#6 - 2014-03-05 03:10:16 UTC
Thanks for the replies I will post back when with the call I use