Messages In This Digest (4 Messages)

Messages

1a.: Russell 2000 components

Posted by: "peter_sagg" boropeter@hotmail.com peter_sagg

Sat Nov 19, 2011 2:32 pm (PST)

I am trying to get Russell 2000 components on a daily basis. Not sure if that's possible to be done, couldn't find any previous topics like that. Can you please advise if that's possible to be done at all?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
1b.: Re: Russell 2000 components

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Sat Nov 19, 2011 2:38 pm (PST)

You can get the month-end components list from the iShares website with:

=smfGetCSVFile("
http://us.ishares.com/product_info/fund/excel_holdings.htm?ticker=IWM&periodCd=m
")

Daily holdings are available with a free registration. I haven't
registered, so I'm not aware of the specifics:

http://us.ishares.com/product_info/fund/overview/IWM.htm

On Sat, Nov 19, 2011 at 2:33 PM, peter_sagg <boropeter@hotmail.com> wrote:

> I am trying to get Russell 2000 components on a daily basis. Not sure if
> that's possible to be done, couldn't find any previous topics like that.
> Can you please advise if that's possible to be done at all?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2a.: smf-elements-9.txt

Posted by: "almondtree" almondtree@yahoo.com almondtree

Sat Nov 19, 2011 8:57 pm (PST)

Works in progress file click on .txt goes notepad do I copy this into old .txt file. I'm baffled.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
2b.: Re: smf-elements-9.txt

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Sat Nov 19, 2011 9:12 pm (PST)

Just download the file and use it to replace the smf-elements-9.txt file in
the folder containing the add-in files.

After that, you'll either need to run the smfForceRecalculation macro or
exit and re-enter EXCEL to have the add-in load up the update element
definitions.

On Sat, Nov 19, 2011 at 9:57 PM, almondtree <almondtree@yahoo.com> wrote:

> Works in progress file click on .txt goes notepad do I copy this into old
> .txt file. I'm baffled.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

Messages | Files | Photos | Polls

MARKETPLACE