LeonWu Leon2xiaowu
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python3 | |
| import requests | |
| import os | |
| import random | |
| def fetch_exchange_rate(): | |
| random_number = random.random() | |
| # 获取深交所结算汇兑比率 |
Leon2xiaowu
/ Fava Dashboards Sunburst Support SubClass.yaml
Last active
February 23, 2025 10:03
Fava Dashboards Sunburst Support SubClass
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dashboards: | |
| - name: Assets | |
| panels: | |
| - title: Asset Classes 🏦 | |
| width: 50% | |
| queries: | |
| - bql: &assets_bql | | |
| SELECT currency, CONVERT(SUM(position), '{{ledger.ccy}}') as market_value | |
| WHERE account_sortkey(account) ~ '^[01]' |
Leon2xiaowu
/ dashboards.yaml
Last active
November 19, 2024 14:32
fava_dashboards Sankey diagram configuration optimization, handle the display of losing investments
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| - name: IncomeStatementSankey | |
| panels: | |
| - title: IncomeStatementSankey 💸 | |
| height: 800px | |
| link: /mainbook/income_statement/ | |
| queries: | |
| - bql: | | |
| SELECT account, CONVERT(SUM(position), '{{ledger.ccy}}') AS value | |
| WHERE account ~ '^(Income|Expenses):' | |
| GROUP BY account |