Serving the Quantitative Finance Community

Search found 4 matches

by ilscot
July 12th, 2021, 9:10 pm
Forum: General Forum
Topic: Changes in S&P 500 components
Replies: 1
Views: 2517

Changes in S&P 500 components

This has probably been asked before; however, I cannot find a close answer. QUEST:  I would like a list of the historical changes to the S&P 500 components (I do not care about the cap-weights) since 1960.   symbol, company name, date change announced, and effective change date , action (added /...
by ilscot
December 1st, 2020, 5:37 pm
Forum: Student Forum
Topic: need to extract pages from a pdf based on content
Replies: 2
Views: 5926

Re: need to extract pages from a pdf based on content

answering my own question (months later) per many trial/error:  Economical and importantly - effective - commercial apps are available (vs the Adobe 'solution').  If interested, contact me privately to avoid a commercial endorsement issue. In addition, newer versions of Excel can (with some creative...
by ilscot
December 1st, 2020, 5:23 pm
Forum: Student Forum
Topic: VBA cycle web queries through URLs
Replies: 0
Views: 5156

VBA cycle web queries through URLs

so, this cannot be a new idea and I am certain I am missing something trival... I wish to cycle through several urls and grab specific tables from each page (in Excel)   I can do this manually in Excel using the Data=>Web Query tool   I can record a macro to do this   I can change the string referri...
by ilscot
August 22nd, 2020, 10:55 pm
Forum: Student Forum
Topic: need to extract pages from a pdf based on content
Replies: 2
Views: 5926

need to extract pages from a pdf based on content

Good morning,   I need to extract pages from a (many 1000s) page pdf based on the content of the page   some pages have transaction detail   some pages have open position detail   some pages have accounting detail (margins, etc)   Once extracted, I would like to save the extracted pages as a single ...