Ghostfolio: Open-source wealth management software

https://ghostfol.io

by falkaer • 3 years ago

456 150 3 years ago

ghostfol.io

screamingninja• 3 years ago

Does anyone have experience with self-hosting this? Curious to learn what worked and what did not.

c0brac0bra• 3 years ago

I just tried and it came up fine. Onboarding is non-existent so that's unfortunate.

Edit: took me a while to find it, but the last similar too I tried was https://projectionlab.com/, and while paid, it's UX is way better.

counterpartyrsk• 3 years ago

I tried it a couple months ago and wasn't too impressed. Unless I missed the feature, I trade enough to need something that can plug in to my brokerage accounts. There is a trade import feature, but I'm not going to export/import transactions from multiple accounts daily.

madballster• 3 years ago

Have you found a better alternative for someone who trades a lot? I'd like to drill down into trade results per symbol and get ROI statistics and visualize past buy/sell points.

LilBytes• 3 years ago

Hug of death? Unable to load the site.

JSavageOne• 3 years ago

Site not loading for me

Ocha• 3 years ago

Same

faitswulff• 3 years ago

It accurately reflects my wealth management needs

wing-_-nuts2• 3 years ago

404 wealth not found?

throw0101a• 3 years ago

https://web.archive.org/web/20230823004121/https://ghostfol....

jasonjmcghee• 3 years ago

Seems to load very slowly. Maybe not serving statically from a CDN

quaintdev• 3 years ago

Repo: https://github.com/ghostfolio/ghostfolio

Trailer: https://www.youtube.com/watch?v=yY6ObSQVJZk

guideamigo_com• 3 years ago

Typescript tells me that it will start to break soon if it ever gets abandoned.

JavaScript packages are one of the fastest routing rotting set of dependencies.

8n4vidtmkvmk• 3 years ago

I wanted to dispute this but then I remembered that I wasted 2 hours yesterday because Yarn 3 PnP and Typescript weren't playing nice together.

zo1• 3 years ago

Not really a trailer. More like a marketing placeholder video with moving screenshots.

3abiton• 3 years ago

trailer

I'll wait for the teaser

czbond• 3 years ago

Thanks for posting - looks like something I've wanted to find for a while

otoburb• 3 years ago

The GitHub link is: https://github.com/ghostfolio/ghostfolio

The premium hosted edition of this service isn't inspiring confidence if their front page, presumably residing within the same cloud infrastructure, can't handle the HN hug of death.

Operational issues aside, I love seeing open source self-hosted breaking into retail wealth management. Right now, it seems everybody I speak to that isn't a professional or institutional investor defaults to a frankenstien combination of spreadsheets and/or web frontends exposed by banks and 'standard' wealth management sites like Wealthfront/Bettermint.

jollyjerry5• 3 years ago

Curious to hear what you're looking for from a wealth management product.

With banking / brokerage platforms like Alpaca, it's possible to create an open source roboadvisor, but I'm not sure who the market would be. Someone who is interested in algorithmic trading would go directly access the API's, and someone who wants a hands off experience could choose from existing products, or get bundled services from a big bank.

I'm squarely in the frankenstein of spreadsheets, but also made a mobile frontend in https://jch.app The people I've talked to who use spreadsheets do it because it's fun.

mushufasa4• 3 years ago

Yes I've done a lot of customer discovery interviews in this space, and what resonates is a quote: "People like spending their money, not spending time with it."

Outside of people who money manage for a living, most analysis tools seem to fit into a "low frequency, low pain" problem for individuals in the "retail" segment. UHNW have so many assets they need tailored help. And people with huge pain in debt don't have much time, or lack the wherewithal to manage spreadsheets or analysis apps.

buzer• 3 years ago

One thing that I would like to see is tax impact analysis though this is naturally very country-specific.

For example I would like to calculate the impact of wash sale or seeing the tax impact for selling from certain lot (in terms of short/long term taxes). And if you did these what would your tax impact look like if you sold things at expected mark growth rate (or certain value you set).

