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.
 

What tools are you using to make your spreadsheets?

First post
Author
Previous Topic Next Topic
Kitah Ferranti
Tulip Factory
#1 - 2015-11-03 02:40:15 UTC  |  Edited by: Kitah Ferranti
Hey all,

I was wondering what tools everyone is using to pull & interpret data?

I'm thinking about doing Google Sheets + Apps script using the eve-central xml.

I'm also considering Excel+VBA but I haven't used VBA before so not sure how annoying it is to use. PowerQuery isn't a great option - I'm on a Mac and it's not avail.

I'd really like a python solution but not sure what the best way of implementing it would be.

Thoughts?
Aoife Fraoch
The Scope
Gallente Federation
#2 - 2015-11-03 02:54:55 UTC
I have used R with appropriate packages for pulling data out of the API. I use Rstudio at home as my IDE.
Hel O'Ween
Men On A Mission
#3 - 2015-11-03 18:08:51 UTC
Kitah Ferranti wrote:

I'm also considering Excel+VBA but I haven't used VBA before so not sure how annoying it is to use.


Have a look at my Excel sample and judge for yourself if you find it annoying. Keep in mind, though that I'm terribel at Excel so the Excel sheet itself is subpar ... it simply shows how to handle XML in Excel via VBA rather then Excel's builtin functions (for which I don't even know the names ...).

EVEWalletAware - an offline wallet manager.
Bumblefck
Kerensky Initiatives
#4 - 2015-11-03 18:27:12 UTC
Pen and paper, can't be beaten

Perfection is a dish best served like wasabi .

Bumble's Space Log
Fannie Anathema
Anathema Holdings LTD.
#5 - 2015-11-04 13:48:40 UTC
I use Postgres exclusively... I also have EvE to thank for making me pass my exam about databases, so I wouldn't say that you need previous knowledge, just need a brain and the will to learn.
Songwhistle
School of Applied Knowledge
Caldari State
#6 - 2015-11-08 01:50:34 UTC
http://i.imgur.com/9iXfsDW.png

I made that using xml imports from eve central and eve market data. It's pretty nifty and can handle everything I've thrown at it so far. Let me know if you have any questions.
TheSmokingHertog
Julia's Interstellar Trade Emperium
#7 - 2015-11-08 19:43:37 UTC
The following stuff I do in Excel;

- Tracking stock levels
- Tracking market orders
- Tracking velocity of certain markets

On google docs;

- Tracking "Corperation Wallets" with a bigbook for each wallet
- Tracking fleet participation
- Tracking doctrine skill levels by fleet members

On MSaccess

- Order management for several trade hubs.

"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 =-
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2015-11-09 13:33:27 UTC
http://xlwings.org/ may be of interest to people who know python, and want to use excel.

or https://github.com/ericremoreynolds/excelpython

Anyhoo: If I need to do stuff, I tend to use a database, and, at most, use a spreadsheet as a frontend on it. For display. Or use the web, as tabular display is simple.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Hel O'Ween
Men On A Mission
#9 - 2015-11-09 18:01:47 UTC
Now that you meantion it, there's an Addin for Excel available from Micrsoft, called Power Query, that might help with trade analysis.

Never used it myself, though ...

EVEWalletAware - an offline wallet manager.
macpen
Pator Tech School
Minmatar Republic
#10 - 2015-11-12 10:02:11 UTC
Hi there,

I need pure EXCEL and VBA in the frontend.

For get the data in I use the EVE API using the quicklook function.
All my calculations are based on my own defined formula.

I am trying CREST at the moment, but I cannot find the data like the quicklook from the API and I personally not interested in an average price per item per region. So I get in the JSON data, form them into cells and rows and thats it.

I also have used ACCESS in the past.
But I have switched back to EXCEL for no good reason.
I like the quick and dirty possibilities of EXCEL somehow.

That does not mean I have no knowledge in databases but the amount of data and the purposes for which I use EXCEL (production/invention calculation and selling stocks) are not necessarily need the power of a database. In combination to see with my own lazyness of not like to develop shiny list displays in ACCESS.

Cheers
Mac