Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 107
  • Last Modified:

Excel VBA to extract Instance URLs

Hi,
Would appreciate very much your assistance with an Excel VBA code ( version 2010 ) to extract a list of Instance URLs for all the 10-K filings from the SEC Edgar website for a particular entity ( e.g. its CIK  reference = 0000078003 )

The site is: https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000078003&type=10-K&dateb=&owner=exclude&count=20; and when manually extracted the required results of a list of Instance URLs are as follows:
https://www.sec.gov/Archives/edgar/data/78003/000119312510042425/pfe-20091231.xml
https://www.sec.gov/Archives/edgar/data/78003/000119312511048877/pfe-20101231.xml
https://www.sec.gov/Archives/edgar/data/78003/000119312512085703/pfe-20111231.xml
https://www.sec.gov/Archives/edgar/data/78003/000007800313000006/pfe-20121231.xml
https://www.sec.gov/Archives/edgar/data/78003/000007800314000018/pfe-20131231.xml

Would appreciate your assistance with a VBA routine to parse the list programmatically.

Many thanks

=====================
Prior related question: http:Q_28497353.html
0
Russellbrown
Asked:
Russellbrown
1 Solution
 
aikimarkCommented:
I don't see pfe-20091231.xml anywhere in the returned source text.
0
 
Computer EggheadCommented:
Hi Russell,

1) The page you supplied periodically changes.  Therefore, we would need to know why you wanted those particular URLs returned.

2) This site is to help people with their questions, like what you have tried and how you are stuck.  Your question is more like asking someone to provide you a solution for free.
0
 
aikimarkCommented:
there are also several EE experts who have enabled their Hire Me links.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Computer EggheadCommented:
@aikimark, Yes, and note that those Hire Me links are only available to Premium members.

@Russellbrown, Note that someone edited my answer without consulting me.  In #2 of my answer, I suggested you contact a freelancer to assist you.  You can do that on this site or another, but I am not allowed to recommend any in this comment.  If I was, I could be more helpful to you.
0
 
RussellbrownAuthor Commented:
@Computer Egghead,
Thank you for your guidance. I have researched the question and have surfed the net extensively to get some pointers. I was not quite able to put my head around the issue and therefore posted the question as a follow up to an earlier question trusting that there might already be an answer to it.  It appears that I will need to do more research and get it up to speed and as suggested tried out the codes and narrow down the issues and revert when stuck.

@aikimark, noted with thanks. I will revert after I have made further progress.

Many thanks.
0
 
Martin LissRetired ProgrammerCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now