Scribd Logo
Upload

Welcome to Scribd!

  • 24 views

    Otgonbayar.D Covers Investment With Macros 101219

    Uploaded by

    Xavar Xan
    The document shows the share prices of three companies, TeleCom, State Bank, and United Retail from June 2009 to June 2010. It also includes details of investments made in each company, such as purchase dates and number of shares. Line charts show the share price trends and total investment values over time for each company and in aggregate. Tables provide the monthly share prices, calculated investment values, and totals by company and in aggregate.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Otgonbayar.D Covers Investment With Macros 101219

    Uploaded by

    Xavar Xan
    24 views12 pages
    The document shows the share prices of three companies, TeleCom, State Bank, and United Retail from June 2009 to June 2010. It also includes details of investments made in each company, such as purchase dates and number of shares. Line charts show the share price trends and total investment values over time for each company and in aggregate. Tables provide the monthly share prices, calculated investment values, and totals by company and in aggregate.

    Original Title

    Otgonbayar.D_Covers_Investment_with_Macros_101219.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows the share prices of three companies, TeleCom, State Bank, and United Retail from June 2009 to June 2010. It also includes details of investments made in each company, such as purchase dates and number of shares. Line charts show the share price trends and total investment values over time for each company and in aggregate. Tables provide the monthly share prices, calculated investment values, and totals by company and in aggregate.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    24 views12 pages

    Otgonbayar.D Covers Investment With Macros 101219

    Uploaded by

    Xavar Xan
    The document shows the share prices of three companies, TeleCom, State Bank, and United Retail from June 2009 to June 2010. It also includes details of investments made in each company, such as purchase dates and number of shares. Line charts show the share price trends and total investment values over time for each company and in aggregate. Tables provide the monthly share prices, calculated investment values, and totals by company and in aggregate.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 12

    Shares Prices

    Date TeleCom (TC) State Bank (SB) United Retail (UR)


    6/30/2009 7.62 27.59 14.47 Investment Price
    7/31/2009 7.74 27.85 14.28 30
    8/31/2009 6.82 21.17 15.45
    9/30/2009 7.23 24.73 14.86 25

    10/31/2009 7.41 22.16 14.71 20


    11/30/2009 7.67 23.92 14.93
    12/31/2009 6.94 28.17 15.03 15
    1/31/2010 6.84 25.68 14.98
    10
    2/28/2010 7.01 26.12 15.22
    3/31/2010 7.34 26.86 15.36 5
    4/30/2010 7.22 25.99 15.67
    0
    5/31/2010 7.38 26.45 15.46 6/1/2009 8/1/2009 10/1/2009
    6/30/2010 7.55 26.62 15.51
    TeleCom (TC) St
    Investment Prices June 2009 - June 2010

    9 8/1/2009 10/1/2009 12/1/2009 2/1/2010 4/1/2010 6/1/2010

    TeleCom (TC) State Bank (SB) United Retail (UR)


    Totals the share
    Shares Date of Purchase No of Shares values for
    matching period

    TeleCom (TC) 7/1/2009 1000 7740


    State Bank (SB) 8/29/2009 1200 25404
    United Retail (UR) 7/1/2009 1500 21420

    Date TeleCom (TC) State Bank (SB) United Retail (UR)


    6/30/2009 7.62 27.59 14.47
    7/31/2009 7.74 27.85 14.28
    8/31/2009 6.82 21.17 15.45
    9/30/2009 7.23 24.73 14.86
    10/31/2009 7.41 22.16 14.71
    11/30/2009 7.67 23.92 14.93
    12/31/2009 6.94 28.17 15.03
    1/31/2010 6.84 25.68 14.98
    2/28/2010 7.01 26.12 15.22
    3/31/2010 7.34 26.86 15.36
    4/30/2010 7.22 25.99 15.67
    5/31/2010 7.38 26.45 15.46
    6/30/2010 7.55 26.62 15.51

    Total Investment Values


    450000
    400000
    350000
    300000
    250000
    200000
    150000
    400000
    350000
    300000
    250000
    200000
    150000
    100000
    50000
    0
    TeleCom (TC) State Bank (SB) United Retail (UR)
    Investment Details

    Date TeleCom (TC) State Bank (SB) United Retail (UR) TOTAL Average
    6/30/2009 7620 33108 21705 62433 20811
    7/31/2009 7740 33420 21420 62580 20860 -
    8/31/2009 6820 25404 23175 55399 18466
    9/30/2009 7230 29676 22290 59196 19732
    10/31/2009 7410 26592 22065 56067 18689
    11/30/2009 7670 28704 22395 58769 19590
    12/31/2009 6940 33804 22545 63289 21096
    1/31/2010 6840 30816 22470 60126 20042
    2/28/2010 7010 31344 22830 61184 20395
    3/31/2010 7340 32232 23040 62612 20871
    4/30/2010 7220 31188 23505 61913 20638
    5/31/2010 7380 31740 23190 62310 20770
    6/30/2010 7550 31944 23265 62759 20920
    TOTAL 94770 399972 293895
    Average Value 7897.5 33331 24491.25

    Total Investment Values


    64000

    62000

    60000

    58000

    56000

    54000
    62000

    60000

    58000

    56000

    54000

    52000

    50000
    ed Retail (UR) 6/1/2009 8/1/2009 10/1/2009 12/1/2009 2/1/2010 4/1/2010 6/1/2010
    Total the share values for matching period
    2010 6/1/2010
    Investment Price Total investment Value / by
    month /
    Date TeleCom (TC) State Bank (SB) United Retail (UR) Date TOTAL
    6/30/2009 7.62 27.59 14.47 6/30/2009 40008.47
    7/31/2009 7.74 27.85 14.28 7/31/2009 40039.28
    8/31/2009 6.82 21.17 15.45 8/31/2009 40071.45
    9/30/2009 7.23 24.73 14.86 9/30/2009 40100.86
    10/31/2009 7.41 22.16 14.71 10/31/2009 40131.71
    11/30/2009 7.67 23.92 14.93 11/30/2009 40161.93
    12/31/2009 6.94 28.17 15.03 12/31/2009 40193.03
    1/31/2010 6.84 25.68 14.98 1/31/2010 40223.98
    2/28/2010 7.01 26.12 15.22 2/28/2010 40252.22
    3/31/2010 7.34 26.86 15.36 3/31/2010 40283.36
    4/30/2010 7.22 25.99 15.67 4/30/2010 40313.67
    5/31/2010 7.38 26.45 15.46 5/31/2010 40344.46
    6/30/2010 7.55 26.62 15.51 6/30/2010 40374.51

    Investment Price Tot


    30 45000
    40000
    25
    35000
    20 30000
    25000
    15
    20000
    10 15000
    10000
    5
    5000
    0 0
    6/1/2009 9/1/2009 12/1/2009 3/1/2010 6/1/2010 6/1/2009 9/1/2009

    TeleCom (TC) State Bank (SB) United Retail (UR)


    Investment Price
    30

    25

    20

    15

    10

    0
    20

    15

    10

    0
    6/1/2009 9/1/2009 12/1/2009 3/1/2010 6/1/2010

    TeleCom (TC) State Bank (SB) United Retail (UR)


    stment Value / by Total investment value / each organization /
    month /
    Average Date TeleCom (TC) State Bank (SB) United Retail (UR)
    13336 TOTAL 94770 399972 293895
    13346 Average Value 7897.5 33331 24491.25
    13357
    13367
    13377
    13387
    13398
    13408
    13417
    13428
    13438
    13448
    13458

    Total Investment Value


    00
    00
    00
    00
    00
    00
    00
    00
    00
    0
    6/1/2009 9/1/2009 12/1/2009 3/1/2010 6/1/2010

    TOTAL Average

    You might also like