is there an equivalent vlookup formula excel in matlab of a string?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commento
Marc
il 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.
Risposte (1)
Vedere anche
Categorie
Scopri di più su Multidimensional Arrays in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!