本项目是为如下人士准备的 (AND)
- 生活、工作在中国
- 熟练使用 *nix 环境下终端操作
- 对文本记账感兴趣
- 看过了最基础的 beancount 介绍但是没有看完所有文档(太多了)
- 想马上试试用 beancount 记账
- Python 3.6.5 # Python3 就行 如果你已经安装了 pyenv-virtualenv, 那需要一个基于 Python 3.6.5 的虚拟环境,否则请自行准备 Python 3.6.5 运行环境:
pyenv virtualenv 3.6.5 beancount-env
- 安装依赖的库
pip install -r requirements.txt
- 有如下银行的储蓄卡
- 招商银行 (工资卡)
- 招商银行香港分行
- 有如下银行的全币种信用卡
- 浦发银行 (日常消费主力卡, 外币交易自动购汇人民币还款)
- 工商银行 (境外消费为主,外币交易不自动购汇,需要自行购汇还外币)
- 有如下投资(机)账户
- 富途证券港美股账户
- 东方财富证券A股账户
- 蚂蚁财富(支付宝)基金账户
- 天天基金账户
- 在 https://docs.google.com/spreadsheets 新建一个表格,复制URL中的ID部分到
local/gdocid
这个文件中。
# 比如 https://docs.google.com/spreadsheets/d/1jnds3X_-RSTN4ATuOFV-v6tar0KfAla88vC43Vq6ubc/edit?usp=sharing
$ cat local/gdocid
1jnds3X_-RSTN4ATuOFV-v6tar0KfAla88vC43Vq6ubc
make prices
确认标的价格是最新的make spreadsheets
生成净值和持仓csv文件,并上传到上述新建的spreadsheet. 期间可能会提示配置 Google Docs 的 API Key, 按提示进行即可。净值
和持仓
分别会出现在2个sheet里,如果需要报表的话,可以基于这些数据新建一个sheet放报表。举个例子:
可见 ledger/init.beancount
文件中初始化的过程
每一个投资标的就是一个commodity, 比如现金 CNY, USD, 股票 SPY, AAPL ...
- 各国外汇按标准名称来:
CNY
,USD
,CNH
, ...
- 美股代号按交易所代码来
AAPL
,GOOGL
- 港股代号以
HK_
开头按 4 位数字命名HK_2800
,HK_0700
- A股(含场内基金)代号以
CN_
开头按 6 位数字命名CN_000001
,CN_510300
, ...
- 场外基金(货币基金除外)以
CN_F
开头按 6 位数字命名CN_F110011
- 货币基金直接用 CNY 表示,收益需要手工更新(原因是货币基金无净值的概念)。
- CNY
- 帐本名称
YourLedger
- 所在城市
YourCity
- 供职单位
YourEmployer
XXX
TODO
- importers/ : 通过 bean-extract 自动导入帐单所需的自定义脚本
- raw-data/ : csv 等格式的原始帐单存放目录
- sources/ : 自定义的股票、基金行情脚本(默认只支持从雅虎财经中获取)
- ledger/ : 所有的 beancount 文件都在这里面
- main.beancount : 主入口
- account.beancount : 所有的账户定义在这里
- commodity.beancount : 如果你不需要自动获取行情价格,你甚至都不需要这个文件
- prices.beancount : 这个文件由 bean-price 命令管理,一般不需要手动修改
- init.beancount : 初始化帐本用
- salary.beancount : 工资收入
- invest.beancount : 现金之外的投资(机)相关记录(买卖、申赎)
- daily/ : 日常流水
- daily/2019 : 按年分目录
- daily/2019/2019-07-03-spdbccc.beancount : 主力消费卡记录(自动生成+人工修改)
- daily/2019/2019-07-03-other.beancount : 非主力下记录
- daily/2019/2019-07-03-settle.beancount : 定期结算检查点
- 参照随手记App的支出分类法, 分为2级, 见 ledger/account.beancount 中账户的定义。
- 公司缴纳的公积金作为收入计算
- 公司缴纳的各种险不入帐
- 个人缴纳的各种税和险作为支出计算
- 个人缴纳的公积金当作转帐计算
- 详见 salary.beancount
- 因为交易频率不高,因此数据都是手工输入
- 可参见 invest.beancount 中的定义
- ledger/commodity.beancount 中定义了某一个 commodity 从哪里获取行情
- 自定义行情脚本定义在 sources/ , 目前支持从雪球获取A/港/美股股票行情,从天天基金获取基金行情
- 货币基金当现金处理
make prices
# 或
./scripts/update-prices.py | sh
这个命令会自动拉取最后一条 price 记录的时间到昨天为止的各个持仓标的的价格。建议隔三差五就跑一次。
基于2019年5月的帐单(csv格式)生成 beancount 文件
bean-extract importers/spdccc_importer.py raw-data/spdbcc/2019-05-spdbcc.csv > ledger/daily/2019/2019-06-03-spdbcc.beancount
当前仓库默认没有加密,如果你想加密的话,推荐使用 git-crypt, 它比 git-secret 使用起来更加方便。
./scripts/generate-portfolio.py -d 2019-12-31 # 查看某一日的持仓
./scripts/generate-portfolio.py # 查看当前持仓
输出的csv格式持仓可以导入表格软件进一步分析,或者使用 tabview 直接在终端浏览。例子:
一级类别 | 二级类别 | 标的 | 代号 | 持仓量 | 市场价格 | 报价日期 | 市场价值 | 货币 | 人民币价值 | 占比 |
---|---|---|---|---|---|---|---|---|---|---|
现金 | 本币 | 人民币 | CNY | 59287.860 | 1.0000 | 59288 | CNY | 59287.86 | 10.68% | |
现金 | 外汇 | 美元 | USD | 19460.700 | 1.0000 | 19461 | USD | 138338.94 | 24.92% | |
现金 | 外汇 | 港元 | HKD | 134112.000 | 1.0000 | 134112 | HKD | 123000.76 | 22.16% | |
现金 | 外汇 | 离岸人民币 | CNH | 1000.000 | 1.0000 | 1000 | CNH | 999.20 | 0.18% | |
债权 | 债券基金 | 华泰柏瑞丰盛纯债债券A | CN_F000187 | 6000.000 | 1.2902 | 2020-05-15 | 7741 | CNY | 7741.20 | 1.39% |
债权 | 可转换债券 | 光电转债 | CN_128047 | 100.000 | 129.0270 | 2019-10-15 | 12903 | CNY | 12902.70 | 2.32% |
股权 | 指数基金 | SPDR S&P 500 ETF | SPY | 15.000 | 286.2800 | 2020-05-15 | 4294 | USD | 30525.88 | 5.50% |
股权 | 指数基金 | 华泰沪深300ETF | CN_510300 | 100.000 | 3.9020 | 2020-05-15 | 390 | CNY | 390.20 | 0.07% |
股权 | 偏股混合基金 | 易方达中小盘混合 | CN_F110011 | 10000.000 | 5.2343 | 2020-05-15 | 52343 | CNY | 52343.00 | 9.43% |
股权 | A股 | 平安银行 | CN_000001 | 100.000 | 13.2300 | 2020-05-15 | 1323 | CNY | 1323.00 | 0.24% |
股权 | 港股 | 腾讯控股 | HK_0700 | 50.000 | 421.2000 | 2020-05-15 | 21060 | HKD | 19315.17 | 3.48% |
股权 | 港股 | 盈富基金 | HK_2800 | 100.000 | 24.0000 | 2020-05-15 | 2400 | HKD | 2201.16 | 0.40% |
股权 | 美股 | Apple Inc. | AAPL | 10.000 | 307.7100 | 2020-05-15 | 3077 | USD | 21873.97 | 3.94% |
另类 | 加密货币 | USDT | USDT | 776.340 | 1.0000 | 776 | USDT | 5395.56 | 0.97% | |
另类 | 加密货币 | 比特币 | BTC | 1.175 | 9336.9561 | 2020-05-15 | 10967 | USD | 77958.38 | 14.04% |
另类 | 加密货币 | 以太坊 | ETH | 1.000 | 223.8500 | 2019-07-16 | 224 | USDT | 1555.76 | 0.28% |
./scripts/generate-networth-report.py # 查看年初至今的净值
./scripts/generate-networth-report.py -s 2019-12-01 # 查看某一日至今的净值
输出的csv格式持仓可以导入表格软件进一步分析,或者使用 tabview 直接在终端浏览。例子:
日期 | 净资产 | 可投资金额 | 非投资收入 | 非投资支出 | 投资盈亏 | 投资盈亏% | 累计净值 | 累计盈亏 | 当年净值 | 当年盈亏 | 另类% | 股权% | 债权% | 现金% |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-01-01 | 559138.53 | 531175.73 | 0.00 | 0.00 | n/a | n/a | 1.0000 | 0.00 | 1.0000 | 0.00 | 13.20% | 23.54% | 3.84% | 59.43% |
2020-01-02 | 558641.52 | 530678.72 | 0.00 | 0.00 | -497.01 | -0.0936% | 0.9991 | -497.01 | 0.9991 | -497.01 | 12.94% | 23.73% | 3.84% | 59.49% |
2020-01-03 | 560789.32 | 532826.52 | 0.00 | 0.00 | 2147.79 | 0.4047% | 1.0031 | 1650.79 | 1.0031 | 1650.79 | 13.37% | 23.47% | 3.82% | 59.33% |
2020-01-06 | 562714.79 | 534751.99 | 0.00 | 0.00 | 1925.47 | 0.3614% | 1.0067 | 3576.26 | 1.0067 | 3576.26 | 13.87% | 23.17% | 3.81% | 59.15% |
2020-01-07 | 564344.69 | 536381.89 | 0.00 | 0.00 | 1629.91 | 0.3048% | 1.0098 | 5206.16 | 1.0098 | 5206.16 | 14.30% | 23.14% | 3.80% | 58.76% |
2020-01-08 | 563946.82 | 535984.02 | 0.00 | 0.00 | -397.87 | -0.0742% | 1.0091 | 4808.29 | 1.0091 | 4808.29 | 14.20% | 23.19% | 3.80% | 58.81% |
2020-01-09 | 563990.03 | 536027.23 | 0.00 | 0.00 | 43.20 | 0.0081% | 1.0091 | 4851.49 | 1.0091 | 4851.49 | 13.92% | 23.54% | 3.80% | 58.74% |
2020-01-10 | 566470.03 | 538507.23 | 0.00 | 0.00 | 2480.00 | 0.4627% | 1.0138 | 7331.50 | 1.0138 | 7331.50 | 14.21% | 23.59% | 3.79% | 58.41% |
2020-01-13 | 566349.87 | 538387.07 | 0.00 | 0.00 | -120.16 | -0.0223% | 1.0136 | 7211.34 | 1.0136 | 7211.34 | 14.14% | 23.87% | 3.79% | 58.20% |
2020-01-14 | 569554.58 | 541591.78 | 0.00 | 0.00 | 3204.72 | 0.5952% | 1.0196 | 10416.05 | 1.0196 | 10416.05 | 14.92% | 23.52% | 3.77% | 57.80% |
2020-01-15 | 569552.86 | 541590.06 | 0.00 | 0.00 | -1.73 | -0.0003% | 1.0196 | 10414.33 | 1.0196 | 10414.33 | 14.89% | 23.51% | 3.77% | 57.83% |
2020-01-16 | 569231.86 | 541269.06 | 0.00 | 0.00 | -320.99 | -0.0593% | 1.0190 | 10093.33 | 1.0190 | 10093.33 | 14.78% | 23.64% | 3.77% | 57.80% |
2020-01-17 | 569877.74 | 541914.94 | 0.00 | 0.00 | 645.88 | 0.1193% | 1.0202 | 10739.21 | 1.0202 | 10739.21 | 14.99% | 23.64% | 3.77% | 57.60% |
2020-01-20 | 568368.80 | 540406.00 | 0.00 | 0.00 | -1508.94 | -0.2784% | 1.0174 | 9230.27 | 1.0174 | 9230.27 | 14.70% | 23.70% | 3.78% | 57.82% |
2020-01-21 | 569909.61 | 541946.81 | 0.00 | 0.00 | 1540.81 | 0.2851% | 1.0203 | 10771.08 | 1.0203 | 10771.08 | 14.83% | 23.50% | 3.77% | 57.90% |
2020-01-22 | 569567.31 | 541604.51 | 0.00 | 0.00 | -342.30 | -0.0632% | 1.0196 | 10428.78 | 1.0196 | 10428.78 | 14.76% | 23.55% | 3.77% | 57.92% |
2020-01-23 | 567857.58 | 539894.78 | 0.00 | 0.00 | -1709.73 | -0.3157% | 1.0164 | 8719.05 | 1.0164 | 8719.05 | 14.50% | 23.40% | 3.78% | 58.32% |
2020-01-24 | 567857.58 | 539894.78 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0164 | 8719.05 | 1.0164 | 8719.05 | 14.50% | 23.40% | 3.78% | 58.32% |
2020-01-27 | 567857.58 | 539894.78 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0164 | 8719.05 | 1.0164 | 8719.05 | 14.50% | 23.40% | 3.78% | 58.32% |
2020-01-28 | 567857.58 | 539894.78 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0164 | 8719.05 | 1.0164 | 8719.05 | 14.50% | 23.40% | 3.78% | 58.32% |
2020-01-29 | 567857.58 | 539894.78 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0164 | 8719.05 | 1.0164 | 8719.05 | 14.50% | 23.40% | 3.78% | 58.32% |
2020-01-30 | 567857.58 | 539894.78 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0164 | 8719.05 | 1.0164 | 8719.05 | 14.50% | 23.40% | 3.78% | 58.32% |
2020-01-31 | 567857.58 | 539894.78 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0164 | 8719.05 | 1.0164 | 8719.05 | 14.50% | 23.40% | 3.78% | 58.32% |
2020-02-03 | 573898.42 | 545935.62 | 0.00 | 0.00 | 6040.84 | 1.1189% | 1.0278 | 14759.89 | 1.0278 | 14759.89 | 15.61% | 22.36% | 3.75% | 58.27% |
2020-02-04 | 574237.05 | 546274.25 | 0.00 | 0.00 | 338.63 | 0.0620% | 1.0284 | 15098.52 | 1.0284 | 15098.52 | 15.42% | 22.75% | 3.75% | 58.08% |
2020-02-05 | 577799.49 | 549836.69 | 0.00 | 0.00 | 3562.44 | 0.6521% | 1.0351 | 18660.96 | 1.0351 | 18660.96 | 15.83% | 22.89% | 3.73% | 57.55% |
2020-02-06 | 580439.96 | 552477.16 | 0.00 | 0.00 | 2640.47 | 0.4802% | 1.0401 | 21301.43 | 1.0401 | 21301.43 | 15.89% | 23.15% | 3.71% | 57.25% |
2020-02-07 | 580439.96 | 552477.16 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0401 | 21301.43 | 1.0401 | 21301.43 | 15.89% | 23.15% | 3.71% | 57.25% |
2020-02-10 | 582205.63 | 554242.83 | 0.00 | 0.00 | 1765.67 | 0.3196% | 1.0434 | 23067.10 | 1.0434 | 23067.10 | 16.03% | 23.12% | 3.70% | 57.16% |
2020-02-11 | 585175.01 | 557212.21 | 0.00 | 0.00 | 2969.38 | 0.5358% | 1.0490 | 26036.48 | 1.0490 | 26036.48 | 16.37% | 23.16% | 3.68% | 56.79% |
2020-02-12 | 586760.25 | 558797.45 | 0.00 | 0.00 | 1585.24 | 0.2845% | 1.0520 | 27621.72 | 1.0520 | 27621.72 | 16.46% | 23.27% | 3.67% | 56.60% |
2020-02-13 | 586547.84 | 558585.04 | 0.00 | 0.00 | -212.41 | -0.0380% | 1.0516 | 27409.31 | 1.0516 | 27409.31 | 16.35% | 23.26% | 3.67% | 56.71% |
2020-02-14 | 587939.30 | 559976.50 | 0.00 | 0.00 | 1391.45 | 0.2491% | 1.0542 | 28800.77 | 1.0542 | 28800.77 | 16.44% | 23.30% | 3.67% | 56.59% |
2020-02-17 | 583519.50 | 555556.70 | 0.00 | 0.00 | -4419.79 | -0.7893% | 1.0459 | 24380.97 | 1.0459 | 24380.97 | 15.78% | 23.52% | 3.70% | 57.01% |
2020-02-18 | 586376.83 | 558414.03 | 0.00 | 0.00 | 2857.33 | 0.5143% | 1.0513 | 27238.30 | 1.0513 | 27238.30 | 16.30% | 23.18% | 3.68% | 56.84% |
2020-02-19 | 586376.83 | 558414.03 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0513 | 27238.30 | 1.0513 | 27238.30 | 16.30% | 23.18% | 3.68% | 56.84% |
2020-02-20 | 585097.66 | 557134.86 | 0.00 | 0.00 | -1279.16 | -0.2291% | 1.0489 | 25959.13 | 1.0489 | 25959.13 | 15.70% | 23.53% | 3.69% | 57.08% |
2020-02-21 | 584653.91 | 556691.11 | 0.00 | 0.00 | -443.75 | -0.0796% | 1.0480 | 25515.38 | 1.0480 | 25515.38 | 15.83% | 23.32% | 3.69% | 57.16% |
2020-02-24 | 581216.57 | 553253.77 | 0.00 | 0.00 | -3437.34 | -0.6175% | 1.0416 | 22078.04 | 1.0416 | 22078.04 | 15.89% | 22.88% | 3.72% | 57.52% |
2020-02-25 | 576706.02 | 548743.22 | 0.00 | 0.00 | -4510.55 | -0.8153% | 1.0331 | 17567.49 | 1.0331 | 17567.49 | 15.59% | 22.79% | 3.75% | 57.87% |
2020-02-26 | 572481.47 | 544518.67 | 0.00 | 0.00 | -4224.55 | -0.7699% | 1.0251 | 13342.94 | 1.0251 | 13342.94 | 15.04% | 22.84% | 3.78% | 58.34% |
2020-02-27 | 569084.25 | 541121.45 | 0.00 | 0.00 | -3397.22 | -0.6239% | 1.0187 | 9945.72 | 1.0187 | 9945.72 | 15.07% | 22.52% | 3.80% | 58.61% |
2020-02-28 | 564817.25 | 536854.45 | 0.00 | 0.00 | -4267.00 | -0.7885% | 1.0107 | 5678.72 | 1.0107 | 5678.72 | 15.01% | 22.23% | 3.83% | 58.93% |
2020-03-02 | 569944.19 | 541981.39 | 0.00 | 0.00 | 5126.95 | 0.9550% | 1.0203 | 10805.66 | 1.0203 | 10805.66 | 15.09% | 22.83% | 3.80% | 58.29% |
2020-03-03 | 569387.90 | 541425.10 | 0.00 | 0.00 | -556.29 | -0.1026% | 1.0193 | 10249.37 | 1.0193 | 10249.37 | 15.02% | 22.74% | 3.80% | 58.44% |
2020-03-04 | 568808.58 | 540845.78 | 0.00 | 0.00 | -579.32 | -0.1070% | 1.0182 | 9670.05 | 1.0182 | 9670.05 | 14.90% | 23.14% | 3.81% | 58.15% |
2020-03-05 | 572248.46 | 544285.66 | 0.00 | 0.00 | 3439.87 | 0.6360% | 1.0247 | 13109.93 | 1.0247 | 13109.93 | 15.24% | 23.12% | 3.78% | 57.86% |
2020-03-06 | 569850.80 | 541888.00 | 0.00 | 0.00 | -2397.66 | -0.4405% | 1.0202 | 10712.26 | 1.0202 | 10712.26 | 15.35% | 22.79% | 3.80% | 58.06% |
2020-03-09 | 556295.99 | 528333.19 | 0.00 | 0.00 | -13554.81 | -2.5014% | 0.9946 | -2842.54 | 0.9946 | -2842.54 | 14.21% | 22.20% | 3.90% | 59.70% |
2020-03-10 | 560642.04 | 532679.24 | 0.00 | 0.00 | 4346.06 | 0.8226% | 1.0028 | 1503.51 | 1.0028 | 1503.51 | 14.09% | 22.77% | 3.87% | 59.28% |
2020-03-11 | 557566.89 | 529604.09 | 0.00 | 0.00 | -3075.15 | -0.5773% | 0.9970 | -1571.64 | 0.9970 | -1571.64 | 14.16% | 22.37% | 3.89% | 59.58% |
2020-03-12 | 533753.00 | 505790.20 | 0.00 | 0.00 | -23813.90 | -4.4965% | 0.9522 | -25385.54 | 0.9522 | -25385.54 | 10.85% | 22.25% | 4.07% | 62.83% |
2020-03-13 | 540151.97 | 512189.17 | 0.00 | 0.00 | 6398.98 | 1.2651% | 0.9643 | -18986.56 | 0.9643 | -18986.56 | 11.50% | 22.62% | 4.02% | 61.87% |
2020-03-16 | 529322.49 | 501359.69 | 0.00 | 0.00 | -10829.48 | -2.1144% | 0.9439 | -29816.04 | 0.9439 | -29816.04 | 11.01% | 21.42% | 4.10% | 63.46% |
2020-03-17 | 533129.86 | 505167.06 | 0.00 | 0.00 | 3807.37 | 0.7594% | 0.9510 | -26008.67 | 0.9510 | -26008.67 | 11.22% | 21.73% | 4.07% | 62.98% |
2020-03-18 | 530493.16 | 502530.36 | 0.00 | 0.00 | -2636.70 | -0.5219% | 0.9461 | -28645.37 | 0.9461 | -28645.37 | 11.31% | 21.18% | 4.09% | 63.42% |
2020-03-19 | 540071.63 | 512108.83 | 0.00 | 0.00 | 9578.47 | 1.9060% | 0.9641 | -19066.90 | 0.9641 | -19066.90 | 12.51% | 20.67% | 4.01% | 62.81% |
2020-03-20 | 539069.72 | 511106.92 | 0.00 | 0.00 | -1001.91 | -0.1956% | 0.9622 | -20068.81 | 0.9622 | -20068.81 | 12.51% | 20.69% | 4.02% | 62.78% |
2020-03-23 | 537334.85 | 509372.05 | 0.00 | 0.00 | -1734.87 | -0.3394% | 0.9590 | -21803.68 | 0.9590 | -21803.68 | 12.85% | 20.17% | 4.04% | 62.95% |
2020-03-24 | 544602.16 | 516639.36 | 0.00 | 0.00 | 7267.31 | 1.4267% | 0.9726 | -14536.37 | 0.9726 | -14536.37 | 13.07% | 21.05% | 3.98% | 61.89% |
2020-03-25 | 548926.96 | 520964.16 | 0.00 | 0.00 | 4324.80 | 0.8371% | 0.9808 | -10211.57 | 0.9808 | -10211.57 | 12.94% | 21.46% | 3.95% | 61.65% |
2020-03-26 | 550531.93 | 522569.13 | 0.00 | 0.00 | 1604.97 | 0.3081% | 0.9838 | -8606.60 | 0.9838 | -8606.60 | 12.92% | 21.85% | 3.94% | 61.29% |
2020-03-27 | 548513.85 | 520551.05 | 0.00 | 0.00 | -2018.09 | -0.3862% | 0.9800 | -10624.69 | 0.9800 | -10624.69 | 12.66% | 21.69% | 3.95% | 61.69% |
2020-03-30 | 548359.00 | 520396.20 | 0.00 | 0.00 | -154.84 | -0.0297% | 0.9797 | -10779.53 | 0.9797 | -10779.53 | 12.62% | 21.70% | 3.96% | 61.73% |
2020-03-31 | 549446.65 | 521483.85 | 0.00 | 0.00 | 1087.65 | 0.2090% | 0.9818 | -9691.88 | 0.9818 | -9691.88 | 12.60% | 21.85% | 3.95% | 61.60% |
2020-04-01 | 548247.47 | 520284.67 | 0.00 | 0.00 | -1199.18 | -0.2300% | 0.9795 | -10891.06 | 0.9795 | -10891.06 | 12.86% | 21.42% | 3.96% | 61.76% |
2020-04-02 | 548247.47 | 520284.67 | 0.00 | 0.00 | 0.00 | 0.0000% | 0.9795 | -10891.06 | 0.9795 | -10891.06 | 12.86% | 21.42% | 3.96% | 61.76% |
2020-04-03 | 549544.74 | 521581.94 | 0.00 | 0.00 | 1297.27 | 0.2493% | 0.9819 | -9593.79 | 0.9819 | -9593.79 | 12.99% | 21.53% | 3.95% | 61.53% |
2020-04-06 | 549544.74 | 521581.94 | 0.00 | 0.00 | 0.00 | 0.0000% | 0.9819 | -9593.79 | 0.9819 | -9593.79 | 12.99% | 21.53% | 3.95% | 61.53% |
2020-04-07 | 555576.69 | 527613.89 | 0.00 | 0.00 | 6031.95 | 1.1565% | 0.9933 | -3561.84 | 0.9933 | -3561.84 | 13.39% | 22.11% | 3.91% | 60.59% |
2020-04-08 | 558227.88 | 530265.08 | 0.00 | 0.00 | 2651.19 | 0.5025% | 0.9983 | -910.65 | 0.9983 | -910.65 | 13.55% | 22.20% | 3.89% | 60.36% |
2020-04-09 | 558985.91 | 531023.11 | 0.00 | 0.00 | 758.02 | 0.1430% | 0.9997 | -152.62 | 0.9997 | -152.62 | 13.47% | 22.42% | 3.89% | 60.21% |
2020-04-10 | 556044.40 | 528081.60 | 0.00 | 0.00 | -2941.50 | -0.5539% | 0.9942 | -3094.13 | 0.9942 | -3094.13 | 12.96% | 22.57% | 3.91% | 60.55% |
2020-04-13 | 555767.48 | 527804.68 | 0.00 | 0.00 | -276.92 | -0.0524% | 0.9937 | -3371.05 | 0.9937 | -3371.05 | 12.94% | 22.56% | 3.91% | 60.58% |
2020-04-14 | 558327.52 | 530364.72 | 0.00 | 0.00 | 2560.03 | 0.4850% | 0.9985 | -811.02 | 0.9985 | -811.02 | 12.88% | 22.95% | 3.89% | 60.28% |
2020-04-15 | 556094.93 | 528132.13 | 0.00 | 0.00 | -2232.59 | -0.4210% | 0.9943 | -3043.61 | 0.9943 | -3043.61 | 12.67% | 22.85% | 3.91% | 60.57% |
2020-04-16 | 560659.12 | 532696.32 | 0.00 | 0.00 | 4564.20 | 0.8642% | 1.0029 | 1520.59 | 1.0029 | 1520.59 | 13.20% | 22.80% | 3.88% | 60.12% |
2020-04-17 | 561653.16 | 533690.36 | 0.00 | 0.00 | 994.03 | 0.1866% | 1.0047 | 2514.63 | 1.0047 | 2514.63 | 13.15% | 22.95% | 3.87% | 60.03% |
2020-04-20 | 559297.52 | 531334.72 | 0.00 | 0.00 | -2355.64 | -0.4414% | 1.0003 | 158.99 | 1.0003 | 158.99 | 12.93% | 22.89% | 3.89% | 60.29% |
2020-04-21 | 557604.40 | 529641.60 | 0.00 | 0.00 | -1693.12 | -0.3187% | 0.9971 | -1534.13 | 0.9971 | -1534.13 | 12.99% | 22.47% | 3.90% | 60.63% |
2020-04-22 | 561186.28 | 533223.48 | 0.00 | 0.00 | 3581.88 | 0.6763% | 1.0039 | 2047.75 | 1.0039 | 2047.75 | 13.20% | 22.78% | 3.88% | 60.14% |
2020-04-23 | 563852.05 | 535889.25 | 0.00 | 0.00 | 2665.77 | 0.4999% | 1.0089 | 4713.52 | 1.0089 | 4713.52 | 13.55% | 22.78% | 3.86% | 59.82% |
2020-04-24 | 565331.28 | 537368.48 | 0.00 | 0.00 | 1479.23 | 0.2760% | 1.0117 | 6192.75 | 1.0117 | 6192.75 | 13.67% | 22.83% | 3.85% | 59.65% |
2020-04-27 | 568194.44 | 540231.64 | 0.00 | 0.00 | 2863.16 | 0.5328% | 1.0170 | 9055.91 | 1.0170 | 9055.91 | 13.92% | 22.89% | 3.83% | 59.36% |
2020-04-28 | 569105.92 | 541143.12 | 0.00 | 0.00 | 911.48 | 0.1687% | 1.0188 | 9967.39 | 1.0188 | 9967.39 | 13.91% | 23.05% | 3.82% | 59.22% |
2020-04-29 | 577034.26 | 549071.46 | 0.00 | 0.00 | 7928.35 | 1.4651% | 1.0337 | 17895.73 | 1.0337 | 17895.73 | 14.99% | 22.88% | 3.77% | 58.36% |
2020-04-30 | 574514.61 | 546551.81 | 0.00 | 0.00 | -2519.65 | -0.4589% | 1.0289 | 15376.08 | 1.0289 | 15376.08 | 14.83% | 22.94% | 3.79% | 58.44% |
2020-05-01 | 574514.61 | 546551.81 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0289 | 15376.08 | 1.0289 | 15376.08 | 14.83% | 22.94% | 3.79% | 58.44% |
2020-05-04 | 574514.61 | 546551.81 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0289 | 15376.08 | 1.0289 | 15376.08 | 14.83% | 22.94% | 3.79% | 58.44% |
2020-05-05 | 574514.61 | 546551.81 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0289 | 15376.08 | 1.0289 | 15376.08 | 14.83% | 22.94% | 3.79% | 58.44% |
2020-05-06 | 581227.30 | 553264.50 | 0.00 | 0.00 | 6712.69 | 1.2282% | 1.0416 | 22088.77 | 1.0416 | 22088.77 | 15.51% | 22.69% | 3.74% | 58.06% |
2020-05-07 | 586322.79 | 558359.99 | 0.00 | 0.00 | 5095.49 | 0.9210% | 1.0512 | 27184.26 | 1.0512 | 27184.26 | 16.21% | 22.62% | 3.70% | 57.46% |
2020-05-08 | 586633.56 | 558670.76 | 0.00 | 0.00 | 310.76 | 0.0557% | 1.0518 | 27495.03 | 1.0518 | 27495.03 | 16.05% | 22.91% | 3.70% | 57.35% |
2020-05-11 | 579773.30 | 551810.50 | 0.00 | 0.00 | -6860.25 | -1.2280% | 1.0388 | 20634.77 | 1.0388 | 20634.77 | 14.68% | 23.39% | 3.74% | 58.19% |
2020-05-12 | 580085.90 | 552123.10 | 0.00 | 0.00 | 312.60 | 0.0567% | 1.0394 | 20947.37 | 1.0394 | 20947.37 | 14.92% | 23.24% | 3.74% | 58.10% |
2020-05-13 | 583816.75 | 555853.95 | 0.00 | 0.00 | 3730.85 | 0.6757% | 1.0465 | 24678.22 | 1.0465 | 24678.22 | 15.42% | 23.13% | 3.71% | 57.74% |
2020-05-14 | 588018.88 | 560056.08 | 0.00 | 0.00 | 4202.13 | 0.7560% | 1.0544 | 28880.35 | 1.0544 | 28880.35 | 15.92% | 23.01% | 3.69% | 57.39% |
2020-05-15 | 584580.07 | 556617.27 | 0.00 | 0.00 | -3438.81 | -0.6140% | 1.0479 | 25441.54 | 1.0479 | 25441.54 | 15.52% | 22.99% | 3.71% | 57.78% |
2020-05-18 | 584580.07 | 556617.27 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0479 | 25441.54 | 1.0479 | 25441.54 | 15.52% | 22.99% | 3.71% | 57.78% |
2020-05-19 | 584580.07 | 556617.27 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0479 | 25441.54 | 1.0479 | 25441.54 | 15.52% | 22.99% | 3.71% | 57.78% |
2020-05-20 | 584580.07 | 556617.27 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0479 | 25441.54 | 1.0479 | 25441.54 | 15.52% | 22.99% | 3.71% | 57.78% |
2020-05-21 | 584580.07 | 556617.27 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0479 | 25441.54 | 1.0479 | 25441.54 | 15.52% | 22.99% | 3.71% | 57.78% |
2020-05-22 | 584580.07 | 556617.27 | 0.00 | 0.00 | 0.00 | 0.0000% | 1.0479 | 25441.54 | 1.0479 | 25441.54 | 15.52% | 22.99% | 3.71% | 57.78% |