JudahRaion
New Member
- Joined
- Oct 13, 2011
- Messages
- 20
Good Afternoon,
I have this information:
A
[TABLE="width: 466"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]1 ISIN[/TD]
[TD]Name[/TD]
[TD]Sector[/TD]
[/TR]
[TR]
[TD]CA1535011011[/TD]
[TD]Central Fund Canada CL A[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CA44045F1190[/TD]
[TD]Horizons Betapro Nymex Natur[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0HGZR1[/TD]
[TD]IShares MSCI World UCITS[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H0728[/TD]
[TD]Ishares DJ-UBS SW[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H0769[/TD]
[TD]DJ Stoxx 600 Amer RL Est EX[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H0777[/TD]
[TD]DJ Stoxx 600 Asia RL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H08K7[/TD]
[TD]Ishares Stoxx 600 Ins DE[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
And I want to put in the third row an information displayed at MorningStar - MorningStar Commodity.
I have the search links in D2 until the end:
[TABLE="width: 752"]
<tbody>[TR]
[TD="class: xl65, width: 752"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
</tbody>[/TABLE]
I have almost 400 ETF to do this and is a pain to do one-by-one.
Thank you
Regards,
JD
I have this information:
A
[TABLE="width: 466"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]1 ISIN[/TD]
[TD]Name[/TD]
[TD]Sector[/TD]
[/TR]
[TR]
[TD]CA1535011011[/TD]
[TD]Central Fund Canada CL A[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CA44045F1190[/TD]
[TD]Horizons Betapro Nymex Natur[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0HGZR1[/TD]
[TD]IShares MSCI World UCITS[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H0728[/TD]
[TD]Ishares DJ-UBS SW[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H0769[/TD]
[TD]DJ Stoxx 600 Amer RL Est EX[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H0777[/TD]
[TD]DJ Stoxx 600 Asia RL[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]DE000A0H08K7[/TD]
[TD]Ishares Stoxx 600 Ins DE[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
And I want to put in the third row an information displayed at MorningStar - MorningStar Commodity.
I have the search links in D2 until the end:
[TABLE="width: 752"]
<tbody>[TR]
[TD="class: xl65, width: 752"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
[TR]
[TD="class: xl65"]Share Prices | Fund Prices and Data | Morningstar[/TD]
[/TR]
</tbody>[/TABLE]
I have almost 400 ETF to do this and is a pain to do one-by-one.
Thank you
Regards,
JD
Last edited: