Creating Variable names from strings

Question

Sanjay 2012-3-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31139-creating-variable-names-from-strings

Hi: I am a new user so apologies for any stupid questions.

Here is what I am seeking to do

1. Read a XLS file with 1 column and 50 rows of ticker name 2. Go through this matrix in MATLAB cell by cell and create a variable in the MATLAB workspace that will hold the price data of this variable, pulled from yahoo.

I can do 1. However, I need help in achieving the "create variable" part of 2. I read and tried "genvarname" function, but still no success.

Can anyone here please help me with this.

Many thanx

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2012-3-4

Please post what you have done and explain "no success" with details.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2012-3-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31139-creating-variable-names-from-strings#answer_39616

For #1, simply call xlsread() like it sounds like you are doing.

#2 is not advised - see the FAQ http://matlab.wikia.com/wiki/FAQ#How_can_I_create_variables_A1.2C_A2.2C....2CA10_in_a_loop.3F

Just keep your prices in the array. If your workbook has both the prices and tickername, you can go down the cell array and convert to an array of structures if you think that would be easier.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Sanjay 2012-3-4

Thank you. I appreciate the heads up. Reading that FAQ now.

Best

请先登录，再进行评论。

Answer 2

Jan 2012-3-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31139-creating-variable-names-from-strings#answer_39615

在 MATLAB Online 中打开

I suggest not to use eval to create the variables directly in the current workspace, because this can conflict (beside other problems) with other variables, which are defined already.

Better store the variables as fields of a struct:

for iColumn = 1:n
  S.(genvarname(Name{iColumn})) = Data{iColumn};
end

"Name" and "Data" depend on the format of your input data.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 3

Rick Rosson 2012-3-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31139-creating-variable-names-from-strings#answer_39617

在 MATLAB Online 中打开

Don't worry about making them variable names. The easiest thing to do is to read the ticker symbols in as a cell array of strings. For more info:

>> doc xlsread

HTH.

5 个评论
显示 3更早的评论隐藏 3更早的评论

Rick Rosson 2012-3-5

Sanjay: Walter, Jan, Image Analyst, and I are all very experienced MATLAB programmers. All four of us have independently recommended against using the ticker symbols as variable names. We have each proposed various alternative ways to organize the data. You are free to do what you want, but please consider following our advice. Thanks!

Walter Roberson 2012-3-5

Each time I take on a major project, I spend the first several *years* re-writing the code to eliminate the unsustainable code the previous generations of programmers had put in.

You know what that _feels_ like to a skilled and creative programmer working for years to clean up code? If feels like one has been sent to the basement to clean all of the walls and storage rooms and duct-work with a small wire tooth-brush, having to derive one's entire satisfaction out of knowing that one has postponed the critical rust and mold spots for another 5 years -- as no-one else will give a care beyond thinking you've been a waste of company salary.

So, please do graying maintenance programmers everywhere a favor and design your programs to make it easy for those who will come after you in debugging and enhancing and extending your programs.

请先登录，再进行评论。