is anyone building an automated trading system?

[Maksim79]

Hello, everyone.

Is there anyone who is building an automated trading system? I understand that most people are hesitant to discuss their findings. Perhaps we could share without giving away too much.

[GusTsahas]

I have been involved in building a few automated trading systems, more in terms of the trading system development then the execution coding of the ATS......... anything in particular you want to discuss?? What markets and time frame are you interested in?

[Maksim79]

I have been involved in building a few automated trading systems, more in terms of the trading system development then the execution coding of the ATS......... anything in particular you want to discuss?? What markets and time frame are you interested in?

Thanks for your reply.

I think coding is the easy part compared to creating a strategy.

I'm interested in trading futures intra-day, for now I have been experimenting with ER2 and DAX. In my opinion, there are several reasons to trade:
1. Based on valuation (price outside of determined/predicted range)
2. Arbitrage
3. Guessing the direction of the market or following trends

The biggest obstacle I came across is predicting how rapidly and how far will the price move during a trading session. At this point I'm leaning towards coding several mutually exclusive strategies and placing orders based on which strategy would have made more money since the beginning of the trading session. Unfortunately, I think this also may not work, because "past performance does not predict the future".

I'm just interested to know what axioms, assumptions others use when creating a strategy. Do people follow trends, do arbitrage or trade based on other things?

I'm not a professional trader, and do have not taken any finance courses. I would appreciate critique from anyone!

Thanks!

[GusTsahas]

I urge people new to trading to consider testing systems that utilize end-of-day data until you develop experience and are profitable in the an intermediate time frame (1 to 10 days) . By limiting yourself to end-of day data, the resource you need to devote to data acquisition and data handling are minimal and you can concentrate on testing the actual trading strategies.

You will probably only trade the “Open” or the “Close” with the EOD data and this minimizes the time needed to execute the system trades…… it is a real benefit if you have a day job. Once you have experience in profitably trading intermediate time strategies you can shorten the holding time and further test to see if your strategies work in the shorter time frames.

In terms of what works, my personal preference is to buy pull backs triggered by any of the different statistical, volatility or time indicators. ie: Standard deviation, Bollinger bands, resistance, weekly low, monthly low….. To minimize your draw down, I recommend adding a market directional filter to only take trades in the direction of the trend and include a volatility measure to help choose which trades to take if capital is an issue. Another idea is KISS, (keep it simple stup_d), if you add too many rules to your system, you will be curve fitting and the market conditions will not repeat… and your system will lose money.

It is much more important to focus on the draw down and not wiping out your account then in how much money you can make with a particular strategy. If you are trading, there will be periods where profits will accumulate, but you will not be trading if you blew your account the earlier month.

Good Luck, it is a long winding road, Gus

[Wallstyouth]

Hello, everyone.

Is there anyone who is building an automated trading system? I understand that most people are hesitant to discuss their findings. Perhaps we could share without giving away too much.

Some of these guys are the best in the business some are just starting out its a very good read if you have the time.

Frosty's auto-trading bot goes lve with real money:
Forums - Frosty's auto-trading bot goes live with REAL money (http://www.elitetrader.com/vb/showthread.php?s=&threadid=80672)

