Hi. I'm trying to write an application to retrieve financial data (specially bonds data) from FINRA. The web page is served dynamically from an asp.net application: http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/AdvancedScreener.aspx I'd like to know if it's possible to fill dynamically the web page form from R and, after filling it (with the issuer name), retrieve the web page, parse the data, and covert it to appropiate R objects. For example, suppose I want to search data for AT&T bonds. I'd like to know if it's possible, within R, to fill the page served from: http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/AdvancedScreener.aspx select the "corporate" option and fill with AT&T the field for "Issuer name", ask the page to display the results, and retrieve the results for each of the bonds issued by AT&T (for example: http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MDAxOTU3Qko3) and parsing the data from the web page. Thanks in advance.
Hi Jose, I think this is more of an r-help question so I'm going to forward your question there: R-devel is really for the development of R itself, not development with R. Cheers, Michael On Mon, Oct 29, 2012 at 8:11 PM, jose ramon mazaira <jramaza at gmail.com> wrote:> Hi. I'm trying to write an application to retrieve financial data > (specially bonds data) from FINRA. The web page is served dynamically > from an asp.net application: > > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/AdvancedScreener.aspx > > I'd like to know if it's possible to fill dynamically the web page > form from R and, after filling it (with the issuer name), retrieve the > web page, parse the data, and covert it to appropiate R objects. > For example, suppose I want to search data for AT&T bonds. I'd like to > know if it's possible, within R, to fill the page served from: > > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/AdvancedScreener.aspx > > select the "corporate" option and fill with AT&T the field for "Issuer > name", ask the page to display the results, and retrieve the results > for each of the bonds issued by AT&T (for example: > > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MDAxOTU3Qko3) > > and parsing the data from the web page. > > Thanks in advance. > > ______________________________________________ > R-devel at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-devel
I don't know of an easy way to do this in R. I've been doing something similar with python scripts called from R. If anyone knows how to do this with just R, I would appreciate hearing too. Paul On 12-10-29 04:11 PM, jose ramon mazaira wrote:> Hi. I'm trying to write an application to retrieve financial data > (specially bonds data) from FINRA. The web page is served dynamically > from an asp.net application: > > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/AdvancedScreener.aspx > > I'd like to know if it's possible to fill dynamically the web page > form from R and, after filling it (with the issuer name), retrieve the > web page, parse the data, and covert it to appropiate R objects. > For example, suppose I want to search data for AT&T bonds. I'd like to > know if it's possible, within R, to fill the page served from: > > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/AdvancedScreener.aspx > > select the "corporate" option and fill with AT&T the field for "Issuer > name", ask the page to display the results, and retrieve the results > for each of the bonds issued by AT&T (for example: > > http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MDAxOTU3Qko3) > > and parsing the data from the web page. > > Thanks in advance. > > ______________________________________________ > R-devel at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-devel >