I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

User Documentation

The access structure to the database is fairly simple: There is a class of super users with write access. This is restricted to YOU only.

3.1 Super User with Read/Write Access

YOU are the owner and the only user with write access to the database. This can be reflected by a relevant AD group. This is not intended to be enhanced for other super users. YOU are responsible for all field definitions and for all feeds into the database. Later we might need to delete old unnecessary records, too. YOU are the only party to approve additional users or super users.

Please notice the limitations of this database:
•The database is not designed for mass storage
•The design is simple, field orientated. There is no support for curves or for surfaces – which means you cannot store nor retrieve curves or surfaces in one go. All points would have to be dealt with individually. This is possible but it creates quite an overhead to the database engine. So if this needs to be used it should only be temporary and not for mass storage
•Fields are stored as string values. The user needs to convert all data into the required data types

For the Excel write interface into the database refer to Appendix, Write Interface to Database.
 


3.2 Normal User with Read-Only Access

For the Excel read interface from the database refer to Appendix, Read Interface from Database. This can be reflected a the relevant AD group.


Examples to retrieve static information:

The Excel function call
=sb_get_param("BPIZC610","PX_CLOSE_1D","20110121","RILO")
would result in
29.205
Please note that this value is a string value! In order to get a number of type double you would need to convert the result yourself, for example:
=--sb_get_param("BPIZC610","PX_CLOSE_1D","20110121","RILO")

The Excel function call
=sb_get_param("FR0010850719","SECURITY_NAME","19000101","Bloomberg")
would result in
COFP4.379 02/17

Static data is stored with the date 1-Jan-1900. Please notice that the database would also have returned this result if you had called it with a younger date than that. This is because the sb_get_param function returns the youngest entry which is older or equal to the request date. You would need to use the sb_get_paramarray function to retrieve the complete database record (date included) to check the exact date of the returned value.

Example to retrieve market (dynamic) data:

The Excel function call
=sb_get_param_array("US172967EZ03","PRICE_MID","20101223","Xtrakter")
would result in
{"US172967EZ03","PRICE_MID","Xtrakter",40535,"102.172"}
Here 40535 is the numerical date of 23-Dec-2010.

Go back to Database Main Page

Sulprobil   Get it done   Contact   Disclaimer   Download