multiple portfolio doesn't seem to work about tidyquant HOT 2 CLOSED

@jonross09
Thanks for submitting. Can you upload your .R file so we can reproduce? It's difficult to tell everything that you are doing.
-Matt

from tidyquant.

Hi @jonross09
I was looking into this again. There's a few issues that I see from the warnings:

First, there appears to be an issue with your weights table. If the assets (stock symbols) exist in the weights table that doesn't existing in the stocks table then you will get an error.

Second, you have a portfolio index column in your weights table, but you don't have a portfolio index column in your stocks (d2) table. This means your weights table is setup for multiple portfolios but your stocks table is setup for single portfolio. Since it only looks like you have one portfolio, you could just drop the portfolio column from your weights table and it should work.

Some background on the "portfolio" column: This index column with key name "portfolio" is used as a key for mapping multiple portfolios. Because of this, the key must be present in both tables and you must also group by portfolio in your stocks table since you are using the multiple portfolio method.

Last, I see that you have col_rename = FALSE. You probably just want to leave out col_rename or set it to col_rename = NULL.

from tidyquant.