my journal 2

Status
Not open for further replies.
Profit Factor vs Return on Account

I will now write a post about Profit Factor vs. Return on Account and reason on which one is best, and if we should use both and when and how and all implications.

I will use this excel sheet for some tests:
View attachment performance_according_to_PF_vs_ROA.xls


PROFIT FACTOR, IS IT ENOUGH?

1)
Ok. Let's first try with simple numbers. Let's try to demonstrate that two systems with equal profit factors are different in terms of ROA and this would mean that it makes sense to use also ROA, next to PF (or maybe ROA alone).

Let's say we have a system that fails once every 3 trades, so it goes like this:
1
1
-1
1
1
-1

very regularly, so regularly that its maximum drawdown is 1 and its Return On Account is the Profit of 10 divided by that maximum drawdown of 1, which returns 10.

This system will have a profit factor of 2, because it would go say to 30 trades, and make a gross profit of 20, and a gross loss of 10, so 20/10=2.

2)
In our second example, we hypothesize a system that also reaches a gross profit of 20 and a gross loss of 10, and therefore a profit factor of 2. But in a different way. If first loses ten times in a row:
-1
-1
-1
-1
-1
-1
-1
-1
-1
-1
And then it wins 20 times in a row. The profit factor is always 2, but we have a system that can make us so desperate that we will stop trading it. Yet, it seems as good as the other system, in terms of profit factor. How does its performance rate in terms of ROA? The profit is, as for the other system, 10 and we have to divide by the staggering maximum drawdown of 10, for a result of... 10/10=1.

So, from these two simplified but not impossible situations, we know that Profit Factor is not enough, and that Maximum Drawdown describes the whole picture, or at least a much larger picture.


RETURN ON ACCOUNT, IS IT ENOUGH?

Let's try to find examples where we can see that ROA is not enough either and that it can be completed with Profit Factor. If we didn't find such examples, it would mean that we can discard PF and just use ROA, which is what I would think actually. And that is why originally I only had ROA.

Let's use our second example again: a system that makes a profit of 10 and has a maximum drawdown of 10, which is quite typical. This returns a ROA value of 1. But how many more ROA values of 1 can we have for systems that are not as good or not as bad as this one? How blind can the ROA be?

Let's see... if we have a system that made a profit of 1 and had a max dd of 1, we'd still score ROA 1. But this would not be a problem , because if we used 10 contracts, the two systems would be the same. So it's not in terms of size that we have to analyze this, because in that sense ROA doesn't fail.

I can think of one example that might cause it to fail.

The first case is when a system makes 30 trades, as in our earlier example, and fails on 10 straight trades, succeeds on 20 straight trades, we will have that mentioned ROA of 1 (profit of 10 divided by dd of 10).

A second case is if a system goes down 10, goes up 20, and then goes up and down, one point at a time, for 200 trades. The final profit will always be 10, the max drawdown will always be 10, and the ROA will always be 1. Yet this second system would not be nearly as good as the first one, because it keeps your capital busy while producing no results. So ROA alone is not enough either.

But how could we measure this difference in performance? The average trade would produce less money, sure, but then we see that even in this case, Profit Factor would reflect the difference:

Gross Profit 20+100=120
Gross Loss 10+100=110

The Profit Factor would decrease from the original 2 to 120/110=1.09, thereby indicating that the system is screwing around most of the time.

Thefore, just as ROA integrated PF in assessing performance, now PF does the opposite. So the two indicators are quite good if used together.

So I am pretty much done, even though I am not capable of seeing all possible situations and implications of these two methods of assessing performance.

Let us recapitulate the 4 examples used above.

The 2 examples for profit factor show that PF fails at measuring how regular a performance is: if a system makes 20 and loses 10, it will be rated the same regardless of the distribution of losses. PF rates my systems in the same way it rates the rolling of a die. If they win 2 times out of 3, it would be like losing only when you get 5 or 6 on a roll. But I wish my systems lost that randomly. Losses instead tend to stick together, and that is what screws me, so PF is definitely not enough.

The 2 examples for ROA show that ROA fails at measuring how much a system screws around, which is instead measure by PF. I am sure ROA fails at many other things, and so does PF, but I can't see them right now.

Those two guys are definitely better than just focusing on absolute profit or even on profit per investment, which in the case of my systems is quite meaningless, since they trade futures and they trade them frequently enough to not be concerned with margin. Besides, margin generally mirrors ROA values. If a system causes me a max loss or a max dd of X, that X is usually closely related to what the margin required is. So I don't want to use an indicator which will measure twice something.
 
