Re: Excel decimal to bond tick question

["Peter Iovanella" <ivo1@xxxxxxxxx>]

Also, how might I get Excel to show the half ticks in the Five Year Notes,
other than making it "# ?/64" and multiplying in my mind?

Thanks again.

Peter

-----Original Message-----
From: Peter Iovanella <ivo1@xxxxxxxxx>
To: Mark Brown <markbrown@xxxxxxxxxxxxx>; omega-list@xxxxxxxxxx
<omega-list@xxxxxxxxxx>
Date: Monday, November 23, 1998 2:19 PM
Subject: Re: Excel decimal to bond tick question


>Thanks - do you know if there is any way to make it appear like 124^13
>rather than 124 13/32?  And I had to make a custom format, as Michael Joyce
>suggested, since there isn't an ??/32 one provided with Excel.
>
>Peter
>
>
>-----Original Message-----
>From: Mark Brown <markbrown@xxxxxxxxxxxxx>
>To: Peter Iovanella <ivo1@xxxxxxxxx>; omega-list@xxxxxxxxxx
><omega-list@xxxxxxxxxx>
>Date: Monday, November 23, 1998 1:59 PM
>Subject: Re: Excel decimal to bond tick question
>
>
>>
>>click on the cell then hit format then choose fraction pick what you want,
>>click ok...done...next?
>>
>>
>>>Format them how?  I mean, do I have to create my own custom format, or is
>>it
>>>included within Excel?
>>>
>>>
>>>-----Original Message-----
>>>From: Mark Brown <markbrown@xxxxxxxxxxxxx>
>>>To: Peter Iovanella <ivo1@xxxxxxxxx>; omega-list@xxxxxxxxxx
>>><omega-list@xxxxxxxxxx>
>>>Date: Monday, November 23, 1998 1:45 PM
>>>Subject: Re: Excel decimal to bond tick question
>>>
>>>
>>>>yes you can do it in excel , format the numbers dude!
>>>>
>>>>
>>>>
>>>>-----Original Message-----
>>>>From: Peter Iovanella <ivo1@xxxxxxxxx>
>>>>To: omega-list@xxxxxxxxxx <omega-list@xxxxxxxxxx>
>>>>Date: Monday, November 23, 1998 12:38 PM
>>>>Subject: Excel decimal to bond tick question
>>>>
>>>>
>>>>>Is there any macro out there that will allow me to see prices I import
>>>into
>>>>>Excel from TS in terms of ticks rather than in decimal form?  For
>>example,
>>>>>how I can get 113.75 to appear as 113^24.  I assume that TS has some
>>>>>built-in routine to do this; is there anything I can do in Excel to
>>>emulate
>>>>>this?  Thanks!
>>>>>
>>>>>BJ
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>