[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Excel decimal to bond tick question


  • To: "Mark Brown" <omega-list@xxxxxxxxxx>
  • Subject: Re: Excel decimal to bond tick question
  • From: "Peter Iovanella" <ivo1@xxxxxxxxx>
  • Date: Mon, 23 Nov 1998 13:48:58 -0500 (EST)

PureBytes Links

Trading Reference Links

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
>>
>>
>>
>
>