The others may end up with 0% because there is no "Illinois" string on the web pages. However, BIE has a top holding of: Illinois St Toll Hwy Auth 5.5% 5.50 01rharmelink
Randy - I use the following to pull the percent of bonds that are issued by the state of Illinois.hashky
Thanks Randy for your reply. Got to make a macro then.nicolasanchoa
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
The add-in is maintained using EXCEL 2007 under a Vista operating system using U.S. regional settings, so other platforms and/or versions may have issues. No Mac. No Open Office.
If you're reporting a problem, remember that I'm not a mind reader -- "It doesn't work right" is not a helpful description of a problem. Please try to include relevant information, such as:
-- The specific function(s) or template(s) you are having problems with.
-- The parameter(s) you are using with the function(s).
-- The version of EXCEL you use.
-- The operating system you're running EXCEL under.
-- The steps you took to try to resolve the problem.
-- The ticker symbols or URLs that are being used.
-- The results you expect to get and what you actually get.
Note that emails sent directly to me typically end up in my SPAM folder and never get read, so send your questions and issues to this Yahoo group.
- Jun 18, 2006
- This is a public group.
- Attachments are permitted.
- Members cannot hide email address.
- Listed in Yahoo Groups directory.
- Membership does not require approval.
- Messages from new members require approval.
- All members can post messages.