mr-karan• 3 years ago

Looks nice. The comparison with S&P500/similar Index funds is an important metric to track. I’d also built a tool https://monkeybeat.market/ which demonstrates a similar concept.

I’ve been exploring such projects off late myself. I found https://github.com/ananthakumaran/paisa to be a really clean and well implemented project on similar lines. It already handles a bunch of asset classes familiar to the country I’m residing in which is tempting me to give it a shot sometime soon!

jollyjerry5• 3 years ago

I like focusing on DIY-ers and having the web UI for visualizations. Makes sense that someone who would take the time to set things up would want increased flexibility over a spreadsheet.

xur173• 3 years ago

Very neat, excited to take a look, and especially excited that it is self hostable / open source. I've tried a number of services like this, and always end up back on a spreadsheet because:

1. I hate giving my data to a third party

2. There always ends up being some limitation that forces me to exclude part of my assets, doesn't let me handle something the way I wish, etc

matthewtse2• 3 years ago

Yes same! I've always wanted some "simpler" net worth tracker, still on a spreadsheet at this point.

I never liked the big heavy ones with all the bells/whistle integrations that want your password so they can log directly into your financial accounts. And the integration would always break, causing my net worth to swing by double digit percentage points. I ended up spending more time nursing the integration than actually watching my net worth.

jollyjerry5• 3 years ago

I expanded my spreadsheet into a webapp https://jch.app. My original thinking was to avoid broken bank syncing, but one problem I still have is how to include assets that aren't publicly listed. For example, have funds in a retirement account that's specific to that institution and can't fetch updated prices. Currently getting around that by using a similar target date fund as a proxy for the price.

reidjs• 3 years ago

Have you dabbled with plain text accounting systems at all? They seem like the next step after spreadsheets because ease of version control and pipelines to/from.

vba6165• 3 years ago

1. Excel. 2. KeePass. 3. Selenium. 4. VBA.

yieldcrv• 3 years ago

Yeah I also want an offline portfolio tracker

Offline taxes

guess there’s not enough money in that

Aulig2• 3 years ago

You could check out portfolio performance for an offline, open source portfolio tracker.

reedf1• 3 years ago

What is the market data source (is there one?)

FrustratedMonky4• 3 years ago

Isn't "wealth" a misnomer.

Do people with real wealth really use open source tools?

Or do they have meetings with their accountants, bankers, brokers.

This is really "wanna be wealthy" tools.

xur173• 3 years ago

What do you define as wealthy? If you read bogleheads / fire blogs, there are plenty of people I would define as wealthy that self manage their assets. A lot of them use spreadsheets, some use free / cheap software online.

toolz2• 3 years ago

Everyone in my family with a net worth over 5MM self-manages their assets. Many financial advisors/managers are percentage based commission which ends up being about as close to a scam as you can get without it being unethical. (very much just my own opinion here)

I don't trust industries that use ignorance to line their pockets, which is why I manage my own wealth.

westonplatter0• 3 years ago

nah. Most of wealthy people I've interacted with have refined/specialized workflows that are something similar to 5 excel spreadsheets.

Build a tool that allows people to organize their 5 spreadsheet and you win.

xur173• 3 years ago

I've tried a number of tools that promise to "automatically" pull all of my transactions and assets in and create a dashboard for me, but I always end up back with a group of spreadsheets. My current setup is:

1. Overview spreadsheet that shows my current net worth (fed from my other spreadsheets), a monthly snapshot of spending, income, and assets, and number of months until FIRE based on my trailing 12 month spend and income.

2. Spreadsheet tracking stocks I own + their current value

3. Spreadsheet tracking my crypto transactions (that I run a script against to get the cost basis and current value to plug into spreasheet 1)

4. Lunchmoney.app - website that I use to track and categorize spend. This data fees into my overview spreadsheet.

Topgamer7• 3 years ago

