Thursday, March 30, 2006
Thursday, March 30, 2006 1:27:13 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Thursday, March 30, 2006 7:20:32 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Tuesday, March 28, 2006

Is similar to Wikipedia but contains only business information.

http://wikicompany.org/wiki/Wikicompany:Wikicompany_v_Wikipedia

My current client, ABN AMRO, is company of the day

http://wikicompany.org/wiki/Main_Page

Tuesday, March 28, 2006 2:01:26 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Tuesday, March 28, 2006 8:13:36 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Wednesday, March 22, 2006

There are numerous vendors offering different types of CDS data. Below are my findings so far (note that this is a work in progress)

Name Single name Indices Sell Side Buy Side Market data Trade confirmation Intra day API Website
Markit Y Y Y Y Y N N www.markit.com
CreditEx RealTime Y Y Y N Y N Y Y http://www.creditex.com/web/index.html
Swapswire Y Y Y Y N Y Y http://www.swapswire.com/
GFI CreditMatch Y Y http://www.gfigroup.com/portal/index.jsp
Tradeweb Y Y Y Y Y http://www.tradeweb.com/
MarketAxess Y Y Y Y http://www.marketaxess.com/
Bloomberg (terminal) Y Y Y Y Y N Y http://www.bloomberg.com/RBB3.htm
Bloomberg emails Y Y Y Y Y N Y http://www.bloomberg.com/RBB3.htm

 

Links:

http://www.creditmag.com/public/showPage.html?page=314658

Wednesday, March 22, 2006 1:57:48 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Tuesday, March 21, 2006
Tuesday, March 21, 2006 3:19:37 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
  • I've signed up for the TFL service giving SMS texts when there is a delay on your chosen route(s) (2 free texts a day)

http://alerts.tfl.gov.uk/

  • This link shows how the underground may look 10 years from now

http://www.tfl.gov.uk/tfl/downloads/pdf/press-releases/putting-transport-onthemap.pdf

link found in

http://owen.massey.net/tubemaps.html

  • History of the Underground including disused stations

http://www.underground-history.co.uk/cutncover.php

Tuesday, March 21, 2006 10:07:58 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Monday, March 20, 2006

http://msdn.microsoft.com/security/securecode/threatmodeling/acetm/

This was formally ACE Torpedo and appears to have been around for a while

http://www.computerweekly.com/Articles/2003/10/31/198298/Microsoftthreattoolpreparesforpublicrelease.htm

This requires .NET Framework 2.0 to install. The getting started document is 45 pages long so it is something that requires some time to play with.

Monday, March 20, 2006 8:53:25 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

After posting about Web 2.0 today

http://www.noelwatson.com/blog/PermaLink,guid,b8496159-335c-4d61-8cc8-f2b5bc084c31.aspx

I got an email informing me that MS have released the March CTP of Atlas

http://atlas.asp.net/Default.aspx?tabid=47

If I were doing web development I would get up to speed on this, but find myself working on Winforms apps these days. MS use the following site as an example of what can be done

http://www.pageflakes.com/

 | 
Monday, March 20, 2006 8:23:33 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

I'd been trying to work out how the Concept 2 rower got its calorie calculation and came across the following links

http://www.concept2.com/05/rower/service/PM2_service.asp

http://www.concept2.co.uk/guide/guide.php?article=watts_conversion

  • 5000m in 18:39 minutes gives a power output of 250 watts

and a calorie consumption of ((4*250/1.1639)+300)* (18.66/60) = 360 calories (1160 cals/hour)

  • 5000m in 18:04 minutes gives a power output of 275 watts

and a calorie consumption of ((4*275/1.1639)+300)* (18.07/60) = 375 calories (1245 cals/hour)

 

This is for an 80 kilo man, for a 100kg man I would substitute 375 for 300, giving ~25 extra calories over 18 minutes. The following links are slightly more complex and take into account your age and weight.

http://www.concept2.co.uk/training/bmr.php

http://www.concept2.co.uk/training/bmr_calculator.php

This calculates that I would burn 454 calories for a 19 minute row at a 1:53 split