Reasons for failure in automated trading systems:
Forums - Reasons for failur in automatic trading systems (http://www.elitetrader.com/vb/showthread.php?s=&threadid=68834)

Trading bot construction:
Forums - Trading bot construction (IB) (http://www.elitetrader.com/vb/showthread.php?s=&threadid=84323)

Chabah on automated trading:
Forums - Chabah on Automated Trading (http://www.elitetrader.com/vb/showthread.php?s=&threadid=77887)

Developing a trading framework from scratch:
Forums - Developing a Trading Framework from Scratch (http://www.elitetrader.com/vb/showthread.php?s=&threadid=81670)

[kanzure]

Hi all,

Here are some links I have been accumulating in open source trading programming. It seems that there are no trading platforms coded in QuickFIX (http://quickfixengine.org/), but otherwise the community looks strong.

IbPy (http://code.google.com/p/ibpy/wiki/GettingStarted)
ProfitPy (http://code.google.com/p/profitpy/) (I had some trouble setting this up.)
Finance::InteractiveBrokers TWS perl mod (http://search.cpan.org/~jstrauss/Finance-InteractiveBrokers-TWS-v0.0.8/lib/Finance/InteractiveBrokers/TWS.pm) over on CPAN

Also, if anybody wants to get a hold of me, I am most often on the IM protocols. Welcoming any financial chatters. :)

- Bryan

[foquant]

Some very good info here - I especially agree with many of the points from GusTsahas.

One thing I would definitely recommend is to keep a close eye on the market you want to trade. I have implemented automated systems in the equities market, and want to switch to the futures arena. For a few months, I simply opened up 5 or 6 charts for each market I wanted to follow. Each of those charts would have various intervals shown, such as 1 minute, 5 minute, 8 minute, xx contracts, xx ticks. The non-time based intervals are particularly helpful, especially if you eventually want to get to very high frequency.

Watching the markets real time will help give you a backbone to start working with, whether you approach algorithm development from an inductive or deductive way. For example, you may want to purely datamine, but by watching realtime, you get a "feel" for how fast the market moves, and under what circumstances. This will aid in your estimation of slippage, which you can then add to your system tests.

Also, be sure to test position sizing and money management systems along with your main trading rules. Position sizing and money management, I believe, are almost as equally important especially as your capital increases.

Hope that helps. :)

[DominiConnor]

As a HH, I would chip in, that some employers would be interested in this sort of project, even if their stuff is (usually) more sophisticated.
A couple of pointers :
How are you hedging or at least putting limits on how much you lose ?
Are you optimising return vs risk ? What measure are you using for risk ?

There is also market impact; given that prices have a Heisenberg-like sensitivity to being traded. A guess the average student ain't gonna move the market any significant amount, but real algotrading systems have that issue.

One high level view of AT is therefore optimisation with respect to several factors, risk, return, market impact, etc.

[foquant]

good point DominiConner - in a recent interview I was asked to see 'samples' of what I had created.

any tips on what employers like to see, such as:
1. identification of risks
2. management of risks
3. how legible is the code
4. system controls/is the code robust (ie no dangling orders)
5. strong track record, either out of sample backtested or realized
6. tools used (ie which language, which API, which libraries)
etc.

[finssite]

Hi,

An interesting article:
http://www.cs.brown.edu/research/ai/dynamics/tutorial/Documents/CrackingWallStreet.html

Thanks,
Shakti

[foquant]

fun article finssite, thanks - interesting analogies to inductive methodologies

[finssite]

fun article finssite, thanks - interesting analogies to inductive methodologies
hi foquant,

i guess this is one big reason we've all these opportunities: "The use of hypothetical element typically leads to an immediate boom in..." http://www.matrixreasoning.com/pdf/inductiondeduction.pdf

Again, plenty to take from this paper like the previous article.

Enjoy!
Shakti

[charlesdwright]

Hello, everyone.

Is there anyone who is building an automated trading system? I understand that most people are hesitant to discuss their findings. Perhaps we could share without giving away too much.

I have one such project, for automated arbitrage, in the IB Olympiad. It does not currently rely on a pricing model; or rather, let's say its pricing model is the market.

Unfortunately, the development process is painstakingly slow, as I am only able to spend about an hour a day actually debugging it in real time. One of the instruments trades a limited schedule for reasons that are pretty arcane and so even papertrading it is not always possible.

At this juncture, I could break the process down about as follows (not in order):

1. Manipulating TWS via API
2. Strategy Development (trading and money managment)
3. Algorithm Development (trading and money management)
4. Coding/Debugging
5. Meeting specific market challenges (i.e. order control)
6. Analysis and optimization
.
.
etc. For me a lot of this overlaps.

The nature of the beast seems to beg for multi-threading and that's the next hurdle. I suppose that falls under algorithm development and coding/debugging.

[alain]

I have one such project, for automated arbitrage, in the IB Olympiad. It does not currently rely on a pricing model; or rather, let's say its pricing model is the market.

Unfortunately, the development process is painstakingly slow, as I am only able to spend about an hour a day actually debugging it in real time. One of the instruments trades a limited schedule for reasons that are pretty arcane and so even papertrading it is not always possible.

At this juncture, I could break the process down about as follows (not in order):

1. Manipulating TWS via API
2. Strategy Development (trading and money managment)
3. Algorithm Development (trading and money management)
4. Coding/Debugging
5. Meeting specific market challenges (i.e. order control)
6. Analysis and optimization
.
.
etc. For me a lot of this overlaps.

The nature of the beast seems to beg for multi-threading and that's the next hurdle. I suppose that falls under algorithm development and coding/debugging.

Charles, I think you will be overcomplicating the system by introducing multuple threads. You need something simple. Let me know if you need anyhelp.

[DominiConnor]

FOQuant:any tips on what employers like to see
By necessity any advice I have is based upon 2nd hand info from hiring managers, so there is noise in my signal.

They like "creativity". That is of course hard to define, but any algorithmic strategy out of a book fails directly. They want to hire someone who tries something they would not have thought of.

They want some "mechanism", not just for the strategy to work, but for you to be able to explian "why". Causality in this context is a slippery thing, and of course you may be wrong, but it is important not to think you are building a black box, because these are hard to trust.

They like to see how you hedge and manage risk. Merely making money on average is not enough, you have to show you can "survive".
In particular, I encourage anyone doing this to understand the Kelly Criterion which allows you to reason about optimal bet size. Indeed I commend this to any quant involved in trading, even though some MFE syllabi fail to cover it.

Another hard to define characteristic is "intellectual curiousity", which includes drilling down to try and find out why things are the way they are, and not just ignoring things.
Conversely, you need focus, showing you don't get too distracted.

Also the more "real world" factors you take into account the better.
For instance, many high frequency trading strategies deliver an average return that can get lost in trading costs. One thing that is beyond student "practice" algorithmic trading is market impact, since you may be trading enough to move the market slightly against you

The previous few factors imply that you ought to at least think about some form of optimisation to get the best past spreads and impacts. Also in real time trading you cannot assume that all the trades you want actually execute, indeed in some markets less than 50% of the trades you try for don't happen.

[charlesdwright]

Charles, I think you will be overcomplicating the system by introducing multuple threads. You need something simple. Let me know if you need anyhelp.

Alain, you're a gentleman. Thank you. But honestly, yes, I do think threads will complicate things, but as I have competing events coming from IB that access the same variable(s), I think I have to thread them.

[Wallstyouth]

Hi all,

Here are some links I have been accumulating in open source trading programming. It seems that there are no trading platforms coded in QuickFIX (http://quickfixengine.org/), but otherwise the community looks strong.

IbPy (http://code.google.com/p/ibpy/wiki/GettingStarted)
ProfitPy (http://code.google.com/p/profitpy/) (I had some trouble setting this up.)
Finance::InteractiveBrokers TWS perl mod (http://search.cpan.org/~jstrauss/Finance-InteractiveBrokers-TWS-v0.0.8/lib/Finance/InteractiveBrokers/TWS.pm) over on CPAN

Also, if anybody wants to get a hold of me, I am most often on the IM protocols. Welcoming any financial chatters. :)

- Bryan

You're comment about Quickfix is pretty inaccurate join the quickfix mailing list and just look at the email headers to see who is using QuickFix. It ranges from very large IB's to tiny hedgefunds I've personally seen over a dozen or so major firms post to the QF mailinglist.

[charlesdwright]

a demo of this is available; haven't had time to do much with it but the developer seems solid.

XLFiX - FIX for Excel (http://www.macd.com/xlfix/)

[charlesdwright]

...In particular, I encourage anyone doing this to understand the Kelly Criterion which allows you to reason about optimal bet size. Indeed I commend this to any quant involved in trading, even though some MFE syllabi fail to cover it...

May I recommend two books on this fascinating and readily applicable topic?

1. Portfolio Management Formulas, Ralph Vince; and
2. Fortune's Formula, William Poundstone.

The former will have you applying the material within hours; the latter is a bit more historical and anecdotal and is useful in a different way.

Enjoy.

[jfranta]

Let me add another one to your list:

TradeLinkSuite (http://tradelink.googlecode.com)

I use it to daytrade NYSE stocks.

Never heard of quickfix before... looks interesting although their website is slow as D#!@#$ right now...



Hi all,

Here are some links I have been accumulating in open source trading programming. It seems that there are no trading platforms coded in QuickFIX (http://quickfixengine.org/), but otherwise the community looks strong.

IbPy (http://code.google.com/p/ibpy/wiki/GettingStarted)
ProfitPy (http://code.google.com/p/profitpy/) (I had some trouble setting this up.)
Finance::InteractiveBrokers TWS perl mod (http://search.cpan.org/~jstrauss/Finance-InteractiveBrokers-TWS-v0.0.8/lib/Finance/InteractiveBrokers/TWS.pm) over on CPAN

Also, if anybody wants to get a hold of me, I am most often on the IM protocols. Welcoming any financial chatters. :)

- Bryan

[Suman]

thank you people for the excellent information :)

[resfranzi]

if the world is deterministic, optimisation is simple. but when there are many things not in the control of a program could happen, the outcome may well be just as uncertain

[ExSan]

I have developed a raw simulator of Automata Trading System that reads data from a txt file, in this format
asset_name price
at the time every asset is read it is computed the Markowitz Portfolio
My aim is to use this in the future to implement more complicated Trading Algorithm and finally a real Automata Trading System
API interface still pending


Thu Nov 13 08:08:17 2008
EXSAN v3.18.kk - exsan.software@gmail.com exsan@uio.satnet.net
E X S A N M E N U
Quant Finance Room
f Markowitz Portfolio Automata Handler
0 ---> exit
Your Data File in c:\exsan\ Data file ---> mkt
Data will be read from File ---> c:\exsan\mkt.txt
[8...12] Build Portfolio Markowitz with the at least || last n ticks ---> 10
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[2, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
1: 0 0 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
1: 0 0 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
1: 0 0 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 16.15 Insert in Col-Index: 1 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[2, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
1 SIN 1: 16.1 0 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
1 SIN 1: 0 0 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
1 SIN 1: 0 0 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 19.48 Insert in Col-Index: 2 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[2, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
2 SIN 1: 16.1 19.5 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
2 SIN 1: 0 0.206 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
2 SIN 1: 0 0.206 0 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 22.41 Insert in Col-Index: 3 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[2, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
3 SIN 1: 16.1 19.5 22.4 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
3 SIN 1: 0 0.206 0.15 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
3 SIN 1: 0 0.206 0.15 0 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 24.68 Insert in Col-Index: 4 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[2, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
4 SIN 1: 16.1 19.5 22.4 24.7 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
4 SIN 1: 0 0.206 0.15 0.101 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
4 SIN 1: 0 0.206 0.15 0.101 0 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 26.08 Insert in Col-Index: 5 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[2, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
5 SIN 1: 16.1 19.5 22.4 24.7 26.1 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
5 SIN 1: 0 0.206 0.15 0.101 0.0567 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
5 SIN 1: 0 0.206 0.15 0.101 0.0567 0 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 26.5 Insert in Col-Index: 6 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[2, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[2, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
2: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 9 Insert in Col-Index: 1 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[3, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
1 BULL 2: 9 0 0 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
1 BULL 2: 0 0 0 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
1 BULL 2: 0 0 0 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 4.5 Insert in Col-Index: 2 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[3, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
2 BULL 2: 9 4.5 0 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
2 BULL 2: 0 -0.5 0 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
2 BULL 2: 0 -0.5 0 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 15 Insert in Col-Index: 3 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[3, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
3 BULL 2: 9 4.5 15 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
3: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 19 Insert in Col-Index: 1 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
3 BULL 2: 9 4.5 15 0 0 0 0 0 0 0 0
1 BEAR 3: 19 0 0 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
1 BEAR 3: 0 0 0 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
1 BEAR 3: 0 0 0 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 18.5 Insert in Col-Index: 2 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
3 BULL 2: 9 4.5 15 0 0 0 0 0 0 0 0
2 BEAR 3: 19 18.5 0 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
2 BEAR 3: 0 -0.0263 0 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
2 BEAR 3: 0 -0.0263 0 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 18 Insert in Col-Index: 3 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
3 BULL 2: 9 4.5 15 0 0 0 0 0 0 0 0
3 BEAR 3: 19 18.5 18 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
3 BEAR 3: 0 -0.0263 -0.027 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
3 BEAR 3: 0 -0.0263 -0.027 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 17.5 Insert in Col-Index: 4 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
3 BULL 2: 9 4.5 15 0 0 0 0 0 0 0 0
4 BEAR 3: 19 18.5 18 17.5 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
4 BEAR 3: 0 -0.0263 -0.027 -0.0278 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
3 BULL 2: 0 -0.5 2.33 0 0 0 0 0 0 0 0
4 BEAR 3: 0 -0.0263 -0.027 -0.0278 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 17 Insert in Col-Index: 5 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
5 BEAR 2: 19 18.5 18 17.5 17 0 0 0 0 0 0
3 BULL 3: 9 4.5 15 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
3 BULL 3: 0 -0.5 2.33 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
3 BULL 3: 0 -0.5 2.33 0 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 12 Insert in Col-Index: 4 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
5 BEAR 2: 19 18.5 18 17.5 17 0 0 0 0 0 0
4 BULL 3: 9 4.5 15 12 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
4 BULL 3: 0 -0.5 2.33 -0.2 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
4 BULL 3: 0 -0.5 2.33 -0.2 0 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 24 Insert in Col-Index: 5 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
5 BEAR 2: 19 18.5 18 17.5 17 0 0 0 0 0 0
5 BULL 3: 9 4.5 15 12 24 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
5 BULL 3: 0 -0.5 2.33 -0.2 1 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
5 BULL 3: 0 -0.5 2.33 -0.2 1 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 22.5 Insert in Col-Index: 6 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
5 BEAR 2: 19 18.5 18 17.5 17 0 0 0 0 0 0
6 BULL 3: 9 4.5 15 12 24 22.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
6 BULL 3: 0 -0.5 2.33 -0.2 1 -0.0625 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
5 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
6 BULL 3: 0 -0.5 2.33 -0.2 1 -0.0625 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 36 Insert in Col-Index: 7 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
7 BULL 2: 9 4.5 15 12 24 22.5 36 0 0 0 0
5 BEAR 3: 19 18.5 18 17.5 17 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
7 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
5 BEAR 3: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
6 SIN 1: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
7 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
5 BEAR 3: 0 -0.0263 -0.027 -0.0278 -0.0286 0 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 36 Insert in Col-Index: 8


BEAR -bid-> 15.5 Insert in Col-Index: 6 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 9 4.5 15 12 24 22.5 36 0 0 0 0
6 SIN 2: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
6 BEAR 3: 19 18.5 18 17.5 17 15.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 2: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
6 BEAR 3: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 2: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
6 BEAR 3: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 15 Insert in Col-Index: 7 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 9 4.5 15 12 24 22.5 36 0 0 0 0
6 SIN 2: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
7 BEAR 3: 19 18.5 18 17.5 17 15.5 15 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 2: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
7 BEAR 3: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 2: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
7 BEAR 3: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 14.5 Insert in Col-Index: 8 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 9 4.5 15 12 24 22.5 36 0 0 0 0
8 BEAR 2: 19 18.5 18 17.5 17 15.5 15 14.5 0 0 0
6 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
8 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
7 BULL 1: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
8 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 14 Insert in Col-Index: 9 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
9 BEAR 1: 19 18.5 18 17.5 17 15.5 15 14.5 14 0 0
7 BULL 2: 9 4.5 15 12 24 22.5 36 0 0 0 0
6 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
9 BEAR 1: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 0 0
7 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
9 BEAR 1: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 0 0
7 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BEAR -bid-> 13.5 Insert in Col-Index: 10 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
7 BULL 2: 9 4.5 15 12 24 22.5 36 0 0 0 0
6 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
7 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
7 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 51 Insert in Col-Index: 8 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
8 BULL 2: 9 4.5 15 12 24 22.5 36 51 0 0 0
6 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
8 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
8 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 52.5 Insert in Col-Index: 9 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
9 BULL 2: 9 4.5 15 12 24 22.5 36 51 52.5 0 0
6 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
9 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
9 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 69 Insert in Col-Index: 10 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
10 BULL 2: 9 4.5 15 12 24 22.5 36 51 52.5 69 21.7
6 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
10 BULL 2: 0 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.393
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
10 BULL 2: -0.393 -0.893 1.94 -0.593 0.607 -0.456 0.207 0.0235 -0.364 -0.0788 0
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 72 Insert in Col-Index: 1 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
11 BULL 2: 72 4.5 15 12 24 22.5 36 51 52.5 69 24.1
6 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
11 BULL 2: 0.0435 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.397
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
10 BEAR 1: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
11 BULL 2: -0.354 -0.897 1.94 -0.597 0.603 -0.46 0.203 0.0192 -0.368 -0.0832 0.802
6 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 0 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Matrix of Variance / Co-Variance
WORKSHEET H[1, 1]
<------------->
A
11 BULL 1: 0.64456
>-------------<


SIN -bid-> 25.88 Insert in Col-Index: 7 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: 72 4.5 15 12 24 22.5 36 51 52.5 69 24.1
10 BEAR 2: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
7 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: 0.0435 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.397
10 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
7 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: -0.354 -0.897 1.94 -0.597 0.603 -0.46 0.203 0.0192 -0.368 -0.0832 0.802
10 BEAR 2: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
7 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 0 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 24.3 Insert in Col-Index: 8 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: 72 4.5 15 12 24 22.5 36 51 52.5 69 24.1
10 BEAR 2: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
8 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: 0.0435 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.397
10 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
8 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: -0.354 -0.897 1.94 -0.597 0.603 -0.46 0.203 0.0192 -0.368 -0.0832 0.802
10 BEAR 2: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
8 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 0 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 21.88 Insert in Col-Index: 9 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: 72 4.5 15 12 24 22.5 36 51 52.5 69 24.1
10 BEAR 2: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
9 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: 0.0435 -0.5 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.397
10 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
11 BULL 1: -0.354 -0.897 1.94 -0.597 0.603 -0.46 0.203 0.0192 -0.368 -0.0832 0.802
10 BEAR 2: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


BULL -bid-> 90 Insert in Col-Index: 2 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 72 90 15 12 24 22.5 36 51 52.5 69 26.7
10 BEAR 2: 19 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.99
9 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 0.0435 0.25 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.472
10 BEAR 2: 0 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0334
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: -0.429 -0.222 1.86 -0.672 0.528 -0.535 0.128 -0.0558 -0.443 -0.158 0.742
10 BEAR 2: 0.0334 0.00706 0.00634 0.00559 0.0048 -0.0549 0.00111 3.82e-005 -0.00111 -0.00234 0
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Matrix of Variance / Co-Variance
WORKSHEET H[1, 1]
<------------->
A
12 BULL 1: 0.85337
>-------------<


BEAR -bid-> 16.5 Insert in Col-Index: 1 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[3, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 72 90 15 12 24 22.5 36 51 52.5 69 26.7
11 BEAR 2: 16.5 18.5 18 17.5 17 15.5 15 14.5 14 13.5 1.75
9 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 0.0435 0.25 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.472
11 BEAR 2: 0.222 -0.0263 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0111
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[3, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: -0.429 -0.222 1.86 -0.672 0.528 -0.535 0.128 -0.0558 -0.443 -0.158 0.742
11 BEAR 2: 0.233 -0.0152 -0.0159 -0.0166 -0.0174 -0.0771 -0.0211 -0.0222 -0.0233 -0.0246 0.084
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
>---------------------------------------------------------------------------------------------------<
Matrix of Variance / Co-Variance
WORKSHEET H[2, 2]
<-------------------------->
A B
12 BULL 1: 0.85337 -2.7318e-005
11 BEAR 2: -2.7318e-005 0.0071112
>--------------------------<
Portfolio Weights
WORKSHEET I[2, 1]
<----------->
A
12 BULL 1: 0.0083
11 BEAR 2: 0.992
>-----------<
Portfolio Variance
WORKSHEET M[1, 1]
<----------->
A
1: 0.00705
>-----------<
Portfolio Volatility
WORKSHEET N[1, 1]
<------------->
A
1: 0.08397625
>-------------<
Expected Portfolio Return
WORKSHEET O[1, 1]
<------------->
A
1: 0.08948923
>-------------<


BEAR -bid-> 16 Insert in Col-Index: 2 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 72 90 15 12 24 22.5 36 51 52.5 69 26.7
12 BEAR 2: 16.5 16 18 17.5 17 15.5 15 14.5 14 13.5 1.51
9 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 0.0435 0.25 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.472
12 BEAR 2: 0.222 -0.0303 -0.027 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0115
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: -0.429 -0.222 1.86 -0.672 0.528 -0.535 0.128 -0.0558 -0.443 -0.158 0.742
12 BEAR 2: 0.234 -0.0188 -0.0155 -0.0162 -0.017 -0.0767 -0.0207 -0.0218 -0.0229 -0.0242 0.0841
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Matrix of Variance / Co-Variance
WORKSHEET H[2, 2]
<-------------------------->
A B
12 BULL 1: 0.85337 -2.7031e-005
12 BEAR 2: -2.7031e-005 0.0071265
>--------------------------<
Portfolio Weights
WORKSHEET I[2, 1]
<----------->
A
12 BULL 1: 0.00831
12 BEAR 2: 0.992
>-----------<
Portfolio Variance
WORKSHEET M[1, 1]
<----------->
A
1: 0.00707
>-----------<
Portfolio Volatility
WORKSHEET N[1, 1]
<------------->
A
1: 0.08406547
>-------------<
Expected Portfolio Return
WORKSHEET O[1, 1]
<------------->
A
1: 0.0895892
>-------------<


BEAR -bid-> 13 Insert in Col-Index: 3 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 72 90 15 12 24 22.5 36 51 52.5 69 26.7
13 BEAR 2: 16.5 16 13 17.5 17 15.5 15 14.5 14 13.5 1.51
9 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: 0.0435 0.25 2.33 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.472
13 BEAR 2: 0.222 -0.0303 -0.188 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0276
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
12 BULL 1: -0.429 -0.222 1.86 -0.672 0.528 -0.535 0.128 -0.0558 -0.443 -0.158 0.742
13 BEAR 2: 0.25 -0.00271 -0.16 -0.000182 -0.000976 -0.0606 -0.00466 -0.00574 -0.00689 -0.00812 0.101
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Matrix of Variance / Co-Variance
WORKSHEET H[2, 2]
<-------------------------->
A B
13 BEAR 1: 0.0102 0.0056162
12 BULL 2: 0.0056162 0.53927
>--------------------------<
Portfolio Weights
WORKSHEET I[2, 1]
<----------->
A
13 BEAR 1: 0.991
12 BULL 2: 0.00852
>-----------<
Portfolio Variance
WORKSHEET M[1, 1]
<----------->
A
1: 0.0102
>-----------<
Portfolio Volatility
WORKSHEET N[1, 1]
<------------->
A
1: 0.1008002
>-------------<
Expected Portfolio Return
WORKSHEET O[1, 1]
<------------->
A
1: 0.1064703
>-------------<


BULL -bid-> 94.5 Insert in Col-Index: 3 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 16.5 16 13 17.5 17 15.5 15 14.5 14 13.5 1.51
13 BULL 2: 72 90 94.5 12 24 22.5 36 51 52.5 69 28.8
9 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 0.222 -0.0303 -0.188 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0276
13 BULL 2: 0.0435 0.25 0.05 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.244
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 0.25 -0.00271 -0.16 -0.000182 -0.000976 -0.0606 -0.00466 -0.00574 -0.00689 -0.00812 0.101
13 BULL 2: -0.201 0.00587 -0.194 -0.444 0.756 -0.307 0.356 0.173 -0.215 0.0702 0.357
9 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 0 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Matrix of Variance / Co-Variance
WORKSHEET H[2, 2]
<-------------------------->
A B
13 BEAR 1: 0.010308 -3.7781e-007
13 BULL 2: -3.7781e-007 0.14383
>--------------------------<
Portfolio Weights
WORKSHEET I[2, 1]
<----------->
A
13 BEAR 1: 0.933
13 BULL 2: 0.0669
>-----------<
Portfolio Variance
WORKSHEET M[1, 1]
<----------->
A
1: 0.00962
>-----------<
Portfolio Volatility
WORKSHEET N[1, 1]
<------------->
A
1: 0.09807295
>-------------<
Expected Portfolio Return
WORKSHEET O[1, 1]
<------------->
A
1: 0.118142
>-------------<


SIN -bid-> 18.85 Insert in Col-Index: 10 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 16.5 16 13 17.5 17 15.5 15 14.5 14 13.5 1.51
13 BULL 2: 72 90 94.5 12 24 22.5 36 51 52.5 69 28.8
10 SIN 3: 16.1 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 18.9 3.52
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 0.222 -0.0303 -0.188 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0276
13 BULL 2: 0.0435 0.25 0.05 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.244
10 SIN 3: 0 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 -0.138 0.0208
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 0.25 -0.00271 -0.16 -0.000182 -0.000976 -0.0606 -0.00466 -0.00574 -0.00689 -0.00812 0.101
13 BULL 2: -0.201 0.00587 -0.194 -0.444 0.756 -0.307 0.356 0.173 -0.215 0.0702 0.357
10 SIN 3: -0.0208 0.185 0.13 0.0805 0.0359 -0.00472 -0.0442 -0.0819 -0.12 -0.159 0
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<


SIN -bid-> 15.48 Insert in Col-Index: 1 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 16.5 16 13 17.5 17 15.5 15 14.5 14 13.5 1.51
13 BULL 2: 72 90 94.5 12 24 22.5 36 51 52.5 69 28.8
11 SIN 3: 15.5 19.5 22.4 24.7 26.1 26.5 25.9 24.3 21.9 18.9 3.66
4: 0 0 0 0 0 0 0 0 0 0 0
>-----------------------------------------------------------------------------<
Rate Of Return Ri (current - previous)/previous Last column --> Expected Return
WORKSHEET C[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 0.222 -0.0303 -0.188 -0.0278 -0.0286 -0.0882 -0.0323 -0.0333 -0.0345 -0.0357 -0.0276
13 BULL 2: 0.0435 0.25 0.05 -0.2 1 -0.0625 0.6 0.417 0.0294 0.314 0.244
11 SIN 3: -0.179 0.206 0.15 0.101 0.0567 0.0161 -0.0234 -0.0611 -0.0996 -0.138 0.00294
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Ri - E(Ri) Last Col Vol Returns
WORKSHEET D[4, 11]
<--------------------------------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 0.25 -0.00271 -0.16 -0.000182 -0.000976 -0.0606 -0.00466 -0.00574 -0.00689 -0.00812 0.101
13 BULL 2: -0.201 0.00587 -0.194 -0.444 0.756 -0.307 0.356 0.173 -0.215 0.0702 0.357
11 SIN 3: -0.182 0.203 0.147 0.0984 0.0538 0.0132 -0.0263 -0.064 -0.103 -0.141 0.127
4: 0 0 0 0 0 0 0 0 0 0 0
>---------------------------------------------------------------------------------------------------<
Matrix of Variance / Co-Variance
WORKSHEET H[3, 3]
<--------------------------------------->
A B C
13 BEAR 1: 0.010308 -3.7781e-007 -1.1119e-006
13 BULL 2: -3.7781e-007 0.14383 -1.2984e-006
11 SIN 3: -1.1119e-006 -1.2984e-006 0.01627
>---------------------------------------<
Portfolio Weights
WORKSHEET I[3, 1]
<----------->
A
13 BEAR 1: 0.586
13 BULL 2: 0.042
11 SIN 3: 0.372
>-----------<
Portfolio Variance
WORKSHEET M[1, 1]
<----------->
A
1: 0.00604
>-----------<
Portfolio Volatility
WORKSHEET N[1, 1]
<------------->
A
1: 0.07774494
>-------------<
Expected Portfolio Return
WORKSHEET O[1, 1]
<------------->
A
1: 0.121264
>-------------<


SIN -bid-> 12.06 Insert in Col-Index: 2 Go? 0-n/y-1: (1-y-Y | N-n-0) ? ---> yes
ExSan Collector Data Base Last Column Asset Volatility
WORKSHEET A[4, 11]
<----------------------------------------------------------------------------->
A B C D E F G H I J K
13 BEAR 1: 16.5 16 13 17.5 17 15.5 15 14.5 14 13.