You probably have a house, a car, a 401k, expensive phone, computer(s). At least a good portion of the HN demographic probably fits this description.

So you're more wealthy then the person working 2 jobs, living with 3 roommates, commuting by public transit.

Wealth is just your possessions with value.

This is just being "pedantic about social class".

FrustratedMonky4• 3 years ago

Technically you are correct.

The term "Wealth" is just a word for money.

Pedantically, any money can be termed "Wealth".

So if I have an extra $5 dollars, I can manage that "Wealth", and I should not get hung up on a term that the ignorant masses associate with a "Social Class".

There are no social hierarchies, we are all wealthy on a sliding scale, from 5$ to $5MIL to $50BIL.

matthewtse2• 3 years ago

Would argue a surprising number of millionaires+ don't have any bankers/brokers, as the fees are usually % based and they really add up.

breakds• 3 years ago

There are quite some wealthy people who happens to understand technology well and use and contribute to many open source tools.

mrpotato• 3 years ago

Wealth is an industry term. It doesn't imply that one should be wealthy (rich) to use this tool. Wealth management is a tool for planning your own personal wealth for the future.

For example, you add all your accounts/investments and have the software calculate how much you need to save so that by age 65 (retirement) you have $X which you will need so that by the time you reach life expectancy (say 90 y/o) you have > 0$ left.

There is other stuff you can add in, like "I would like Y$ saved by 20XX so that I can purchase a house. How will that affect the amount I need to save now and how much will that affect my savings at retirement."

Or do they have meetings with their accountants, bankers, brokers.

It is probably a good idea to have a financial advisor do this for you since they have the know-how (and certification depending where you live) and will know about regional benefits you can apply which can increase your "wealth". However, if you want to do this yourself because you know the space then there is software like this, or Wealth Simple for example.

FrustratedMonky4• 3 years ago

K. You're right, you can classify the term "Wealth" as any free capital.

So if I have an extra $5 I can manage that "Wealth".

tristor• 3 years ago

Most of the wealthiest people in the world actually manage their own wealth as their primary occupation (which can take many facets). There are places to hire professionals to assist, but until you are in the tens of millions or more in net worth it's usually a better deal to self-manage because professionals expect a percentage of assets under management as a fee. Once you have a high enough net worth you operate a family office / self-organized finance company and hire people directly.

You don't get wealthy by giving someone else 1% of AUM for performing on-par with a passive investment in index funds you could self-manage. So, sure, this is "wanna be wealthy", but what even is "wealthy"? I have a plan using spreadsheets and other tools that is on track to take me into low-mid double digit millions prior to retirement, I can't imagine giving someone 1%, which can be six-figures or more, every year for clicking some buttons. At some point managing my own wealth is worth more investment of my time than any other occupation.

mushufasa4• 3 years ago

You don't get wealthy by giving someone else 1% of AUM for performing on-par with a passive investment in index funds you could self-manage.

This is how advisors are typically paid, but this isn't all that they do. Empirically, as people make more money, they turn more to advisors and away from self-directed or robo apps.

Lots of people have opined on why, if you follow the trade publications for advisors. To me, the reasoning comes down to risk: if you have a lot at stake then you will pay money for a lawyer to review for $$$$ per hour. If you have a lot of money you will pay 1% if you can feel more comfortable that the advisor is handling all the aspects of it and you can sleep better at night.

halotrope2• 3 years ago

Ghostfolio is awesome! Sorry for the plug, we are doing something similar with markets.sh

it's not open-source (yet) but we're giving you all the data of connected portfolios and bank accounts via api and it's free if you just want the data. Also we are investing a lot of time in asset matching and market data (even options are supported), something all the other tools we've tried fell short of (especially global stocks and multi currency accounts).

xcdzvyn2• 3 years ago

I much much prefer markets.sh' UI to Ghostfolio's, honestly. I'd even call it particularly good. Looks like Tailwind, right?