A Mars Bar has around 300 calories (449 calories per 100g, normal bar 62.5g)

http://www.weightlossresources.co.uk/calories/calorie_counter/chocolate_sweets.htm

Monday, March 20, 2006 3:24:16 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

Reading the Sunday Times over the last couple of weeks has made me realise that the dot com boom may be back with us. I have noticed the following

  • First Tuesday is back - as Second chance Tuesday

http://theglasshouse.net/content/sctlondon

  • FTSE is booming - went past 6000 last week

http://newsvote.bbc.co.uk/1/shared/fds/hi/business/market_data/stockmarket/3/twelve_month.stm

  • Web 2.0

http://www.oreillynet.com/pub/a/oreilly/tim/news/2005/09/30/what-is-web-20.html

http://www.web2con.com/

  • Big city bonuses - times are good in the city as M&A booms (although the average bonus wasn't that much greater than 2005)
  • New startups - there are lots of new companies that either

a) Wouldn't have started

b). Wouldn't have received so much hype

if it had been 2002-2005

One startup I have been looking at today is

www.fintag.com

This looks like something that could be useful  - if they provided a web service I could use this to hook into fifteen minute delayed prices. Alternatively, I could subscribe to Hemscott for £15/month.

http://businessplus.hemscott.net/register/compare_premiums.htm

I would be interested to see what Fintag's business model is.

  • Blogging - This has become commonplace over the last couple of years and is a very effective marketing tool. The most popular bloggers (Scoble) even publish books

http://www.amazon.co.uk/exec/obidos/ASIN/047174719X/qid=1142865650/sr=8-1/ref=sr_8_xs_ap_i1_xgl/026-0058056-7028455

Monday, March 20, 2006 10:50:44 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Friday, March 17, 2006

I've been reading through these and although they don't present anything groundbreaking, this is the kind of thing that can be automated at minimal cost and give the trader more opportunities and ideas.


https://www.markit.com/marketing/news/case_study_portal_citigroup.pdf


https://www.markit.com/marketing/news/case_study_portal_creditsuisse.pdf

Friday, March 17, 2006 5:43:35 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

http://www.amazon.co.uk/exec/obidos/ASIN/3527501983/026-0058056-7028455

I've read a number of Credit Derivative books and have learnt the following when looking at what to buy

  • Get a recent book - It used to be the case that I would wait until a book had some reviews on Amazon before shelling out. With the rapidly evolving CDS market, this is impossible.
  • You can't go wrong with Wiley.

This book was published in December 2005 and since I received it in January 2006 has been a constant reference. It has been the only book I've read that gives strategies currently used by traders, and replaces Chaplin as my previous favourite

http://www.amazon.co.uk/exec/obidos/ASIN/047002416X/qid=1142612078/sr=1-1/ref=sr_1_2_1/026-0058056-7028455

Friday, March 17, 2006 4:19:55 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

I was planning a route to a restaurant and saw this on Google. I don't recall any fire of this size being mentioned in the paper so I can only guess it must be a cloud

http://maps.google.com/maps?f=q&hl=en&q=wandsworth&ll=51.461173,-0.200844&spn=0.019546,0.053172&t=h

Trying to work out when the photo may have been taken is more difficult

Putney Wharf is completed

http://maps.google.com/maps?f=q&hl=en&q=wandsworth&t=h&ll=51.465351,-0.212965&spn=0.001221,0.003323&t=h

http://www.homedesignawards.com/homebuilder/homebuilder_2005/Category5/tower/tower.htm

Wikipedia says the photos are between a year and five old

http://en.wikipedia.org/wiki/Google_Maps

I originally thought that the reason that the resolution on the maps had been upgraded was because new photos had been taken - obviously not.

http://www.noelwatson.com/blog/PermaLink,guid,ed517dd5-120d-4fb7-9021-ab210b3ee7a3.aspx

Friday, March 17, 2006 12:28:40 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

http://www.microsoft.com/downloads/details.aspx?familyid=39ebef74-1c29-49fe-8221-c94f2b52f6c6&displaylang=en

