Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. res2 <- dbSendQuery(wrds, "select CUSIP, DATE, RET, RETX, VOL
  2. from CRSP.DSF
  3. WHERE DATE >= '2005-01-01' AND DATE <= '2019-04-01' AND CUSIP IN('09179710', '98252610', '69331C10')")
  4.  
  5. crsp.dsf2 <- dbFetch(res2, n = -1)
  6.  
  7. cusip <- c('09179710', '98252610', '69331C10')
  8.  
  9. res2 <- dbSendQuery(wrds, "select CUSIP, DATE, RET, RETX, VOL
  10. from CRSP.DSF
  11. WHERE DATE >= '2019-03-01' AND DATE <= '2019-04-01' AND CUSIP IN(cusip)")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement