13,251,998 members (57,812 online)
alternative version

(untagged)

#### Stats

31.2K views
6 bookmarked
Posted 30 Dec 2007

# Conversion of decimal to tick format and vice versa

, 30 Dec 2007
 Rate this:
VB script Algorithm to convert from decimal to ticks and vice versa

## Introduction

Tick format is pretty common format used by traders in fixed income trading. Decimals can be very mind-numbing to look at; tick format is very convenient to track small changes in price/yield of the bond. Here is a brief example: Tick Value: 99-105 Equivalent Decimal Value: 99.332. Anatomy of Tick Value: 99=pre decimal value. 10=Tick value and is 1/32nd of decimal. 5=1/8th of of 32nd. We can convert to decimal as follows: Decimal Value (99.332) = 99 + ((10 + (5/8)) / 32)

## Background

I tried googling algorithm for doing it but could not find anything useful and decided to write one of my own. I have written this in VB script. This could be easily converted to C#/VB.Net or any other programming language.

## Using the code

“+” and “-“ buttons in attached excel file typically increments / decrements the number in cell ‘b5’ by 1/8th of a tick. For example: Number in cell b5: 99-106. Clicking “+” button: 99-107. Clicking “-” button: 99-105. Cell “b10” presents the decimal equivalent of the tick value presented in cell “b5”. Special Notation: If the number in 1/8th of a tick in ‘4’ then it is represented as “+”. That is, 99-104 will be presented as 99-10+

## Share

 United States
No Biography provided

## You may also be interested in...

 First Prev Next
 My vote of 5 Southmountain15-May-13 12:35 Southmountain 15-May-13 12:35
 Thanks! Lupuj18-Dec-12 0:27 Lupuj 18-Dec-12 0:27
 thanks.. Jozo Leko12-Nov-12 23:43 Jozo Leko 12-Nov-12 23:43
 Thanks for Sharing this Rak_i12-May-12 15:05 Rak_i 12-May-12 15:05
 Last Visit: 31-Dec-99 19:00     Last Update: 20-Nov-17 15:26 Refresh 1

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Web02 | 2.8.171114.1 | Last Updated 30 Dec 2007
Article Copyright 2007 by Swapnil Kulkarni