Last edited:
10 time zones and their profitability

Ok, what was the purpose of my reasoning above? Because my systems are so bad and I have such little capital, that I was looking for a new way to improve them, and I think I have found and will use it starting tomorrow.

My systems' signals are divided into 10 timezones, 5 for the intraday signals of each day of the week, and 5 for the overnight signals.

These signals are not all as good, and I used to appraise their performance in terms of absolute profit per timezone.

But then came Weighbridge or I don't remember who, and he told me that it wasn't good, because systems might not trade very much on a given day of the week and still make a lot of money in relative terms, and viceversa.

So I started measuring this in terms of average profit per trade.

But this didn't matter much, because I wasn't still using them as a filter.

Today I've realized a need an extra filter, really badly, because I don't want to blow out another account. With this realization, I also thought I should really make sure that average profit per trade is a good assessment of performance.

Then I thought of using Profit Factor, because it's not as hard as ROA to compute, and here it is:
View attachment time_zones_performance_by_profit_factor.xls

The results are similar but not exactly the same as the average profit per trade.

Here's a description of similarities and discrepancies.

Tuesday OverNight signals are unprofitable and therefore have Profit Ratio of less than 1, and this is a similarity, as Tuesday ON also has an unprofitable average trade.

Monday sucks badly on both parameters, and Tuesday IntraDay is the best on both.

Thursday ID/ON vs Friday ID/ON time zones are almost the same for Profit Factor, but in terms of average profit per trade they're quite different.

On Wednesday, for average profit there's a huge difference between ID and ON, but not for Profit Factor.

Why are there these differences?

Well, average profit measures net profit divided by trades. And profit factor is gross profit over gross loss. But should I divide this value by the number of trades? It definitely would make a difference, yet I am not sure why I should do it.

I am kind of tired. I am at work, my brain is overheating, I didn't sleep enough. I am tired from all these sacrifices, years of work... I won't divide it by the trades.

I am basically measuring the Profit Factor of the time zone. I don't see why I should divide it by the number of trades. Profit Factor is already computed according to the regular formula, and it's therefore complete, so there's no need to divide it by the trades.

So what do we exclude? We will use profit factor for sure.

First I will subtract a 1 from all of them, since anything below 1 is useless. This will give me better proportions in their profitability. Indeed a PF of 1.5 seems close to a PF 1.5, but it's 5 times as good.

Ok, I am done. I have reattached the file linked above, and now i highlighted in BLUE and BOLD all the time zones I am planning on trading.

No, wait. I will not trade wednesday ON because it's like just thanks to the WeekDay Bias systems, which I don't trade anyway.

So basically I will just allow the ID systems on all weekdays except Mondays. It sucks but I have to do it, in order to protect my capital. Especially now. It really sucks to keep my systems from trading more than half of the time.

-----

[...]

I am home and I made some more calculations:
View attachment 10_timezone_performance_by_3_parameters.xls

By all parameters, the first used, of absolute profit by timezone, the second of average profit per trade in each timezone, and the latest of profit factor by timezone, the top 5 timezones are always the same ones:

All intraday signals from TUE to FRI, and just one Overnight signal on Wednesday (mostly because of the WeekDay Bias systems).

In general ON systems suck, and Monday entirely sucks as well.

These trends are clearly defined after 1500 trades, with luck obviously cancelling each other out... the trend is quite clear. My ON systems suck and should be kept from trading except the best ones maybe.

All other systems can be allowed to trade, but not on Mondays.

So, I will now work on excel to create timezone filters for every system, allowing exceptions for the best ON systems which would otherwise almost never trade.
 
Last edited:
analogies for finding an edge in system trading

ok so I was thinking of this.

In trading we have... in automated trading we are trying to predict an event: going up or down. Considering our trades are pretty much long term, but we still have to account for commissions and spread costs, which counts in total for about 2 ticks, and considering we make about 100 dollars per trade, which on average is about 10 ticks, so it's like we're trying to predict an event which is already... you get my point an event as rare as 40%, to cover all costs.

So let's look for an event which is as rare as 40% and we have to come up with a system that bets on that event.

Calls from my friend Laura.

If she sends a text message I make my win, and if it's someone else I have a loss. Equal losses and wins.

