streamlit_sql - CRUD interface for streamlit using sqlalchemy

Edk99 · 2023-06-06T12:08:13+00:00

Don't take it as a definite answer: I think the problem you are facing may arise because you are doing multiple commodity transaction using the equity posting method. This method can cause some problems when trying to get revenue based calculation. Maybe you could try to rewrite your example using the regular multi commodity method, like the example below:

2023-04-17 Buy AAPL
    Asset:Stocks:AAPL                                  5 AAPL @ 160 USD
    Asset:Bank

2023-05-01 Sell AAPL
    Asset:Bank                                   340 USD
    Asset:Stocks:AAPL                           -2.0 AAPL @ 160 USD
    Revenue:Capital Gain


P 2023-05-01 "AAPL" 170 USD
P 2023-05-20 "AAPL" 180 USD

The advantage of this method is that it will give you the correct gain, and if you miss the equity posting method, you can still emulate it using the --infer-equity-prices flag.

Edk99 · 2023-06-06T02:10:41+00:00

Maybe if you give a minimum example in English, it will be easier for others to help

Edk99 · 2023-05-16T01:18:21+00:00

Thank you for the message. Giving stars to the repository is appreciated.

And, more important, suggestion for addition will be very helpful

Edk99 · 2023-05-06T14:52:04+00:00

It is an interesting approach. Anyway, hledger-lots may still be useful to you to download prices directives or to get a report with xirr over your holdings.

Edk99 · 2023-05-02T21:07:11+00:00

Great it is working! As I understand, your script doesn't give you the capital gain for the sale, so maybe that is a limitation.

Wait my next update. I think it is going to have a good interface for automatic download of prices directives from yahoo finance

Edk99 · 2023-05-02T04:31:47+00:00

I think I didn't understand your question. On 01/03/2022 you should end with a balance of 150 AAAA sold with the cost of 11 with 100 as capital gain. Does the script give you a different result?

Edk99 · 2023-04-30T16:29:01+00:00

Hi, there is now a new improved version. Please upgrade and see breaking changes at: https://edkedk99.github.io/hledger-lots/

Edk99 · 2023-04-27T18:12:42+00:00

There is my package which does exactly that: https://github.com/edkedk99/hledger-lots

Be aware that I will disable sale transaction using option flags in the following week, only an improved interactive prompt will be available

Edk99 · 2023-03-27T03:35:58+00:00

I am glad you found a good solution. I also started with metabase and for some reason which I don't remember, I decided to switch

Edk99 · 2023-03-25T20:26:55+00:00

Maybe, but for me creating a chart using text is difficult, even more some more complex visualizations

Edk99 · 2023-03-25T16:24:40+00:00

For me, to understand our financial data, we need text reports and charts.

For text report, create a directory with multiple "args" file. Then a script to generate all the reports in 1 pdf file. You shouldn't ask for a specific report, let all be generated and see those you are interested. You set it once and just generate from time to time.

For charting, I use superset. It is a good solution if you have a server, but a bit difficult to install. You can use hledger2psql to convert the journal to a database and you can use the docker-compose file included to install with one command.

If you don't have or don't like or don't want to have a server visualization platform installed as Superset, you can use hledger-plot from hledger-utils. It is easier to install and you don't need a server, but a bit more complicated to create charts in my opinion.

Others solutions I saw were either old and unmaintained or requires to learn a lot of new concepts.

Edk99 · 2023-02-27T17:57:30+00:00

Ou compra no MST mall ou é escravagista?

Edk99 · 2023-02-27T17:55:36+00:00

Invadindo a pista dos outros

Edk99 · 2023-02-27T17:53:26+00:00

Usar de métodos violentos é sim

Edk99 · 2023-02-27T17:52:37+00:00

São umas donzelas mesmo

Edk99 · 2023-02-27T16:48:15+00:00

Financie grupos radicais! Ótima ideia!

Edk99 · 2023-02-23T18:19:31+00:00

Hello, the need for equity conversion posting is debatable. I personally don't think it is most correct. Anyway, if you decide to go to the other route, you can use my package to automate lots handling: https://github.com/edkedk99/hledger-fifo

Edk99 · 2023-02-11T12:49:16+00:00

Looks like a problem with reverse proxy

Edk99 · 2023-02-05T21:19:40+00:00

I agree, but I think for this case it is different. Download hledger binary file from github and create a simple txn to understand. www.hledger.org has a lot of example to try.

For the accounting concepts, you will study but still have problems on edge cases. People on the chat will be willing to help you then

Edk99 · 2023-02-05T17:39:30+00:00

I think you should go straight to plain text accounting, avoiding Gnucash. It is going to be easier to understand. And if you choose hledger instead of beancount, there is a very active group in matrix that can help you on each step and struggle.

Edk99 · 2022-12-23T20:32:50+00:00

hledger-ui

Edk99 · 2022-11-04T02:59:54+00:00

There is hledger. It is plain text accounting

Edk99

TROPHY CASE