›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Rebalance Portfolio with new money added

qosmioamitqosmioamit
in Suggestions
Does anybody know how I can do portfolio rebalance with new money added?

Currently, PS suggests the rebalance based on the current account status, but I would like to know how to rebalance when I want to invest say $1000.

My current workaround has been to add cash to an account and then refresh the workbook to learn the suggested rebalance. Is there a better way perhaps? This is an attempt to reduce "SELL" transactions, as my brokerage allows buying ETFs for free

Comments

  • VidasMatelisVidasMatelis
    edited March 2019
    Hi,

    I do exactly like you - first I deposit cash, refresh data and then see where money should be invested. I do not sell, just add money to symbol that is most out of balance.
    For faster refreshing, I always use PowerBI instead of Excel.
  • qosmioamitqosmioamit
    PowerBI does refresh faster, but in order to add the hypothetical cash, I still need to add the entries to the srcTrans worksheet in the workbook. And then run a refresh on the workbook. Finally, I run a refresh on PowerBI for publishing the data to the web.

    Is there a quicker way?
  • VidasMatelisVidasMatelis
    Hi,

    There is no better way to do this with provided reports. But, because these reports are in Excel, you can easily add your on Excel calculations.
    Copy allocation report data to separate workbook and use Excel formulas to calculate how additional deposits should be used.
Sign In or Register to comment.