How to calcuate the MYRS strategy at the 15th of the month.

Home Forums Logical Invest Forum How to calcuate the MYRS strategy at the 15th of the month.

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #77384
    Mark Vincent
    Participant

    When MYRS is a sub strategy it rebalances twice per month therefore you need to know how many shares of each symbol you need to buy and sell. It gets more complicated if other strategies are using the same symbols.

    Here is what I do but if you have a better more efficient way let me know.
    1st of month MYRS TMF 0 UGLD 60 ZIV 40 and contributes 20% of total NAV
    15th of month MYRS TMF 0 UGLD 40 ZIV 60

    1. Multiple NAV by % MYRS contributes to the overall mega strategy
    2. Enter that value in Allocation tool using MYRS Strategy
    3. Set allocation tool to 1st trading day of month and calculate the shares contributed by MYRS for all Symbols
    4. Set Allocation tool to 15th of month and calculate shares for all symbols.
    5. The difference between step 3 and 4 is the shares you buy or sell for each Symbol that are only contributed by MYRS.

    I just use Excel to calculate the following formula.
    Shares for the Symbol 1st of the month – Shares for the Symbol 15th of the month = Shares to buy or sell for each Symbol
    Obviously the NAV at the 15th is not the same as the NAV at th 1st of the month but it should not make a big difference.

    Regards,
    MV

    #77385
    Mark Vincent
    Participant

    Correction to the steps you already own symbols from MYRS therefore the steps are:

    1. Multiple NAV by % MYRS contributes the overall mega strategy
    2. Enter that value in Allocation tool using MYRS
    3. Set Allocaiton tool to 15th of month and calculate shares for all symbols.
    4. The difference between what you already own (1st of the Month) and step 3 is the shares you buy or sell for each Symbol that are only contributed by MYRS.

    #77412
    Mark Vincent
    Participant

    Hoping for an easier way but I just realized that you can only use the shares you own at the 1st of the month when no other strategy uses MYRS symbols (UGLD, ZIV and TMF).

    Using the first method and the allocation tool to calculate MYRS at the 1st of the month and then on the 15th is the only way when 2 or more strategies require you to buy and sell (UGLD, ZIV and TMF).

    Regards,
    MV

    #77413
    Patrick
    Keymaster

    Technically, you should only rebalance the MYRS portion of your portfolio mid-month, but that is complicated because the MYRS allocation on the 15th will not be the same as your target allocation on the 1st. This method should be “correct”, although not particularly easy:

    1. On the 1st of the month, capture the share quantities attributed to MYRS by setting other strategies to 0% in the Allocation Tool.
    2. On the 15th, use the quantities from step 1 with current prices to calculate the current value of MYRS.
    3. Use MYRS value from step 2 as the “Investment Value” with MYRS allocated 100% to get current share quantities.
    4. Find the differences between step 1 and step 3 to determine new buys and sells.
    5. Rinse and repeat. :)

    Investing is not an exact science, so a close approximation should be fine.

    #77460
    Mark Vincent
    Participant

    Thanks Patrick,

    Just did it this month worked fine took a couple of minutes.

    Cheers,
    MV

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.