is there an equivalent vlookup formula excel in matlab of a string?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have the following matrix:
Stock_1 Stock_2 ..... Stock_n
23.5 25.8 29.6
24.5 85.5 ........ 59.2
.... .... ....
A matrix (nxn), where in the first row ther'is the name of stocks, and in the other row the historical price. Then, I have another matrix of pair of stocks, for example:
Stock_1 Stock_2
Stock_3 Stock_5
...... ......
and so on.... I want a for loop that give me for all pair the respective stock prince. For example for the first pair: Stock_1 Stock_2 I want to extrapolate the following matrix:
Stock_1 Stock_2
23.5 25.8
24.5 85.2
and so on. Thxs
1 Kommentar
Marc
am 10 Apr. 2016
Do you have a matrix or are you using a table?
If you have never used a table, I would recommend trying it for this type of data setup.
Antworten (1)
Siehe auch
Kategorien
Mehr zu Multidimensional Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!