On average she sends me text messages 40% out of the total amount of text messages.

The system will simply be based on the fact that she sends me more text messages in the weekends. I would back-test a hypothetical phone transcript and verify that every weekend more than 60% of all text messages come from Laura. Then I would proceed to invest based on this statistical study, because my wins would be enough to cover commissions and to produce a profit.

But then if one day Laura gets tired of me not replying, or Laura goes on vacation... all these things could happen, and that is why we need money management. We need to be able to keep on betting for a long time.

Anyway, this is just because I was trying to figure out why it is so hard to find a new trading system that works.

Because, yes initially you would think that predicting the direction of markets has already a 50% probability on your side, from the start. But that's not the case. Due to fixed costs, you are betting on predicting something rare, like rain (in Rome at least). You're not betting on something that happens half of the time, but only 40% of the time, and this is due to commissions and spread costs.

So it's like you can't bet on something almost certain like the sun rising. Actually that would be equivalent to betting that in 10 years the Dow Jones will rise, but we don't care about that kind of returns.

To have more returns, we have to build a system on shorter term events.

Not equivalent to the sun rising, nor equivalent to "it will rain within 12 months". It has to be an event that, all other things being equal, for the average knowledge we have (without studying statistical data), happens less than half of the time (due to costs, as I said more than once).

On top of this, the statistical data has to say that this prediction, on a rare event, has worked for the past 10 years.

That's what makes it hard.

Let's look at some... rather than "rare"... "improbable" events, which doesn't specify how improbable they are. "Slightly improbable".

Let's look for events in our daily lives for events that are slightly improbable and try to devise systems that make a prediction of them happening a profitable prediction, in other words, let's find situations in which a generally improbable event becomes probable.

This will provide us with a good analogy for what we have to do in system trading. It will help us clarify why it is so hard and how we can go about it, to make it easier.

Improbable events in my daily life:
the neighbours not slamming their door
my dad saying something nice and uplifting to me
...

So far no good because those events are more improbable than finding an edge in the markets.

right, the next text message being from laura!

Let's stop here, because I find this hard to do... and I want to finish the post.

So here's what I would think of, before betting that the next text message is from laura:
1) in the weekends she writes more, but even betting on it in the weekends would only bring my probability, after costs, to a 50% chance of being profitable...

Thinking... thinking...

Got it:

2) the fact of her not calling for a while would, in the short term... wait. If she didn't write any messages for a while, and then she writes one, asking me to go to dinner, then, once I reply, I can bet that the next message I'll get is from her rather than from someone else. And this system most likely would be profitable on all securities (people's text messages).

No matter whose messages you're betting on, this is an edge. If you get a message from someone and you immediately reply (except if it says "happy birthday" and similar), probability is on your side if, after replying, you bet that the next message will be from the same person. Unless of course you're extremely social and receive dozens of text messages per day.

We just found how an otherwise improbable event becomes probable in certain situations.

A similar edge in trading can be found with "volatility breakouts" or similar. If you have a security that's not going anywhere (no text messages from a person) and all of a sudden it starts going somewhere (you start exchanging messages), you bet that it will continue (you bet that the messages will continue).

A similar thing, but that doesn't have to do with a volatility breakout is simply a trend reversal. If you see price just going down and down, and all of a sudden it starts going up, chances might be on your side if you bet that it will continue for a while. But, interestingly, sometimes I found the contrary to be true. It depends. Anyway, I still have not found a system where your % of wins (with equal wins and losses) is 90%. I hear people talk about such systems, but I never got higher than 75% of wins, with the Opening Gap systems, but they trade very rarely unfortunately, so they're outperformed by systems with much lower edges.
 
Last edited:
bad memories about people I resent

I never got into a fight in my life. I remember I pushed a person once, because he was behind me and he tried to trip me. Not much more than that. I never punched anyone and was never punched.

This was not really a choice but the way I was brought up. If I was in control of myself, I would never attack anyone and avoid physical fights at all costs, unless of course I lost control, which happened as I said a couple of times. Another time I jumped a bully, but it was a ridiculous situation and luckily they separated us, or else I would have gotten hurt.

Anyway, what I am getting at is that I never got into fights but I have put up with a lot of humiliations, because once people realize that you're peaceful, some people, a small percentage will take advantage of that.

Now, these people are not doing anything smart, because overall their behavior is not convenient. Sooner or later they all get in trouble for abusing other people. It's not a convenient attitude to be a bully.

But I don't know how convenient it was for me to be a peaceful "show the other cheek" person.

Most people bluff and pretend they're willing to get into a fight any time, and this way they get a lot more respect than I do. Instead I either fight or I don't pretend that I would fight, and this lack of bluffing has caused me a lot of abuse.

Yeah, because the situations in which I am willing to fight are very rare, and even then, it would not be good to lose control and to be willing to fight until the end, because in that case you might really end up getting killed. So I am tough at the wrong times, and only when I lose control and stop reasoning.

I don't like walking with a threatening posture like most people do. I don't like this kind of bluffing.

Because you might meet, actually you do meet a majority of friendly people and it doesn't make sense to show them a hostile face or posture.

I don't know... I don't like this world, at least the people who have been around me most of my life. I liked some countries in Northern Europe, where people are generally polite.

Here in Italy, especially in Rome and the South, the norm is aggression and unfriendliness. But even in the States, it kind of sucks.

My type of people is the computer science people, the people in Boston for example, the vegetarian people, the scandinavian people, the intellectuals. But then in the US you have the "frat" brothers, who are college students but whom I have nothing in common with. Those confrontational *******s, always looking to be rude to someone.

Well, as I was saying, I remember once I was in college in Boston.

And I was with my friend, another philosopher like me, we were going to a "party", I hate this word.

So we went and until then and after then I never had a similar problem, but there was this one "brother" in front the house, who lived there, and he said to me "you are not getting in". It was many years ago, but the memory stuck with me all these years, and I still resent that guy very much. I think about him several times a year, and how he told me I couldn't get into his party, and what I should have replied. I replied nothing, because I don't bluff. Should I have pretended that I was going to get into a fight because he said that to me? No, because it wouldn't have been fair.

But probably he told me that, precisely because he could tell he would have gotten away with telling me that. One time, in Boston, one girl in the street approached me and asked me if I'd be her friend and take her out to lunch. It turned out she was stripper from miami. I asked her why she approached me in particular. And she said I looked like a nice guy.

So in the same way, this guy told me "you're not getting in", because i looked like a nice guy, and also because he didn't like me. Maybe he felt I was a "euro-trash", which is... like "the rich europeans, stealing our women"... or something similar. I think if he saw me with blond hair, freckles, a beer belly... a baseball cap... he would have let me in. I was too refined, too peaceful... i didn't look tough and rough enough... so he told me "you're not getting in".

This and other sad memories stuck with me. Because my mom taught me not to beat up other children, and it all began from there. And now I have a big resentment towards all these people who took advantage of it.

I have my file with a list of about 30 events of abuse I took in my life, which resurface in my mind from time to time, several times per week, at least lately.

Not that I want to have these people killed, but i feel I am not willing to take any more of this abuse. I would like to have a way... but the most abusive person, emotionally, has been my dad, who's threatened me verbally and humiliated me in several ways and situations, mostly uncalled for.

He's the person I have the most resentment against. My mom taught me to put up with abuse without defending myself, and my dad was the first person who took advantage of it, and on top of it, he got me used to the idea that I was not worthy of respect, got me used to be humbled (by him)... I have a lot of resentment for all this. He's on top of my "people I resent" list.

These people are basically all people who never played a fair game with me. People who don't play fair in life. They make fun of someone in a difficult situation, they attack someone in a weaker position, they don't help you when you need them, but they're expecting to not behave like them, know you won't, when you will be in the same situations. They rely on you playing by the rules, when they don't. All bullies do not play by the rules. The main rule is "don't to others what you wouldn't want them to do to you, regardless of the fact that you might be able to get away with it". Behave fairly to people. Don't slam your door, don't laugh at someone who's having a difficult time, don't gang up on someone, don't talk loudly, don't wake up people in the middle of the night, don't steal, don't ruin people's property... you get my point. I am upset about injustices against me. Verbal abuse mostly. I have a feeling that the biggest injustices tend to be done against the nicest people. The more you play by the rules, the more people who don't play by the rules will come to play a game with you. "Foul play" i think is called, at least in Italian it translates literally to that. The concept exists everywhere, but the percentage of people who play fairly changes from country to country.

Like that neighbour now... he just slammed his door, the one below me. And yet he came up to here complaining we were moving chairs, and I replied politely "I am sorry" we will try to stop, even though it was before midnight and it only happened once a year, and he said he was going to call the police. Now that ******* slammed his door. How would he react if I went to him and asked him not to slam his door because it bothers me? Not well. And that is why I don't go to him telling him that. But if he comes to me... you see? I am playing by the rules, and I think it is the most convenient thing to do, because I never get in trouble, whereas this guy risks getting in trouble continously by abusing others and by attacking them if they slightly bother him. So I am doing the most convenient thing, but I am left with a sad feeling of being abused. It would feel much better to just reply "**** you". But I don't, because it's my second nature by now to not say "**** you" to strangers, nor to anyone.

So I guess I've lived a peaceful but humbling life until now, and I am not happy with it, but maybe i'd be unhappier if I got punched or similar. Or if I went to jail for punching someone.

Anyway, my dad has always been a fault-finding control freak, and he criticized me for everything i did, treated me with contempt, tried to shape my behaviour according to his desires in every little detail, such as my haircut, my shaving habits, how i walked... everything. Never any encouragement, just criticism and sarcasm. No wonder i never felt any affection for him. The best I can say about him is that he is sick. His deficiencies outweigh his qualities, which could be intelligence, precision, efficiency. I don't think the fact of being an efficient person should entitle you to treat everyone else like ****.

I came back to add something important that I forgot to say. The most violent place i found in my life was the States, but maybe not because of the place itself but because of the age I lived there. It makes no sense to generalize. However, I would generalize and say that northern europe in general is more peaceful.

Anyway, the two violent things that happened, the two negative things I didn't like in terms of aggression in the states were these:

1) "you are not getting in" from that guy i mentioned at the frat house
2) this is the worst offence: a pepsi half a liter plastic bottle thrown at me from a running car, while the guy said "have a pepsi!". It hit me in the head and this memory resurfaces in my mind even more often than "you are not getting in".