When you say "(yet)", are you referring just to the API code or everything? Because I'd love to use this if I could host it myself.

halotrope2• 3 years ago

Thank you so much! Yeah, right now we keep the API as open as possible, we’re big fans of oss but it’s gonna take a while as the system runs on many databases and systems. Apart from the simple portfolio tracking, we are ingesting live data from global stocks, thousands of news per day and do clustering and machine learning and all kinds of fancy things on it.

I’d love to open source the dashboard first as it is probably useful to self-host and just feed with your own data. Let me know if you have any questions.

wing-_-nuts2• 3 years ago

Call me old fashioned but I just add everything under 'other accounts' on vanguard, and call it a day. It's close enough for my taste. I imagine other brokerages offer this feature too and vanguard has pretty much the worst reputation for ux out there.

systemvoltage• 3 years ago

Yeah, Schwab can track other accounts from Fidelity, Vanguard, etc.

I’m probably a minority but I don’t micromanage my wealth. General account level information is good enough. I also do not trust wealth managers, usually their advice is terrible. Schwab automatically assigns a person on your account after a certain wealth threshold. They call me occasionally to make sure I’m aware of the risks which of course I am.

mritchie712• 3 years ago

Their advice isn't necessarily terrible, it's just strongly biased towards them making a buck off you.

ra7• 3 years ago

How does this compare to Beancount + Fava?

mcshicks• 3 years ago

I very much wondered the same thing. I've had a couple of occasions where I really wanted a numerical answer to some finance questions, like for instance keeping an IRA vs paying taxes and converting to Roth. And I want it to take into account my tax burden, how much cash I have available, etc. The simplest way for me to do it was python scripts and Beancount + Fava. I don't even try and use it for keeping track of my finances, I use quicken for the simple reason that I know my spouse can use it as well. I didn't see "tax planning" on the features for Ghostfolio, this seems so very basic to me that I couldn't consider using it. I understand why in a way, there are so many situations. Of course if I only have to model my particular situation it's much simpler to just write a simple model in python.

FrameworkFred• 3 years ago

Neat idea, but I don't see a great way to handle real estate, unless it's shoe-horned awkwardly into wealth items. For me, that's a gotta-have.

rsstack• 3 years ago

saying no to spreadsheets in 2023

Normalize spreadsheets as evergreen technology. Say no to weeb3 in 2023.

andix2• 3 years ago

I am using Portfolio Performance for a while now. Need to check how it compares.

PP is easier to set up though, it's a plain old Java desktop application.

https://www.portfolio-performance.info/en/

Edit: it works well for crypto too, you can track anything that has a count and a price.

Aulig2• 3 years ago

I use that too. Ghostfolio looks a lot more beautiful but probably is more limited in terms of features :)

matanrubin3• 3 years ago

I found Portfolio Performance to be non-intuitive and very hard to use

andix2• 3 years ago

That's true. UX is not the best. But it has a lot of features and works reasonably well once you got used to it.

ak39• 3 years ago

Does it handle stock splits, consolidations, dividends etc? Calculating returns (basically tracking growth) is a non-trivial problem.

berkes7• 3 years ago

Yes, somewhat. Not as proper as it should. But it does the job. Esp with such events as splits, mergers, renames you can see it's not a very professional setup. I've had to hack around it by adding and then nulling some assets like "emission claims". Or, in my country, dividend-tax is extracted immediately so I now hack around that by adding that tax as "fee" to ghostfolio. It works. But isn't a replacement for actual book- and portfolio-keeping.

matanrubin3• 3 years ago

How did you handle stock splits?

darau12• 3 years ago

Anybody care to define "wealth management" as opposed to run-of-the-mill personal accounting? Why would I use this instead of ledger[1], for example?

- [1]: https://ledger-cli.org/doc/ledger3.html

tr3ntg• 3 years ago

If you're using a tool like ledger, I don't think there's much ghostfolio could say to convert you. Seems like comparing apples to oranges. I'm not familiar with ledger, but at a glance, seems like it's made for a different audience with different needs.

