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

Re: Excel decimal to bond tick question



PureBytes Links

Trading Reference Links

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