excel spreadsheets

[spin2win]

Hi
Does anyone have any good excel sheets to work spreads on?

 

[Euro_d]

Hi
Does anyone have any good excel sheets to work spreads on?

What exactly do you mean?
I have a SS that works out the trade based on bank, spread and stop which you are welcome to have
Dave

 

[spin2win]

that would be great, im trying to get an excel spreadsheet that shows how i can leg into spreads to get a spread put onside i.e. buy bid sell offer of another month then just sell the spread to take 1/2 tick etc..

 

[Euro_d]

that would be great, im trying to get an excel spreadsheet that shows how i can leg into spreads to get a spread put onside i.e. buy bid sell offer of another month then just sell the spread to take 1/2 tick etc..

Sorry, my SS does not do that.

 

[spin2win]

what does yours show?

 

[neilcharlton]

just buy a book on excel and write them yourself - takes about 5 min , very simple code and simple maths .

 

[squaregains]

we are tendering for a few projects in this space - if you are interested in outsourcing this requirements send me a PM.

Rgds

 

[Directional]

squaregains - what do you mean? are you putting spreadsheets together for traders?

 

[squaregains]

yes including enhancements to existing sheets using VBA/.NET.

 

[Mornington Crescent]

can someone tell me what is the maximum number of rows in excel ?

 

[Pennt]

65536

({End}{Down} on a new worksheet takes you to the last row.)

 

[Mornington Crescent]

ta

its a limiting factor with ss I have.

will take a looksee.

 

[DC STOXX]

that would be great, im trying to get an excel spreadsheet that shows how i can leg into spreads to get a spread put onside i.e. buy bid sell offer of another month then just sell the spread to take 1/2 tick etc..

Isnt this what you use the spread matrix for?

Or am i been a nob & have i complelty missed the plot ect....

 

[Lucky_81]

what markets are you looking to create this sheet for, I presume your looking at one with exchange quoted spreads i.e. euribor, eurodollar, oil etc?

 

[Almarok]

If it can be useful, at this Site:

Index of /gummy-stuff/Excel

you can download many indicators for Excel for free (Moving averages, ADX, Roc, Bollinger Bands, Monte Carlo, Portfolio, etc....).