Đang Thực Hiện

Excel VB Macro -- SEC filings FTP path lookup

Hi,

I would like an excel macro to lookup the ftp download path for SEC filings.

The SEC has created quarterly index files that list the path of each filing. The index file for each quarter is quite large (greater than 30 mb). I have downloaded the index files for the 1st quarter of 2011 and have attached them to this posting (zipped of course). The excel macro should parse through the index files all the way back through 2000. The remaining index files can be downloaded from via ftp at the below listed path.

[url removed, login to view]

The macro will take three inputs from an excel worksheet. Specifically, those will be:

1) Company Name

2) Year

3) Form Type (This is the type of filing, the inputs will in almost all cases be 10-K or 10-Q -- However, we should have the flexibility to use other inputs)

The macro should provide an output with the path of ALL filings that match the input criteria based on searching through the index files (In some cases there will be several matches).

The macro should be built to catch errors. Specifically, there will be cases where the company name does not exist in the index files. In this case it should return an error of Company not found.

All company names and CIK lookups are available from the below path (Note: CIK is an identifier that the SEC uses)

[url removed, login to view]

The macro should be stable enough to handle at least 1,000 input criteria at once.

More information on the SEC storage structure is available from [url removed, login to view]

I would need tohave the source doe for whatever solution is created.

Please do not hestiate to ask any questions in order to clarify these requirements.

Kỹ năng: Excel, Visual Basic

Xem thêm: excel macro ftp, sec ftp, edgar ftp, sec filings excel, download sec filings excel, edgar parse excel, sec filings edgar ftp files exist error, sec edgar index parse, quarterly ftp sec full index, macro ftp excel, macro download file ftp, excel sec filings, edgar download excel macro, sec filings ftp, parse sec, edgar filing excel, excel macro ftp download, sec edgar excel, sec filings download excel, www excel, we excel, vb note, type of use case, searching index of, return path

Về Bên Thuê:
( 3 nhận xét ) London, United States

Mã Dự Án: #1029527

Đã trao cho:

seanmdale

I've created a working solution for this, please see the private message for details and example. Ready to go ASAP. Thanks.

$150 USD trong 1 ngày
(5 Đánh Giá)
3.1

9 freelancer đang chào giá trung bình $190 cho công việc này

bharanisrihari

Hello, Excel VBA / Macro expert here. Please check PM for details. Thanks!

$250 USD trong 7 ngày
(64 Đánh Giá)
6.5
YashpalSingh123

.net/php experienced

$250 USD trong 3 ngày
(2 Đánh Giá)
4.0
bob12603

Please see my PM.

$175 USD trong 7 ngày
(2 Đánh Giá)
2.7
palinfotech

we have a team of 25 members with expertise in their profession. We have made a similar kind of projects. For further information please view your PMB. Ready to work with you Regards

$230 USD trong 5 ngày
(0 Đánh Giá)
0.0
JohnBHarris

I have stacks of experience developing VBA macros - or can provide Win32 DLL or Excel Add-in if excecution speed is important (a DLL or Add-In will run many times faster than a VBA macro). I have looked quite carefu Thêm

$225 USD trong 5 ngày
(1 Đánh Giá)
0.0
inkaTech

Hi, have lots of experience using VBA for multiple applications.

$250 USD trong 5 ngày
(0 Đánh Giá)
0.0
todsnewlife

I bid based on the details you provided. I might can do this cheaper and in less time, depending on what these files look like. My idea would be to import the data into an Excel template and provide you with a shortcut Thêm

$100 USD trong 14 ngày
(0 Đánh Giá)
0.0
eways

Sir I new to freelance and wants to start, i have the caliber to work on any type of projects, you can give a chance Thanx

$80 USD trong 31 ngày
(0 Đánh Giá)
0.0