现有一个列表,形如:
Name | SecId |
ABC QDII BRIC Equity USD | F000000R86 |
ABC-CA Bal Double Interest Mixed Type | F000002PDF |
ABC-CA China Securities 500 Index Fd | F00000N9TF |
ABC-CA Consumption Theme Equity Fd | F00000NZ5P |
ABC-CA Credit Bond | F00000O9PE |
ABC-CA CSI 300 Index Fd | F00000M8U5 |
ABC-CA Increasing Income Bond A | F00000MIPT |
ABC-CA Increasing Income Bond C | F00000MIPU |
任务:1)针对左侧的每一个基金,新建一个工作表,共需建立1550个左右,并且将对应的SecId命名给新建工作表,
2)在每个新建的工作表A1格中执行如下命令(=MSHOLDING("
F000002PDF;FO","SECID","10/1/2009","9/30/2012","Freq=A,HT=all,mv=true,name=true")),红色部分需要根据每个基金进行修改,上面是以第二个为例。
先拜谢各位高人了!请教怎么解决!急!