and Express edition

http://www.microsoft.com/downloads/details.aspx?familyid=57856cdd-da9b-4ad0-9a8a-f193ae8410ad&displaylang=en

more info here

http://blogs.msdn.com/sqlexpress/archive/2006/03/16/Express_CTP.aspx

This service pack was always expected - MS posted a TPC entry with SQL 2005 at the end of last year.

http://www.noelwatson.com/blog/PermaLink,guid,82af9e3b-d08f-4b2b-85fc-9797aa55a567.aspx

MS are now moving away from traditional betas and releasing more frequent CTP's. It's good to see MS improving the functionality of their free offering.

Friday, March 17, 2006 8:32:12 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Thursday, March 16, 2006

http://www.sony-psp-review.com/news/515

I was just about to buy one of these so will hang on for a week. The new gadgets (GPS etc) look interesting.

Thursday, March 16, 2006 11:51:04 AM (GMT Standard Time, UTC+00:00)  #    Comments [1]  |  Trackback

http://www.rfu.com/debentures/debs.cfm

£6000 to guarantee a seat for 10 years! Alternatively join a rugby club for ~£50 a year and get your tickets that way.

http://www.quintinrfc.org.uk/

Wales offer a 25 year debenture for the same price - not that you'd want to go there!

http://www.wru.co.uk/4199_130.php?PHPSESSID=8ba62b55a5561908355e1aabe9bbd957

Thursday, March 16, 2006 8:33:55 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

After watching New Zealand crush France 18 months ago

http://news.bbc.co.uk/sport1/hi/rugby_union/4048025.stm

and watching France go to uncontested scrums, it was good to see the Sunday Times publish a list of scary French rugby players of yesteryear.

http://www.timesonline.co.uk/article/0,,2094-2081432,00.html

I remember Micky Skinner's tackle on Cecillion in 1991 - Cecillion is now in jail awaiting trial for shooting his wife. Vaquerin died after losing at Russian Roulette 

Thursday, March 16, 2006 8:26:24 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Wednesday, March 15, 2006

Write something with SQL Express and win $10k

http://www.madeinexpresscontest.com/

Wednesday, March 15, 2006 4:17:28 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

A friend of mine was discussing how betting exchanges use escrow accounts for outstanding bets.

I did some searching and found a wikipedia entry on how it can go wrong

http://en.wikipedia.org/wiki/Sporting_Options

This led me to a link on BackAndLay

http://en.wikipedia.org/wiki/BackAndLay

http://www.backandlay.com/

This site appears quiet at the moment, but offers a free API (Betfair £2000/year for transactional service) and only 1% commission. My dreams of endless arbitrage opportunities may not be over (dream on)!

Wednesday, March 15, 2006 12:10:52 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Tuesday, March 14, 2006

After a year of waiting, Amazon have finally sent me disc 1, Season 2 of Knight Rider

http://www.amazon.co.uk/exec/obidos/ASIN/B0009NS9EW/qid=1142420252/sr=8-2/ref=pd_ka_2/026-0058056-7028455

Reading the reviews, this appears to be the best season, and the introduction of Garth, Michael's twin brother, complete with £2.99 fake moustache, is inspired.

http://www.teamknightrider.com/classic/episodes/season2/season2.html

I'm working my way through

  • A Team

http://www.amazon.co.uk/exec/obidos/ASIN/B0002VF6BU/qid=1142420515/sr=2-2/ref=sr_2_11_2/026-0058056-7028455

  • Miami Vice

http://www.amazon.co.uk/exec/obidos/ASIN/B0007VXZAE/qid=1142420571/sr=1-1/ref=sr_1_3_1/026-0058056-7028455

  • Dukes of Hazzard

http://www.amazon.co.uk/exec/obidos/ASIN/B000777UEU/qid=1142420629/sr=1-2/ref=sr_1_11_2/026-0058056-7028455

 

but Knight Rider has to be the best.

Tuesday, March 14, 2006 9:56:05 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Friday, March 10, 2006

  • Calculating simple and compounded spot rate with Act/Act in a stored procedure

