Replacing non-numerical values in a matrix with corresponding numerical values from another matrix with header

2 次查看（过去 30 天）

显示更早的评论

Natalia Soloviova 2020-4-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/520292-replacing-non-numerical-values-in-a-matrix-with-corresponding-numerical-values-from-another-matrix-w

编辑： Natalia Soloviova 2020-4-23

Hi!

I'll be very grateful if you ca help me with this issue which I even don't know how to ask for searching.

I have 2 Tables (in Excel for the moment):

1) One with the stock prices, more than 800 stocks for around 200 periods (like the grey table), and

2) One table with the portfolios holdings for the same number of periods — up to 20 random stocks which prices are somewhere in the big table with prices. (like the blue table)

I need to have a code to replace the stock name with the corresponding stock price in each period and have a resulting table as it is shown in the green table.

Thanks a lot for any help.

Simplified examples: