Loading Bloomberg Api Data Using VBA Access Program

Question

Hi Friends,

we have subscription to Bloomberg data, we use excel to load data from bloomberg using bdp function. but its pain,so we decided to find easy way to do this . Is there any way to program and calculate Fixed Income Chars from a list of securities using VBA ,access,sql or anything.?

Thanks

Answer 1

Yes. You need to use either VBA automation to do this in excel, or write directly to the c api.

Answer 2

If you're using Excel VBA already then it will be quite easy to copy and paste the code into Access VBA. You will then need to make appropriate changes to insert records rather than inserting cells. If using DAO you will want to use code similar to the following to add the records.

    Set rs = CurrentDb.OpenRecordset("Customer")
    rs.AddNew
    rs!cName = NewData
    rs.Update
    rs.Move 0, rs.LastModified
    CustomerID = rs!cID
    rs.Close: Set rs = Nothing

The rs.move 0 line fetches the autonumbr key of the record just added should you need it to insert child records.

Answer 3

Hello, where in the code would one place this?