berkes7• 3 years ago

In fact, I'm working on something alike Ghostfolio but that uses ledger as database. It's very much early stage and mostly proof of concept and hacked together scripts. But I'm moving it to both "tabula" and "bullboard":

https://github.com/berkes/bullboard-rs https://github.com/berkes/tabula

Again: early. But tabula is my consolidation of random "beancount/ledger" stuff regarding running my small business and startup. And bullboard my consolidation of random "beancount/ledger" stuff regarding everything investment related. The latter is just a CLI tool for now, and barely works. But once the businesslogic is done, I plan to add a web-interface alike ghostfolio to it. A tad simpler, I think, though.

felipellrocha• 3 years ago

I would say ledger is more about knowing where your money is going, and ghostfolio is about making sure you minimize the risk of losing said money all at once after you hit a certain wealth threshold

olejorgenb2• 3 years ago

Can ledger track performance over time (which I assume Ghostfolio can). Does ledger (or the eco-system around) come with integration towards sources which categorize assets, and can it easily give a breakdown of the exposure according to such categorizations (per industry, per region, etc.)?

berkes7• 3 years ago

Yes, no.

Yes, Ledger can do all those things. No, it doesn't do this "out of the box".

I do most of these things. Simple, by adding meta-tags to my ledger. I'm just now working on consolidating on all my willy-nilly scripts and tools. And then plan to turn this into an actual "investment dashboard" ala ghostfolio but using the ledger as source.

In the end, a plain-text-ledger is just a of database. And the ledger query language (e.g. bean-query-language) a way to query it and produce reports.

So, what you are asking is more like "can SQLite categorize assets, give a breakdown of the exposure according to such cats per industry, region etc". Well, sure it can. But it's a bit of a strange question.

abdullahkhalids• 3 years ago

I don't know about ledger, but gnucash can track performance over time[1, 2]. I don't think Gnucash can do your second ask on its own.

[1] https://www.gnucash.org/docs/v5/C/gnucash-guide//chapter_inv...

[2] https://www.gnucash.org/docs/v5/C/gnucash-guide//rpt_standar...

multicast• 3 years ago

"Real" wealth management has a lot more legal work behind it since a non trivial portion of wealth management are topics like inheritance and planing for the next generation. Also wealth management is more focused on wealth preservation than generating high returns, that is more the focus of asset management (e.g. hedge funds, private equity etc.). But since this piece of software is focused on the individual the term seems applicable even though something like personal finance would be more suitable. For "real" wealth management you hire usually professionals. It has a lot of good and bad sides that a majority of people think that when it comes to finance they can compete on an equal level with experts who do this every day. But if your skilled you surely save a ton of fees.

mikeryan• 3 years ago

Also wealth management is more focused on wealth preservation than generating high returns, that is more the focus of asset management (e.g. hedge funds, private equity etc.).

This is a bit simplistic. It’s more focused on setting a target return and cash flows consistent with your current life plans. Whether this is a defensive or more aggressive position is really up to you and your goals. But Wealth managers are about putting an investment strategy in place to achieve that. They also help actively manage your portfolio to address macroeconomic trends.

vba6165• 3 years ago

"Real" wealth management has a lot more legal work behind it

This is just me, but if I had legal work and deep pockets, I'd hire a lawyer.

a majority of people think that when it comes to finance they can compete on an equal level with experts who do this every day
But if your skilled you surely save a ton of fees.

If you are "focused on wealth preservation" rather than "generating high returns", what is the need for skill?

If I won the lottery, and I just sent, say, a $500M check to a regular discount broker and bought an index fund, is someone going to take it away from me? Are the wealth management divisions of every podunk bank and credit union there for a reason? Would I need to hire "protection"?

Warren Buffett famously said he "upon his passing, has directed the trustee for his wife’s benefit to “put 10% of the cash in short-term government bonds and 90% in a very low-cost S&P 500 index fund.”

