search for: finra

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,...

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,...

I am trying to replicate the SAS proc univariate in R. I got most of the stats I needed for a by grouping in a data frame using: all1 <- ddply(all,"ACT_NAME", summarise, mean=mean(COUNTS), sd=sd(COUNTS), q25=quantile(COUNTS,.25),median=quantile(COUNTS,.50), q75=quantile(COUNTS,.75), q90=quantile(COUNTS,.90), q95=quantile(COUNTS,.95), q99=quantile(COUNTS,.99) )

Hello, I was wandering if it is possible to perform on a dataframe called 'all' a shapiro wilk normality test for COUNTS by variable Group ACTIVITY? Could it be done using plyer? I saw an eg that applies to an array but not to a dataframe: lapply(split(dataset1$Height,dataset1$Group),shapiro.test) Any thoughts would be much appreciated. My dataframe is in shape: dat ACTIVIT

...ate, local, and/or alternative minimum tax. In accordance with industry regulations, all messages are retained and are subject to monitoring. This message has been scanned for viruses and dangerous content and is believed to be clean. Securities offered through Cantella & Co., Inc., Member FINRA/SIPC. Home Office: 28 State St 40th Floor, Boston, MA 02109 Telephone: (800)652-8358

...ate, local, and/or alternative minimum tax. In accordance with industry regulations, all messages are retained and are subject to monitoring. This message has been scanned for viruses and dangerous content and is believed to be clean. Securities offered through Cantella & Co., Inc., Member FINRA/SIPC. Home Office: 28 State St 40th Floor, Boston, MA 02109 Telephone: (800)652-8358

Hello, I have a column called max_date in my data frame and I only want to keep the bigger values for the same activity. How can I do that? data frame: activity max_dt A 2013-03-05 B 2013-03-28 A 2013-03-28 C 2013-03-28 B 2013-03-01 Thank you for your help -- View this message in context:

...In accordance with industry regulations, all messages are retained > and are subject to monitoring. > This message has been scanned for viruses and dangerous content > and is believed to be clean. > Securities offered through Cantella & Co., Inc., Member > FINRA/SIPC. Home Office: 28 State St 40th Floor, Boston, MA 02109 > Telephone: (800)652-8358 <tel:%28800%29652-8358> > > -- Alvaro Lacerda Cantella IT Department Cantella & Co., Inc. (617)224-1415 -- The information transmitted is intended only for the person or entity to whic...

Hello, I have a variable in a data frame that contains NA values. I just want to subset so that I get the obs where that variable is missing. In SAS I would do: data missing; set test; if myvalue=' '; run; How can I perform this simple task in R? Thanks in advance for your help. -- View this message in context:

...ate, local, and/or alternative minimum tax. In accordance with industry regulations, all messages are retained and are subject to monitoring. This message has been scanned for viruses and dangerous content and is believed to be clean. Securities offered through Cantella & Co., Inc., Member FINRA/SIPC. Home Office: 28 State St 40th Floor, Boston, MA 02109 Telephone: (800)652-8358

Hello, I am trying to re-code all my programs from SAS into R. In SAS I use the following code: proc sort data=upper; by tdate stock_symbol expire strike; run; data upper1; set upper; by tdate stock_symbol expire strike; if first.expire then output; rename strike=astrike; run; on the following data set: tdate stock_symbol expiration strike 9/11/2012 C 9/16/2012

Hello, I am a newbie to R coming from SAS background. I am trying to program the following: I have a monthly data frame with 2 variables: client pct_total A 15% B 10% C 10% D 9% E 8% F 6% G 4% I need to come up w/ a monthly list of clients that make 50% or just above it every month so I can pass them to the rest of the program.

Hello, I have a dataframe w/ 3 variables of interest: transaction,date(tdate) & time(event_tim). How could I create a 4th variable (last_trans) that would flag the last transaction of the day for each day? In SAS I use: proc sort data=all6; by tdate event_tim; run; /*Create last transaction flag per day*/ data all6; set all6; by tdate event_tim; last_trans=last.tdate; Thanks

...sages. Wachovia Securities is the trade name used by two separate, registered broker-dealers and non bank affiliates of Wachovia Corporation providing certain retail securities brokerage services: Wachovia Securities, LLC, Member NYSE/SIPC, and Wachovia Securities Financial Network, LLC, Member FINRA/SIPC.

...VALUE Wachovia Securities is the trade name used by two separate, registered broker-dealers and nonbank affiliates of Wachovia Corporation providing certain retail securities brokerage services: Wachovia Securities, LLC, Member NYSE/SIPC, and Wachovia Securities Financial Network, LLC, Member FINRA/SIPC.

I am new to R and I have the following SAS statements: if otype='M' and ocond='1' and entry='a.Prop' then MOC=1; else MOC=0; How would I translate that into R code? Thanks in advance -- View this message in context: http://r.789695.n4.nabble.com/if-then-in-R-versus-SAS-tp4641225.html Sent from the R help mailing list archive at Nabble.com.

Hello, We lost our SAS licence & I am busy transfering my old SAS programs to R environment. I am very new to R. In 1 program I was creating SAS macro vars & passing them into a SQL query to run against the server. There are 3 variables firm, begindt, enddt. # of values for each varies month to month. Is there anyway I could do the same thing in R & pass the afore mentioned values

Hello, I know how to increment a date by calendar date: ticker$ldate <- ticker$tdate + days(5) How do I increment it by business days only so that week-ends are not counted? So for example friday november 2 + 5days becomes friday november 9 & not wednesday nov 7. Thanks for your help. -- View this message in context:

Hello all, I have a question: I am using the interquantile method to spot outliers & it gives me values of say 234 & -120 or for the higher & lower benchmarks. I don't have any issues w/ the higher end. However I don't have any negative values. My lowest possible value is 0. Should I consider 0 as an outlier? Thanks ahead for your thoughts -- View this message in

...mum > tax. > > In accordance with industry regulations, all messages are retained and are > subject to monitoring. > This message has been scanned for viruses and dangerous content and is > believed to be clean. > Securities offered through Cantella & Co., Inc., Member FINRA/SIPC. Home > Office: 28 State St 40th Floor, Boston, MA 02109 > Telephone: (800)652-8358 > >