2

I use R a lot to process the financial data, e.g. cds spreads, correlation of tranche data, time series... ...

Now I have periodic data update from bloomberg via email, and all the data are text only in the email (NOT as an attachment file), I wanna write a function to read data from them (hundreds of emails, with .msg extention), and save into excel.

Does any one have any hint on how to read the data? I prefer R, but C++ also works if R cannot do it.

Here is the format of the email (part of):>>>>>

$$ JPM CDX OPTIONS: HY19 AUG Expiry  UPDATE - REF 102⅜[~354bp]
               BOND PUT          BOND CALL
 K [~Sprd]|SEP13>PAY   Dlt |SEP13>RCV   Dlt |MidVol [SprdVol]
108 [313] |  355 365   92% |    5 13     8% |  5.4% [ 40%]
107 [335] | 243½253½ 85% |   23 36    17% |  7.8% [ 33%]
106 [369] |  203 213   77% |  52½62½  28% |  7.1% [ 34%]
105 [387] |  147 167   59% |  99½116½ 41% |  9.3% [ 46%]
simeonyyyyyy
  • 87
  • 8

1 Answers1

2

Here is a good start:

email  <- "$$ JPM CDX OPTIONS: HY19 AUG Expiry  UPDATE - REF 102⅜[~354bp]
               BOND PUT          BOND CALL
 K [~Sprd]|SEP13>PAY   Dlt |SEP13>RCV   Dlt |MidVol [SprdVol]
108 [313] |  355 365   92% |    5 13     8% |  5.4% [ 40%]
107 [335] | 243½253½ 85% |   23 36    17% |  7.8% [ 33%]
106 [369] |  203 213   77% |  52½62½  28% |  7.1% [ 34%]
105 [387] |  147 167   59% |  99½116½ 41% |  9.3% [ 46%]"
email
ll <- readLines(textConnection(email))
mm <- read.table(text=ll[-c(1,2)],sep='|',header=TRUE)

  K...Sprd.  SEP13.PAY...Dlt  SEP13.RCV...Dlt MidVol..SprdVol.
1 108 [313]    355 365   92%      5 13     8%       5.4% [ 40%]
2 107 [335]     243½253½ 85%     23 36    17%       7.8% [ 33%]
3 106 [369]    203 213   77%      52½62½  28%       7.1% [ 34%]
4 105 [387]    147 167   59%      99½116½ 41%       9.3% [ 46%]
agstudy
  • 119,832
  • 17
  • 199
  • 261
  • Thanks for the reply. I think I didn't make it clear. What I have to deal with is a .msg file, which is an email format from MSFT (I guess). The data I need (and shown above) is the data in the email body. However, I don't have a good way to read the data from the email. I don't know how to open .msg file and read data from it with R or C++. If I use wordpad to open the .msf file, it looks messy – simeonyyyyyy Jul 19 '13 at 16:05
  • @user2596245 I think you should just replace `ll <- readLines(textConnection(email))` by `ll <- readLines("email.msg)` – agstudy Jul 19 '13 at 17:44
  • I did, but it does not work. :( here is the snapshot [link](https://www.dropbox.com/s/tiqj1bctguvh6n4/msgFile.jpg) – simeonyyyyyy Jul 19 '13 at 19:41