(TO BE CONTINUED... in future posts)

 
Last edited:
Getting rid of Sugar as well... SB (So Bad)

Sugar, SB at ICE (aka NYBOT).

It only trades half of the time. Did you know that? Forget building a system on it. It's got all its weird expirations, and it only trades half of the time, it has lower volume than the others... forget about it.

So now, besides my 9 futures, I will only have to add systems on AUD, CAD, CHF, NG (Natural Gas).

But let us study in depth what SB's schedule is and why it had escaped me that it only traded half of the time.

https://www.theice.com/productguide/ProductDetails.shtml?&marketId=860080
NEW YORK
3:30a-2:00p
03:30-14:00

http://www.interactivebrokers.co.uk...ion=Conid Info&wlId=IB&conid=72369115&lang=en

Damn, for some reason IB doesn't have the schedule, as it usually has.

Anyway, sugar only trades for 10 and a half hours per day, look even here on the IB chart:

Snap1.jpg

On the chart above, you see 11 candles per day, of which one is only half an hour, the first one.

How on earth did I think to test and automated a system on a future that trades less than half a day? Simple. With all the different and complex schedules they have, different timezones, different exchanges... I thought I'd first buy the data and then find out what was the deal, expecting the schedule to be good enough, since also the volume was good enough. And yet I was wrong. I was wrong because these agricultural mother ****ers... are different in everything.

Out of all these ****ers I started with, 3 of them are no longer with us. Sugar is the latest to have departed. Soybeans was too expensive and he had to go. Same for Corn.

The only good data with good volumes with good hours is the three extra currencies, which are definitely good by all standards. And the Natural Gas, which has great volume and the advantages of:

1) not being correlated at all with OIL
2) having the same exchange, schedule and expiration as OIL
3) using the metric system, unlike the ZN mother ****er

Yeah, natural gas and CL are just good.

With these 13 futures I am done. If anything I will add systems to all markets, but not markets to the systems at least for a long time.

So we are going to be trading 13 futures markets: 6 currencies, 2 interest rates, 2 energies, 2 stock indexes, 1 metal.

Given that I have 40 systems on the existing 9 markets, I will have about 60 systems on 13 markets. This is a good deal. Now I can't do it though, because I am too busy with implementing a good money management on the existing systems. I will worry about the rest once I am done with these. Also I have been busy with testing the new server and it will be great progress if I can get it to run smoothly from now on.
 
Last edited:
Homo Futurus

Homo futurus, no pun intended. Good documentaries as usual, from youtube.

 
Re: some doubts about reversing systems...