And Barack Obama reportedly put all his assets in government bonds when he became President to avoid conflicts of interest.

Obviously not everyone takes this sort of simple approach, but some famous examples seem to prove it's possible.

ochoseis• 3 years ago

Two things I’ve learned after 15 years of working starting during the GFC:

- It’s counterintuitive, but during your saving years you’re better off if the market’s doing poorly because everything’s on sale. If you’re retired you want the opposite.

- Frequently looking at your net worth is a big distraction. Just focus on the things you can control, like your savings rate and expenses.

asutekku• 3 years ago

It's a tool which 100% benefits from having a good UX, so not having a single screenshot on the frontpage is not a good sign. I don't count the linked YouTube video as one as it redirects me to YouTube.

marcopicentini• 3 years ago

What tool did you use to crete the promo video?

evergre2• 3 years ago

For anyone who needs a hosted/paid/slick alternative, there is https://kubera.com

Disclosure - I work at Kubera.

alexchamberlain• 3 years ago

Ghostfol.io have a hosted/paid option for 19 USD/year. Is Kubera worth the extra $100+?

evergre2• 3 years ago

Please take the 14-day and find out for yourself.

sgarman• 3 years ago

How successful has the [COMPETITOR] vs Kubera pages in footer technique been for y'all?

scubakid• 3 years ago

I'm flattered to see they have a page advertising it as an alternative to ProjectionLab (disclosure: I made that).

Though I haven't yet seen a part of this tool that makes projections. Did I miss that?

datavirtue• 3 years ago

Had trouble hitting back on the browser. Major peave.

Is this able to plot different Roth + 401k strategies to maximize tax advantages and returns? Also figuring in your small business activity and write-offs? Big picture.

I've been watching YouTube videos explaining various strategies and ways to bank yourself. Totally pissed me off that no one told me all of this before. My lack of knowledge has really hosed my finances bad and I was the person that would help coworkers figure all this stuff out. I found a lot of people just leaving their money in money market funds in their matched 401 and they were very apprehensive about doing anything. Even saw a trained broker do this.

People are leaving a lot of wealth on the table because they don't know the laws and how they can get rich moving their money around and they will not go to advisors for various reasons,again, mostly out of ignorance. I hear advisors often don't know these laws or fail to tell people.

I had no idea you could get a solo 401k and completely self-direct the investments (I.e put the money into your business or a friends). Searched Fidelity and was able to dig up the PDF forms.

I always thought it was evil to borrow from your 401k,and indeed every document you find on this throws up scary words and harsh language and intermixes the topic with withdrawals. Powerful source of funds that people avoid out of fear and ignorance.

I'm not concerned with watching balances but would like something that can present scenarios for various vehicles and suggest different courses of action.

I want to start a small business, what is the best way for me to fund that without risking to much or getting hosed on taxes...

iFire• 3 years ago

LICENSE

GNU Affero General Public License v3.0

https://github.com/ghostfolio/ghostfolio/blob/main/LICENSE

spaceribs• 3 years ago

Cool! an open source Angular app!

nomdep• 3 years ago

Fantastic! Now all what I need is to have wealth to manage

ghostpepper• 3 years ago

Maybe I'm just getting old but it always makes me skeptical when something is introduced as "Open Source" and then the main landing page includes a pricing tab.

basch• 3 years ago

Is there a lot of free cloud hosted open source software as a service that isnt ad supported?

mirzap• 3 years ago

What's wrong with paying for the software? You get the source code, they provide you the service if you don't want to handle it by your self.

xcdzvyn2• 3 years ago

I think GP means seeing a pricing section without any extra details suggests the open-source version is limited in some way, with certain features paywalled. That's how I see it.

andersrs• 3 years ago

People are cheapskates when it comes to OSS. OP put in thousands of commits and only has 18 supporters. They are not exactly a software baron are they?

