Navigation

Search

Categories

On this page

Product Coding Scheme in RiskLib.NET
WSJ, Yahoo!Finance, and Bloomberg datasource added to RiskLib.NET with examples
The first part of RiskLib.NET uploaded: DataSource and Product namespace
Project RiskLib.NET launched

Archive

Blogroll

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

RSS 2.0 | Atom 1.0 | CDF

Send mail to the author(s) E-mail

Total Posts: 82
This Year: 0
This Month: 0
This Week: 0
Comments: 32

Sign In
Pick a theme:

 Wednesday, February 25, 2009
Wednesday, February 25, 2009 8:42:47 PM (台北標準時間, UTC+08:00) ( .NET Programming | Quant's Life | RiskLib )

Rules of RiskLib Product Coding Scheme

Why Product Coding Scheme

If your company participates many markets and investment instruments, it is very difficult to consolidate so many different sources of market and position data. For example, if you trade US stocks only, you might have IBM stored in a field in your closing price and position tables. But after your portfolio extended into European markets, which are using alphabet as stock code, you will find it is not a good idea to just store the US stock code as a unique key in the table. For many Asian stock markets, including Japan, Hong Kong, Korea, and Taiwan, they are using numbers as stock code.

For fixed-income instruments, that is a more complicated case. Although all issues of bonds have ISIN (International Securities Identification Number), there are still many indices or interests rates have no common coding. ISIN is a good choice for bonds, but we need more.

Global futures market has its own coding scheme, I prefer to use Reuters' codes.

Product Coding Scheme is for Assets or Indices only, not for OTC or derivatives trades

Please note only standard assets (securities or indices) need standardized coding. Over-the-Counter or derivatives trades are usually one of a kind for each trade and is not necessary to define in a coding scheme.

Product Coding Scheme Used in Current Systems

I will introduce coding scheme used in Reuters and Bloomberg later.

Objective of RiskLib Product Coding Scheme

Where is a perfect coding scheme? I don't know. I think a good coding scheme is a key of good risk management system, unless your portfolio is simple and local. I think a good coding scheme should have the following attributes:
  • short
  • product type can be recognized from the code itself
  • connect to offical system

Wednesday, February 25, 2009 7:51:59 PM (台北標準時間, UTC+08:00) ( .NET Programming | Quant's Life | RiskLib )
I added 3 datasource to RiskLib.NET to demostrate how to implement two different interface: IDailyClosingSource, IHisotricalSource, and a special designed datasource: Bloomberg. I also added a example to retrieve data from these datasources.

Although there are still a lot should be modified, the example worked fine to retrieve data from these datasource.

 Tuesday, February 24, 2009
Tuesday, February 24, 2009 9:12:30 PM (台北標準時間, UTC+08:00) ( .NET Programming | Quant's Life | RiskLib )
THe first part of RiskLib.NET source code has been uploaded to codeplex.com. It contains ready for use source code in namespace DataSource and Product. Although not all the code of these two namespace is finished, these are codes that might not be change until next major release.

The RiskLib.DataSource is designed to contain flexible and extensible classes for various financial information sources. A Bloomberg datasource implementation has been included. Bloomberg Professional Services is a very good source for informations for investment. I will include a working example using Bloomberg class to retrieve daily closing and real-time data. Please note: You must have a Bloomberg Professional Service terminal to use this class.

The RiskLib.Product contains object model for some basic financial product. This namespace might have some modification but not expected huge.

 Friday, February 20, 2009
Friday, February 20, 2009 5:42:10 AM (台北標準時間, UTC+08:00) ( .NET Programming | Quant's Life | RiskLib )
I created a new project named RiskLib.Net on Codeplex.com.

After developing software for financial industry for more than 10 years, I plan to develope an open source .NET library for derivatives and risk management. It is just started without any code. I invite anyone who have interests to join it.

Please visit the following link to see the project:
http://www.codeplex.com/risklib