# Last edited on 2015-02-12 15:24:40 by stolfilocal # gawk -v FS='|' -v OFS='|' 'BEGIN{ oNAS=0; EAI=0; } /^(Seed|[0-9][0-9][-][A-Z])/ { NAS=rmb($3); ENI=rmb($6); if (ENI != "") { EAI += ENI; } else if (NAS != "") { EAI += (NAS - oNAS); } if (NAS != "") { oNAS = NAS; } $8 = EAI; print; next; } // { print; } function rmb(x){ gsub(/^[ ]+/,"",x); gsub(/[ ]*$/,"",x); return x; }' | txtable-reformat Date ! NAV ($) ! Net ! Est ! Est Net ! Est New ! Actual ! Est Acc ! ! Assets ! Holding ! Buying ! Invest ! Holding ! Invest ! ! (M$) ! (XBT) ! (XBT) ! (M$) ! (XBT) ! (M$) Seed | 12.64 | 2.30 | 17800 | | | 17800 | 2.30 25-Sep-13 | 12.88 | | | | | | 2.30 26-Sep-13 | 12.67 | | | | | | 2.30 27-Sep-13 | 13.35 | | | | | | 2.30 30-Sep-13 | 13.26 | | | | | | 2.30 01-Oct-13 | 13.22 | | | | | | 2.30 02-Oct-13 | 11.86 | | | | | | 2.30 03-Oct-13 | 11.70 | | | | | | 2.30 04-Oct-13 | 12.63 | | | | | | 2.30 07-Oct-13 | 12.77 | | | | | | 2.30 08-Oct-13 | 12.52 | | | | | | 2.30 09-Oct-13 | 13.03 | | | | | | 2.30 10-Oct-13 | 13.14 | | | | | | 2.30 11-Oct-13 | 13.03 | | | | | | 2.30 14-Oct-13 | 14.27 | | | | | | 2.30 15-Oct-13 | 14.31 | | | | | | 2.30 16-Oct-13 | 14.86 | | | | | | 2.30 17-Oct-13 | 14.55 | | | | | | 2.30 18-Oct-13 | 15.20 | | | | | | 2.30 21-Oct-13 | 17.90 | | | | | | 2.30 22-Oct-13 | 19.10 | | | | | | 2.30 23-Oct-13 | 20.10 | | | | | | 2.30 24-Oct-13 | 19.46 | | | | | | 2.30 25-Oct-13 | 18.04 | | | | | | 2.30 28-Oct-13 | 19.62 | | | | | | 2.30 29-Oct-13 | 20.03 | | | | | | 2.30 30-Oct-13 | 20.30 | | | | | | 2.30 31-Oct-13 | 20.02 | | | | | | 2.30 01-Nov-13 | 20.46 | | | | | | 2.30 04-Nov-13 | 21.97 | | | | | | 2.30 05-Nov-13 | 23.78 | 8.30 | 34700 | | | 34700 | 8.30 06-Nov-13 | 25.45 | | | | | | 8.30 07-Nov-13 | 28.65 | | | | | | 8.30 08-Nov-13 | 31.96 | | | | | | 8.30 12-Nov-13 | 35.47 | | | | | | 8.30 13-Nov-13 | 38.24 | | | | | | 8.30 14-Nov-13 | 41.19 | 21.80 | 52730 | | | | 21.80 15-Nov-13 | 42.44 | 22.70 | 53290 | 560 | 0.24 | | 22.04 18-Nov-13 | 55.22 | 29.70 | 53587 | 297 | 0.16 | | 22.20 19-Nov-13 | 63.82 | | | | | | 22.20 20-Nov-13 | 52.97 | 29.70 | 55863 | | | | 22.20 21-Nov-13 | 63.26 | 35.40 | 55753 | -110 | -0.07 | | 22.13 22-Nov-13 | 71.00 | 41.90 | 58797 | 3044 | 2.17 | | 24.30 25-Nov-13 | 77.94 | 46.80 | 59825 | 1028 | 0.80 | | 25.10 26-Nov-13 | 83.07 | 50.90 | 61048 | 1223 | 1.02 | | 26.12 27-Nov-13 | 92.45 | 58.90 | 63475 | 2427 | 2.25 | | 28.37 29-Nov-13 | 107.81 | 69.10 | 63858 | 383 | 0.41 | 63858 | 28.78 02-Dec-13 | 97.13 | 63.30 | 64934 | 1076 | 1.05 | | 29.83 03-Dec-13 | 105.54 | 68.90 | 65048 | 114 | 0.12 | | 29.95 04-Dec-13 | 110.96 | 72.60 | 65195 | 147 | 0.16 | | 30.11 05-Dec-13 | 100.14 | 66.50 | 66171 | 976 | 0.98 | | 31.09 06-Dec-13 | 92.35 | 61.70 | 66575 | 404 | 0.37 | | 31.46 09-Dec-13 | 84.68 | 56.60 | 66608 | 33 | 0.02 | | 31.48 10-Dec-13 | 93.62 | 62.60 | 66635 | 27 | 0.02 | | 31.50 11-Dec-13 | 91.71 | 61.40 | 66721 | 86 | 0.08 | | 31.58 12-Dec-13 | 86.96 | 58.80 | 67387 | 666 | 0.58 | | 32.16 13-Dec-13 | 90.48 | 61.10 | 67300 | -87 | -0.08 | 67300 | 32.08 16-Dec-13 | 76.41 | 52.30 | 68202 | 902 | 0.70 | | 32.78 17-Dec-13 | 69.66 | 47.90 | 68512 | 310 | 0.22 | | 33.00 18-Dec-13 | 54.45 | 37.50 | 68615 | 103 | 0.06 | | 33.06 19-Dec-13 | 62.23 | 43.40 | 69478 | 863 | 0.54 | | 33.60 20-Dec-13 | 68.59 | 48.00 | 69713 | 235 | 0.16 | | 33.76 23-Dec-13 | 64.67 | 45.30 | 69766 | 53 | 0.04 | | 33.80 24-Dec-13 | 67.05 | 47.00 | 69810 | 44 | 0.03 | | 33.83 26-Dec-13 | 73.86 | 51.80 | 69837 | 27 | 0.03 | | 33.86 27-Dec-13 | 75.80 | 53.20 | 69884 | 47 | 0.04 | | 33.90 30-Dec-13 | 76.96 | 53.90 | 69723 | -161 | -0.11 | | 33.79 31-Dec-13 | 76.12 | 53.30 | 69703 | -20 | -0.01 | | 33.78 02-Jan-14 | 78.73 | 55.30 | 69912 | 209 | 0.17 | | 33.95 03-Jan-14 | 81.91 | 57.60 | 69988 | 76 | 0.07 | | 34.02 06-Jan-14 | 95.51 | 67.20 | 70013 | 25 | 0.04 | | 34.06 07-Jan-14 | 89.73 | 63.20 | 70082 | 69 | 0.07 | | 34.13 08-Jan-14 | 82.00 | 57.80 | 70132 | 50 | 0.04 | | 34.17 09-Jan-14 | 83.25 | 59.30 | 70867 | 735 | 0.62 | | 34.79 10-Jan-14 | 83.35 | 59.40 | 70897 | 30 | 0.03 | | 34.82 13-Jan-14 | 83.13 | 59.20 | 70831 | -66 | -0.04 | | 34.78 14-Jan-14 | 83.75 | 59.70 | 70896 | 65 | 0.06 | | 34.84 15-Jan-14 | 85.58 | 61.00 | 70886 | -10 | . | | 34.84 17-Jan-14 | 81.87 | 58.80 | 71417 | 531 | 0.44 | | 35.28 21-Jan-14 | 86.48 | 62.10 | 71386 | -31 | -0.01 | | 35.27 22-Jan-14 | 84.24 | 60.50 | 71392 | 6 | 0.01 | | 35.28 23-Jan-14 | 82.15 | 59.60 | 72114 | 722 | 0.60 | | 35.88 24-Jan-14 | 80.02 | 58.00 | 72042 | -72 | -0.05 | | 35.83 27-Jan-14 | 81.42 | 59.10 | 72132 | 90 | 0.09 | | 35.92 28-Jan-14 | 81.91 | 60.00 | 72787 | 655 | 0.54 | | 36.46 29-Jan-14 | 84.65 | 62.00 | 72774 | -13 | -0.01 | | 36.45 30-Jan-14 | 83.97 | 62.00 | 73359 | 585 | 0.50 | 73359 | 36.95 03-Feb-14 | 84.32 | 62.30 | 73390 | 31 | 0.04 | | 36.99 04-Feb-14 | 84.57 | 62.50 | 73403 | 13 | 0.02 | | 37.01 05-Feb-14 | 83.62 | 66.70 | 79221 | 5818 | 4.90 | | 41.91 06-Feb-14 | 80.61 | 64.80 | 79833 | 612 | 0.50 | | 42.41 07-Feb-14 | 71.27 | 57.30 | 79839 | 6 | 0.01 | | 42.42 10-Feb-14 | 62.00 | 49.90 | 79909 | 70 | 0.05 | | 42.47 11-Feb-14 | 66.96 | 53.90 | 79916 | 7 | 0.01 | | 42.48 12-Feb-14 | 64.82 | 52.20 | 79946 | 30 | 0.02 | | 42.50 13-Feb-14 | 62.72 | 51.10 | 80877 | 931 | 0.59 | | 43.09 14-Feb-14 | 60.54 | 49.40 | 80996 | 119 | 0.08 | | 43.17 18-Feb-14 | 61.83 | 50.40 | 80892 | -104 | -0.05 | | 43.12 19-Feb-14 | 61.46 | 50.10 | 80889 | -3 | . | | 43.12 20-Feb-14 | 58.97 | 48.60 | 81776 | 887 | 0.53 | | 43.65 21-Feb-14 | 55.15 | 45.50 | 81857 | 81 | 0.05 | | 43.70 24-Feb-14 | 56.95 | 47.00 | 81868 | 11 | 0.01 | | 43.71 25-Feb-14 | 48.32 | 39.90 | 81909 | 41 | 0.02 | | 43.73 26-Feb-14 | 55.86 | 46.40 | 82390 | 481 | 0.27 | | 44.00 27-Feb-14 | 57.32 | 48.20 | 83401 | 1011 | 0.59 | | 44.59 28-Feb-14 | 56.03 | 47.20 | 83546 | 145 | 0.08 | | 44.67 03-Mar-14 | 61.88 | 52.10 | 83485 | -61 | -0.03 | 83485 | 44.64 04-Mar-14 | 67.19 | 56.60 | 83522 | 37 | 0.03 | | 44.67 05-Mar-14 | 65.48 | 55.50 | 84032 | 510 | 0.34 | | 45.01 06-Mar-14 | 65.21 | 55.70 | 84680 | 648 | 0.43 | | 45.44 07-Mar-14 | 63.21 | 54.10 | 84842 | 162 | 0.11 | | 45.55 10-Mar-14 | 62.47 | 53.40 | 84714 | -128 | -0.07 | | 45.48 11-Mar-14 | 61.50 | 52.60 | 84757 | 43 | 0.03 | | 45.51 12-Mar-14 | 63.25 | 54.20 | 84909 | 152 | 0.10 | | 45.61 13-Mar-14 | 63.28 | 55.40 | 86746 | 1837 | 1.17 | | 46.78 14-Mar-14 | 62.85 | 56.10 | 88434 | 1688 | 1.08 | | 47.86 17-Mar-14 | 61.91 | 55.20 | 88314 | -120 | -0.06 | | 47.80 18-Mar-14 | 60.62 | 54.10 | 88387 | 73 | 0.05 | | 47.85 19-Mar-14 | 60.96 | 54.40 | 88380 | -7 | . | | 47.85 20-Mar-14 | 58.91 | 53.80 | 90443 | 2063 | 1.23 | | 49.08 21-Mar-14 | 57.33 | 53.30 | 92060 | 1617 | 0.94 | | 50.02 24-Mar-14 | 55.52 | 51.70 | 92188 | 128 | 0.08 | | 50.10 25-Mar-14 | 57.41 | 53.50 | 92250 | 62 | 0.04 | | 50.14 26-Mar-14 | 57.58 | 53.70 | 92313 | 63 | 0.04 | | 50.18 27-Mar-14 | 53.31 | 51.80 | 96176 | 3863 | 2.08 | | 52.26 28-Mar-14 | 49.63 | 48.20 | 96119 | -57 | -0.02 | | 52.24 31-Mar-14 | 45.30 | 44.00 | 96107 | -12 | 0.01 | | 52.25 01-Apr-14 | 47.22 | 45.90 | 96169 | 62 | 0.04 | 96169 | 52.29 02-Apr-14 | 45.38 | 43.30 | 94408 | -1761 | -0.81 | | 51.48 03-Apr-14 | 43.07 | 42.20 | 96941 | 2533 | 1.10 | | 52.58 04-Apr-14 | 43.89 | 42.50 | 95803 | -1138 | -0.50 | | 52.08 05-Apr-14 | 44.92 | 43.60 | 96030 | 227 | 0.10 | | 52.18 08-Apr-14 | 44.48 | 43.10 | 95872 | -158 | -0.07 | | 52.11 09-Apr-14 | 44.08 | 42.70 | 95843 | -29 | -0.01 | | 52.10 10-Apr-14 | 40.37 | 41.50 | 101710 | 5867 | 2.39 | | 54.49