Excel

[hopback]

Anyone know how to make the number format of an array change based on the value of a particular cell (not in the array)?

Conditional formatting only allows for changes to font, borders, and patterns.

 

[hopback]

Let me add 1 more question to that.

Is it possible to combine decimal and fraction formats? example: 2.5/32

 

[maxpi]

You can concatenate a value from another cell to your values in the array and make the formatting conditional based on the concatenated value maybe.

The fraction math will work fine.

 

[hopback]

maxpi,

How do I get it to display 2.5/32?
In the Format Cells window, Numbers tab, custom, I selected #???/32

It didn't let me put a decimal point between the question marks to display 1/2 ticks.

As far as the first question, the input cell will not be the same format as the arrays.
The input cell will be ZB,ZN,YM, etc...
The arrays are prices broken in to handles and ticks. 106 12.5/32

For ZN, I've been displaying it in 64ths to show 1/2 ticks. It works but I would prefer 12.5/32 to 25/64.

 

[qtip]

Does anyone know of any written books on using Excel to develop trading models?

 

[hopback]

Haven't seen any books specificaly for trading applications, been reading VBA books myself.

My model is almost complete at this point, just trying to make it easier to use. I have 1 version for bonds and 1 version for eminis, would like to combine them.

Just found this site by searching "excel for trading"
http://www.spooztoolz.com/

 

[qtip]

Quote from hopback:

Haven't seen any books specificaly for trading applications, been reading VBA books myself.

My model is almost complete at this point, just trying to make it easier to use. I have 1 version for bonds and 1 version for eminis, would like to combine them.

Just found this site by searching "excel for trading"
http://www.spooztoolz.com/

It is funy you posted this. When I was working in Austin, this company was just starting out. Now, they moved to Chicago.
At the time, the talk was being able to build trading models through their "software."

If you find anything else, let me know.

 

[lp3yc]

Post any excel questions you need answered on http://www.mrexcel.com/board2/index.php?sid=84421ac967542ebb8af381b9af4f4b9e

and you will have an answer almost immediately. Amazing, it has never missed forme no matter how complicated the question

 

[Zzoom]

Quote from qtip:

Does anyone know of any written books on using Excel to develop trading models?

I seem to recall "Trading for Dummies" has some very basic stuff on how to program a Donchian Model into Excel including instructions!

The other extreme is Kaufman of course...

 

[late apex]

AnalyzerXL is the best library of trading-oriented add-ins for Excel I've found. Powerful, easy to use, inexpensive. If only BacktestingXL were not limited to EOD...