open All Channels
seplocked Market Discussions
blankseplocked Spreadsheet/software for managing investments
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

minerelite
Posted - 2011.08.04 11:09:00 - [1]
 

Apologies if this has been asked before, internet is playing up and couldn't find anything.
I've recently spent a lot of time on the MD forum and have been slowly been increasing my investment portfolio (I've invested about 1 Billion ISK in the last week). I mostly keep my records in a notepad, which isn't always convenient and i would like to share my portfolio details with friends more easily. Are there any free spreadsheets or software i could get that would help me manage it all?
Thanks in advance folks.

Calypsa Aeurelieus
Posted - 2011.08.04 16:03:00 - [2]
 

Google Documents is a free and easy to use system for Spreadsheets, presentations, etc. Also lets you share with either individuals, no one, or with everyone who has a link.

Danico Buchald
Caldari
Posted - 2011.08.04 16:27:00 - [3]
 

Open Office Calc is a full-featured spreadsheet.

http://www.openoffice.org/

Devai Starchild
Caldari
Posted - 2011.08.04 16:29:00 - [4]
 

Of these two I would recommend Google Docs because you can pull XMI data much easier than with OOCalc.

minerelite
Posted - 2011.08.04 18:29:00 - [5]
 

My apologies, i must have not made myself fully clear, what i mean is are there any such spreadsheets that allow me to manage my investments (IE, ones that people have already made).
Thanks

Oh'Freddled Gruntbuggly
Posted - 2011.08.04 18:49:00 - [6]
 

Originally by: minerelite
Apologies if this has been asked before, internet is playing up and couldn't find anything.
I've recently spent a lot of time on the MD forum and have been slowly been increasing my investment portfolio (I've invested about 1 Billion ISK in the last week). I mostly keep my records in a notepad, which isn't always convenient and i would like to share my portfolio details with friends more easily. Are there any free spreadsheets or software i could get that would help me manage it all?
Thanks in advance folks.


If you are a competant Linux adminstrator I have a MySql/Java/Tomcat web application, with pre-formatted csv tables for download into your favourite spreadsheet, and including CCP imagedump. It is based on API keys and currently has the following features:

Paginated list of recent transactions
Item group view, with-drill down to individual item historical transaction lists.
Each group and item view contains a colour-coded financial display of the the following figures, just like you see on real trading floors

  • Spot price bid/ask/spread
    Previous closing price
    price change
    volume traded bid/ask today/previous day
    price volatility
    cashflow debit/credit
    PnL day/mtd, Value at risk (VaR)


Pre-formatted tables, built each day from an End-Of-Day crontab entry, include:

EOD (End of day per item) average bid/ask, hi/lo, volume, price movement %, pnl
-- End of day prices compatible with many types of financial analysis and graphing software

DayAvg
-- Average prices of each item for each day, including 5, 30, and 90 day moving averages.

Mineral Analytics
-- More in depth financial anylsis of this important trading line

I could adapt this to your requirements, and provide a WAR file and cron scripts under licence given the right incentive. If you would be interested in using the application without having to manage it, I could possibly provide you with a running instance so long as you accept the risks of API key sharing.




flakeys
The Great cornholio's
Paper Tiger Coalition
Posted - 2011.08.04 18:49:00 - [7]
 

Edited by: flakeys on 04/08/2011 18:50:28
If with investments you just mean basic investments in other people - wich i am getting the impression is the case - then i wonder what's wrong with notepad?

Rolling Eyes


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only