DECLARE @DaysInYear DECIMAL (4,1)

SELECT @DaysInYear = CASE YEAR(GETDATE())%4
 WHEN 0 THEN
   CASE YEAR(GETDATE()) % 100
    WHEN 0 THEN 365.0
    ELSE  366.0
   END
 ELSE 365.0
END


SELECT CAST(((1/DiscountRate)-1)/(DATEDIFF(dd, GETDATE(), DATEADD(mm, Term*12, GETDATE()))/@DaysInYear)*100 AS DECIMAL (4,2)) As SimpleCompoundingSpotRate,
CAST(-LOG(DiscountRate)/(DATEDIFF(dd, GETDATE(), DATEADD(mm, Term*12, GETDATE()))/@DaysInYear)*100 AS DECIMAL (4,2)) AS ContinouslyCompoundingSpotRate,
DiscountRate, Term FROM Term

  • Same as above but with 30/360

SELECT CAST(((1/DiscountRate)-1)/Term*100 AS DECIMAL (4,2)) As SimpleCompoundingSpotRate,
CAST(-LOG(DiscountRate)/Term*100 AS DECIMAL (4,2)) AS ContinouslyCompoundingSpotRate,
DiscountRate, Term FROM Term

  • Calculating discount curve from sport rate and vice versa in a spread sheet (no day count convention)

Attachment

SpotRate.xls (18.5 KB)

 

References

http://www.moneychimp.com/articles/finworks/continuous_compounding.htm

http://www.riskglossary.com/link/fixed_income_term_structure.htm

http://www.euribor.org/html/download/euribor_2006.txt

http://www.riskglossary.com/link/compounding.htm

Active Credit Portfolio Management - Page 153

Friday, March 10, 2006 5:27:58 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Thursday, March 09, 2006

This strategy looks for anomalies between an index and its constituent names. For this example, I will be concentrating on the ITRAXX indices

http://www.indexco.com/data/IndexMap.asp?menu=data&s=0&opa=505&index=menu8 (registration required)

There are several reasons why the index may not be trading in line with the underlying entities, one being whether the market outlook is bullish or bearish. If the outlook is bullish the skew (difference between actual index spread and average of constituent entities) will shrink (and maybe become negative) as investors look to increase their credit exposure by selling protection.

If the index price appears too high compared to the underlying, an investor can sell protection and sell on the underlying. This will only make sense on a small index (e.g. autos - 10 constituents) to keep transaction costs to a minimum.

Simply taking an average of the spreads is not the most accurate way of arriving at the theoretical index spread for the following reasons

• Dispersion bias

If you take a simple index comprising 2 entities, one trading at 200bps and the other at 300bps. The chances of the 300bps entity defaulting is higher, so the hazard rate must be taken into account. This gives a spread of 249.6 bps.
Note that this isn’t too much of  a problem when the spreads are tight, however if one name were to gap out, the difference would be significant

• Maturity mismatch

CDS contracts roll over quarterly (20th of March, June, September and December) whereas ITRAXX rolls over every six months (20th March and September). A solution to this is to use interpolation using the 3 and 5 year points.

e.g. When a 5 year ITRAXX contract is 3 months old, we would be looking for a CDS contract with 4.75 years. We can either use linear or polynomial interpolation.

• Quotation bias

ITRAXX indices trade at a fixed spread. If someone wishes to buy sell protection on an index, they will have to pay an upfront premium. The upfront value must be converted into a conventional spread.

Some information about upfront calculations can be found here

http://www.noelwatson.com/blog/PermaLink,guid,49d6809c-0c1b-4dc4-8e4e-d15ad9acb209.aspx

These values can add up to as much as 20bp difference from the simple average shown above for the 10Y iTRAXX Crossover index

References:

DJITraxx: Credit at its best

http://www.nuclearphynance.com/User%20Files/464/DJ%20iTraxx-%20Credits%20at%20its%20best.pdf

Active Credit Portfolio Management Pages 329 & 479
 

Attachment

 