I think you must trade what you backtest, otherwise you are trading discretionary. If your backtests show a big improvement with reversing then that is what you must do. I don't think you should give them a chance, though I know it is painful.

If it makes you more comfortable, I subscribe to a market newsletter written by a successful futures trader (for >20 years)... he says EUR needs to get over 1.37 to be a buy. Before then the trend is down

I've got to agree with Dog4.

I mean, regarding backtesting, not re the Euro. Re the Euro, being a mechanical trader means I don't have to have an opinion on it. :LOL:

But the backtesting - definitely.

I held back saying it until now, but are you absolutely 100% sure your systems are working live as they should, as they do in simulation? I mean I was really surprised when you said you had a losing week, since I thought your stats gave you very good odds of having a winning week. I would just double check, triple check everything just to be sure, just to keep my confidence up, to stop me trying to second guess my system. How many of the Market WIzards can be quoted saying that they couldn't handle running their systems for their companies because their companies kept on second guessing the system? Ed Seykota, Larry Hite, and more I'm sure.

I don't envy your drawdown and I don't want to make it worse but I think the only thing you can do is check your system - if there's nothing wrong with it, then stick with it. EZ 4 me 2 say :jester:
 
When you have a small capital like mine, even praying can be justified, even if you are atheist.

Sure, if I had 100k, I'd simply apply my systems, entirely as they are. But when each loss endangers my little (borrowed) capital, you can't blame me for being extra careful, and even changing my system. Or feel free to blame me, but then I'll blame you for titling your thread "deadline june", which is rushing you to start trading when you might not be ready for it.
 
Last edited:
more on evolution



Watching the fourth video of the Homo Futurus series (this one's particularly interesting):



These videos on human evolution are making me understand my neighbours better, and all rude people in general. They're the remnant of the past. Like old species which one day will probably become extinct, and I am stuck having to live with them, because I was born in the wrong era.

No, wait, wrong reasoning. We're all the same in terms of biological evolution, so they cannot become extinct. The difference between us is entirely in terms of cultural evolution. If we were to consider my education the average and their education the average, I'd say we're about 100 years apart, at least in terms of european culture. My cultural evolution is above average (by European standards), and theirs is below average. That's why I cannot get along with these mother ****ers.

They slam doors and I don't. It's like the ancient Romans, those ****ers had people killed for fun, but now it doesn't happen anymore. 200 years ago there was slavery. And now it doesn't happen any longer. 100 years ago there was death penalty, and now it doesn't happen any longer (I am always referring to europe). Now people slam doors, and one day people won't do it any more hopefully. Biologically we are more or less like the Romans who had people killed for fun, 2000 years ago. Culturally we're not the same. Biologically I am the same as these guys, culturally I am not.

Potentially, if you were able to place any one of us back in time, 2000 years ago, the same person would grow up to go see the gladiators kill each other for fun. If you think about it, it isn't much different when people go to watch a boxing match, or watch it on tv. Yet, the number (in percentage terms) of these uncivilized people has been decreasing over the centuries, so that we can say we're culturally more evolved than 2000 years ago. Of course there are, even today, people who would find it entertaining to watch people kill each other. But they are fewer than 2000 years ago (in percentage terms).

I can now view my neighbours as part of a different species, if not biologically, culturally (which would make my using the term "different species" improper), and can accept them just as I would accept a dog barking. Of course, if I could, I would kill the dog in his sleep, or at least try to make him go away from my neighbourhood. The same I would do with my neighbours I guess. But I would not do it for fun, so I guess I am more evolved than those Romans who lived 2000 years ago. I guess I could qualify as a nazi in terms of tolerance. What am I saying... this is ridiculous. Sure, I'd have the neighbours murdered, and with great pleasure, but that doesn't make me a nazi. I just want people to be polite and I am not advocating murder for any other reasons.

Anyway, forget about all this and let's get back on track.

I really like what Phillip Tobias says here in the video below:
Evolution is the exception, extinction is the rule.
I will need to think about this for a few days, as it also concerns my systems. Most of the systems I created became extinct, and, of the 40 living systems that I have today, only 20 are really good. Eventually I will be using a small part of all the systems I've created and used over the years.

Even of the 40 systems I am using today, they all went through hundreds of changes, so we could even say that as far as them, extinction is the norm, if we count all the different versions of them that have existed. On the other hand this could be just crap, because even most humans are dead and just a minority are alive today. Let's forget about this depressing crap and watch these videos.

 
Last edited:
Beatles videos


There's four videos on the series above. More interesting videos:









 
Last edited:
moving average on excel

As I wrote here:
http://www.elitetrader.com/vb/showthread.php?s=&postid=2815292#post2815292

I've decided to simplify my moving average macros, because if I want to expand to 13 markets, the present ones will be too heavy for my CPU.

I have these automated self-updating moving averages, which basically are (for each market) the average of the prices of the last x minutes, polled once per minute.

So this means the macros print price once every minute.

Someone else had written these macros for me years ago, and until now, being an amateur VBA programmer, I still haven't fully understood the code.

This would not be a problem, because they work but the reason I want to understand them is to simplify them, because I started off with just one moving average and now I will need about 13 of them, on different markets.

Here's the macros:

1) Everything starts from this macro, which gets started by "ThisWorkbook":

