求很多變數的最大值

不好意思   我實在不知道該怎麼用陣列取代變數

//以下epsknown 是我自訂的函數  輸入日期就可以知道近四季的eps加總

然後averagemonth 也是我自訂的函數   輸入日期就可以知道當月份的月均價

 

 

 

////eps

value1=epsknown(20220331);

value2=epsknown(20220631);

value3=epsknown(20220931);

value4=epsknown(20221231);

value5=epsknown(20230331);

value6=epsknown(20230631);

value7=epsknown(20230931);

value8=epsknown(20231231);

value9=epsknown(20240331);

value10=epsknown(20240631);

value11=epsknown(20240931);

value12=epsknown(20241231);

value13=epsknown(20250331);

value14=epsknown(20250631);

 

////2022月均

value20=averagemonth(20220101,20220131);

value21=averagemonth(20220201,20220231);

value22=averagemonth(20220301,20220331);

value23=averagemonth(20220401,20220431);

value24=averagemonth(20220501,20220531);

value25=averagemonth(20220601,20220631);

value26=averagemonth(20220701,20220731);

value27=averagemonth(20220801,20220831);

value28=averagemonth(20220901,20220931);

value29=averagemonth(20221001,20221031);

value30=averagemonth(20221101,20221131);

value31=averagemonth(20221201,20221231);

 

////2023月均價

value40=averagemonth(20230101,20230131);

value41=averagemonth(20230201,20230231);

value42=averagemonth(20230301,20230331);

value43=averagemonth(20230401,20230431);

value44=averagemonth(20230501,20230531);

value45=averagemonth(20230601,20230631);

value46=averagemonth(20230701,20230731);

value47=averagemonth(20230801,20230831);

value48=averagemonth(20230901,20230931);

value49=averagemonth(20231001,20231031);

value50=averagemonth(20231101,20231131);

value51=averagemonth(20231201,20231231);

 

////2024月均價

value60=averagemonth(20240101,20240131);

value61=averagemonth(20240201,20240231);

value62=averagemonth(20240301,20240331);

value63=averagemonth(20240401,20240431);

value64=averagemonth(20240501,20240531);

value65=averagemonth(20240601,20240631);

value66=averagemonth(20240701,20240731);

value67=averagemonth(20240801,20240831);

value68=averagemonth(20240901,20240931);

value69=averagemonth(20241001,20241031);

value70=averagemonth(20241101,20241131);

value71=averagemonth(20241201,20241231);

 

//2025月均價

value80=averagemonth(20250101,20250131);

value81=averagemonth(20250201,20250231);

value82=averagemonth(20250301,20250331);

value83=averagemonth(20250401,20250431);

value84=averagemonth(20250501,20250531);

value85=averagemonth(20250601,20250631);

value86=averagemonth(20250701,20250731);

value87=averagemonth(20250801,20250831);

value88=averagemonth(20250901,20250931);

 

 

////月本益比

value100=value20/value1;

value101=value21/value1;

value102=value22/value1;

value103=value23/value2;

value104=value24/value2;

value105=value25/value2;

value106=value26/value3;

value107=value27/value3;

value108=value28/value3;

value109=value29/value4;

value110=value30/value4;

value111=value31/value4;

value112=value40/value5;

value113=value41/value5;

value114=value42/value5;

value115=value43/value6;

value116=value44/value6;

value117=value45/value6;

value118=value46/value7;

value119=value47/value7;

value120=value48/value7;

value121=value49/value8;

value122=value50/value8;

value123=value51/value8;

value124=value60/value9;

value125=value61/value9;

value126=value62/value9;

value127=value63/value10;

value128=value64/value10;

value129=value65/value10;

value130=value66/value11;

value131=value67/value11;

value132=value68/value11;

value133=value69/value12;

value134=value70/value12;

value135=value71/value12;

value136=value80/value13;

value137=value81/value13;

value138=value82/value13;

value139=value83/value14;

value140=value84/value14;

value141=value85/value14;