ITRAXX.xls (13.5 KB)
Thursday, March 09, 2006 5:01:13 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

The beta service is now available

http://www.live.com/

It offers the ability to search through the results without having to click "next" to get the next lot of results. Doing some initial testing, I search for "Noel Watson Consulting" (without quotes).

Windows Live didn't return anything I wanted in the first 10 results - nor did Google. However, yahoo bought back my website as the first result - the winner. Searching for "Noel Watson Consulting" with quotes and Windows Live does a lot better, bringing back only one result - the correct one. Google brings back only one result - the wrong one whereas Yahoo brings back a few results - all relevant. If I had to rank the search engines based on this simple test it would be

  1. Yahoo
  2. Windows Live
  3. Google
Thursday, March 09, 2006 9:07:06 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

The third week's information has been put on the origami site

http://www.origamiproject.com/3/

and after the flash intro directs you to

http://origamiproject.com/default.aspx

and

http://www.microsoft.com/windowsxp/umpc/default.mspx

Looking at the screenshots, the product may be somewhat bigger than a PSP and isn't something that will slot into a pocket. Bill Gates was talking about this last year.

http://www.microsoft.com/presspass/press/2005/apr05/04-25WindowsThirdDecadePR.mspx

Thursday, March 09, 2006 8:38:40 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Tuesday, March 07, 2006

When I work out how to pronounce it I will attempt to drop it into a few sentences!

http://en.wiktionary.org/wiki/sesquipedalianism

Tuesday, March 07, 2006 8:58:57 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

For entities that trade both senior and subordinated debt – typically financials, there exists the potential to exploit mispricings.

The hazard rate depends on entity and not seniority, so in theory


PSen/PSub = (1-RSen)/(1-RSub)

Assuming Bank A has the following

Senior: 30 bps
Subordinated :60bps

Senior Recovery: 40%
Junior Recovery: 20%

(40% and 20% are industry standard recovery rates – these values differ in practice).

Substituting values into the equation

PSen/60 = (1-0.4)/(1-0.2)

Theoretical PSen = 45bps

Our calculations indicate that senior debt should be trading at 45bps and not 60bps - we would therefore sell senior protection and buy junior protection.

Assuming we sell £10mm notional of senior protection, we would buy 10/(1-RSen)/(1-RSub) = £13.3mm of junior protection.

Our cashflow would be £10mm x 60bps - £13.3mm x 30bps = £20000 p.a.

This does not take into account the fact that financing subordinated debt may be more expensive than pricing senior debt.

More accurate recovery rates can be found on Markit

www.markit.com

References

  • Credit Derivatives by Geoff Chaplin (Page 119) - link below

http://www.amazon.co.uk/exec/obidos/ASIN/047002416X/qid=1141718528/sr=1-1/ref=sr_1_2_1/026-0058056-7028455

Tuesday, March 07, 2006 8:02:21 AM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback
Monday, March 06, 2006

http://www.learn2asp.net/Campaign.aspx

Unfortunately it's only the standard edition (£200 R.R.P.),

http://www.checknowsoftware.com/uk/shop/pc/viewPrd.asp?pid=2819

but it's better than nothing if you haven't got MSDN, and it offers more than the free express editions

http://msdn.microsoft.com/vstudio/products/compare/default.aspx

Monday, March 06, 2006 1:10:44 PM (GMT Standard Time, UTC+00:00)  #    Comments [0]  |  Trackback

This type of trade aims to generate profits via a positive spread carry.

It relies on the credit curve remaining stable – so is therefore suited to higher rated entities.

You will be taking on counterparty risk when you buy protection – what’s the risk of them not paying up if the entity defaults?

Assuming you receive the curve for a given entity. The five year point is used for trading as it is the most liquid

Term Bid Ask DV01 Ratio Sell 5Y Incoming Outgoing Net Buy 5Y Incoming Outgoing Net
1 10 12 1000 4.50 50 54.00 -4.00 46.72 52.00 -5.28
2 22 24 2200 2.05 50 49.09 0.91 45.00 52.00 -7.00
3 33 35 3200