Code:
Sub ma_timer()
For i = 1 To 500
ma.Cells(i, 1) = tickers.Cells(12, 20)
Next
TimerOn 60000
End Sub

And this is clear but I don't know what happens next

2) Then we get on another sheet, where I have all these macros:

Code:
Private Declare Function SetTimer Lib "User32" _
(ByVal hWnd As Long, ByVal nIDEvent As Long, _
ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long

Private Declare Function KillTimer Lib "User32" _
(ByVal hWnd As Long, ByVal nIDEvent As Long) As Long

Dim averageprice(2) As Double
Dim minutes As Integer
Dim TimerID As Long


Public Sub TimerOn(Interval As Long)
On Error Resume Next
TimerID = SetTimer(0, 0, Interval_eur, AddressOf myroutine)
End Sub

Private Sub myroutine()
On Error Resume Next
minutes = minutes + 1
averageprice(0) = averageprice(0) + tickers.Cells(12, 20)

If minutes = 1 Then
For i = 1 To 499

ma.Cells(i, 1) = ma.Cells(i + 1, 1)

Next
meu.Cells(500, 1) = averageprice(0) / minuti


Erase averageprice
minutes = 0

End If

End Sub



Please let me know if you can help me. It works but I don't know why, and I would like to understand it in order to simplify it and not have these macros multiplied by 13, because it would be too heavy for my CPU.
 
more on evolution

This is very very well made:


http://en.wikipedia.org/wiki/Recent_African_origin_of_modern_humans


This video (part 4 of the same series as above) in particular explains very clearly the difference between biological and cultural evolution, and explains how we're no different (not more intelligent) than the people in the stone age. The whole difference is given by cultural evolution. Everything we become we merely owe it to those around us and not to our own intelligence. If we were placed at birth in the Stone Age, we would grow up to be exactly like them, and viceversa.



More interesting stuff:

 
Last edited:
beatles by fargenbastich

This guy is quite peaceful, modest, and good. It's a pleasure to listen to him and it's amazing how easy he makes it look. He did a great job at simplification. A great artist and perfectionist. Try to listen to the other amateurs on youtube playing the beatles and you'll see the difference. Some songs he sings even better than the beatles themselves.
















 
Last edited:
moving average on excel - part 2

Resuming from here:
http://www.trade2win.com/boards/trading-journals/85510-my-journal-2-a-72.html#post1110940

It worked out and I simplified it as much as this:

Code:
Private Declare Function SetTimer Lib "User32" (ByVal hWnd As Long, ByVal nIDEvent As Long, ByVal uElapse As Long, ByVal lpTimerFunc As Long) As Long

Sub time_ma()
For i = 1 To 500
ma.Cells(i, 1) = time
Next
TimerID = SetTimer(0, 0, 15000, AddressOf myroutine)
End Sub

Sub myroutine()
On Error Resume Next
For i = 1 To 499
ma.Cells(i, 1) = ma.Cells(i + 1, 1)
Next
ma.Cells(500, 1) = time
End Sub

This is the last part of the old workbook's code (written by a friend in 2005) that still escaped me. Now it will require some testing on IB's paper trading account, to finally be able to implement it. I want just one worksheet with a hole 13 different moving averages (the 13 futures I will trade).

More about this function here (the folks on ET helped me more than you guys):
http://www.elitetrader.com/vb/showthread.php?s=&postid=2816034#post2816034

This little thing is a beauty. It can be used on anything you want: temperatures, rain... anything on the internet that gets updated: View attachment ma.xls.
 
Last edited:
Status
Not open for further replies.
Top