On the other hand you have some onlyfans girls flashing their ass for 10 seconds getting thousands or even millions.

BLKNSLVR• 3 years ago

I was initially too, but upon reading said Pricing page was pleasantly surprised.

mcgeez• 3 years ago

Does this retrieve data from your accounts? If so, what does it use to do that? Plaid?

I love projects like these exists, but not being able to download the data automatically from my accounts was a dealbreaker for projects like GNUCash.

MezzoDelCammin• 3 years ago

And have You managed do somehow automatize it in the end?

k__• 3 years ago

lol,

Is it "a thing" that you post your stuff in Reddit, Dev.to, and a random "Awesome" repo on GitHub and then use that as "social proof"?

"Seems legit." - Some guy on Yelp

LoveMortuus• 3 years ago

Why did the site hijack the back button? I tried to return to HN but it just kept reloading into the ghostfol.io site...

wintermutestwin• 3 years ago

I am always baffled by people who actually use the back and forward buttons. I guess I just assume that everyone opens links by right-clicking and opening in a new tab. Is there some reason why back and forward is a better or even useful option?

hsbauauvhabzb• 3 years ago

Mobile devices, for one.

The amount of websites that don’t support control+click indicate to me that most people don’t use the method.

Edit: but regardless it’s not okay to hijack the back button.

optymizer• 3 years ago

You cannot possibly be serious. Who uses back buttons, on the web? Everybody.

cwalv• 3 years ago

I hit the same problem as gp, on mobile, tho I did open in a new tab (hold+open in new tab). The back button is usually a quick swipe from right to get me back to what I was reading.

FractalHQ• 3 years ago

Cmd+click! Right clicking to open a link in a new tab is uncivilized.

stevofolife• 3 years ago

Can someone not just make a wealth management spreadsheet in Excel? If anyone has a good one, can you share or sell to me?

nereus• 3 years ago

Is this the sort of thing you are after?

https://cspersonalfinance.io

redact207• 3 years ago

This is so good. I've tried so many homebaked spreadsheet trackers and semi-complete side project sites. This one looks like it strikes a good balance between feature completeness and simplicity

skeeter2020• 3 years ago

"saying no to spreadsheets in 2023"

I just don't get this sentiment. Nothing lets me model free-form questions as quickly, easily and effectively as opening up Excel. I get there are better tools for specialized or defined problems, but the spreadsheet is still my go-to general purpose tool.

tonfreed• 3 years ago

The first 6 years of my career was working on data heavy applications. The statisticians on staff all used Excel to prototype their models. It's a great tool

tmpX7dMeXU• 3 years ago

Petulant NIH syndrome.

dagw• 3 years ago

Agreed. I have a degree in statistics, years of experience working with data analysis, closer 15 years working with python, know R etc. etc. But if I just want to quickly play around with some numbers to get a quick feel for a problem I almost always still fire up Excel first.

jmprspret• 3 years ago

I never understand how these kinds of software do data importing. Do you have to manually import these things every time I do a trade or I get my paycheck or spend $2 at the corner shop? If so that seems annoying

esprehn• 3 years ago

There's bank data aggregators like Yodlee. If the app uses that it can auto import transactions. Ghostfolio seems to be oriented around manual import though (export csv from your bank and import yourself periodically).

gh02t• 3 years ago

I use Firefly III (which isn't quite the same but similar issue) and import csv exports from my bank and other accounts. I have to jump through some hoops with Selenium to automate downloading the csv files but it works mostly reliably after some fiddling.

bboygravity• 3 years ago

I just use a spreadsheet in Libre Calc that scrapes prices of securities (almost) live from public sources using an extension.

All I need to do is keep track of whatever I transfer to my broker and number of securities purchased for each type of security.

Works well enough for an investor. Does not work well enough for a gambler (day trader) :p

vekker• 3 years ago

Very nice! Awesome tech stack too; a welcome change from all the React/Next.js projects these days.

Ghostfolio: Open-source wealth management software

Related Stories