Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

DutchDandy

Statistics

By DutchDandy, in Automated Trading

Recommended Posts

DutchDandy    10

DutchDandy
Posted

Hi all,

 

I have been busy crunching data for a while, because I have found a partner that does an excellent job with algorithmic trading. But I came to a hold, because statistics isn't my best skill. And I want to spot a correlation between, movement/volume etc. That is the easy part, thanks to Excel.

So what I now need is to have a tool to automaticly use the right sample size. Haven't found the function in Excel for that. When I have the right sample size, I want to have Excel tell me when a change in the stock is significant. (Change in volume and stock price).

 

The whole idea is very simple yet clever. I have set a criterium for the stocks, price range and public trade stock. You will be having a list over 500 stock, these stock tend to do nothing really. But when the algo spots a change in volume of stock price, I need to know if that move is significant enough.

 

:missy: Any Excel-wizard or statistic-geniuses around to help me out?

 

Cheers

Share this post

Link to post
Share on other sites

DutchDandy    10

DutchDandy
Posted

He is good at setting-up the rules. But you have a point....

 

My input is more analyzing my own trades and put them in to a rule. Since I don't trade like a robot, I need to set-up a couple of rules. I trade patterns and that is why I need to translate what I see as a significant increase of price and volume it to a rule. Because I want to test out a couple of statistical tests, I want to check my own historical trading data. :missy:

Having Excel calculating the sample size etc., would help me to see what I did good and wrong.

Share this post

Link to post
Share on other sites

SIUYA    11

SIUYA
Posted

first you had better work out what you want....it seems a bit confusing....

do you want a function, or data (as a sample size)......

 

"So what I now need is to have a tool to automaticly use the right sample size. Haven't found the function in Excel for that. When I have the right sample size, I want to have Excel tell me when a change in the stock is significant. (Change in volume and stock price). "

 

.............. I need to know if that move is significant enough."

 

OR do you want to analyse past trades?

 

"Because I want to test out a couple of statistical tests, I want to check my own historical trading data"

 

The best way to get frustrated asking for computer programming help is to not know what you want to do and be very clear about it.

Share this post

Link to post
Share on other sites

DutchDandy    10

DutchDandy
Posted
first you had better work out what you want....it seems a bit confusing....

do you want a function, or data (as a sample size)......

 

"So what I now need is to have a tool to automaticly use the right sample size. Haven't found the function in Excel for that. When I have the right sample size, I want to have Excel tell me when a change in the stock is significant. (Change in volume and stock price). "

 

.............. I need to know if that move is significant enough."

 

OR do you want to analyse past trades?

 

"Because I want to test out a couple of statistical tests, I want to check my own historical trading data"

 

The best way to get frustrated asking for computer programming help is to not know what you want to do and be very clear about it.

 

You are right, might not have been totally clear.

 

I want to project my past good trades, on a set of rules. When I look at the historical charts of the stocks I played, I see a significant change in the pattern of the price and volume. I need a set of rules that can tell me if a future change is significant. To do so I check my past trades and check how significant a change on the charts really was. That is why I need a function that automatically calculates the sample size (# of tick data) .

 

When you watch over 500 stock, you really need the right sample size to have a clear idea if the change is significant for that moment. With a too large sample size the variation is too large and with a too small sample size all the changes become significant.

 

I now use a static rule on the sample sizes. (5/10/20/60/260 days). I want to have it automatically.

 

By the way, for me a significant move is at least 2*SD.

Share this post

Link to post
Share on other sites

SIUYA    11

SIUYA
Posted

probably because it sounds like a rather large project....or its not being well described.

 

You would be best to write up what you are trying to achieve using an excel spreadsheet as en example on just a few stocks to show exactly what you are trying to get at. This way its clear to those who might wish to help.

If its relatively simple then some suggestion might be made....if its complex then you might need more professional help and they will require such a write up to bes tunderstand what you are trying to get at.

 

mainly as this still is hard to follow......

"I want to project my past good trades, on a set of rules. " What rules?

"When I look at the historical charts of the stocks I played, I see a significant change in the pattern of the price and volume. I need a set of rules that can tell me if a future change is significant. " ????? do you want someone else to provide rules?

 

"To do so I check my past trades and check how significant a change on the charts really was. That is why I need a function that automatically calculates the sample size (# of tick data) ."

 

/.....it might just be a language barrier, but for me an example is required from you to help people.....who might then be able to help you.

Share this post

Link to post
Share on other sites

OFA_trader    10

OFA_trader
Posted

@DutchDandy

So far what I have understood is that you are looking for a statistical algorithm which will scan all your data set and then come up with the relevant number like 30,000 is the change in volume and 2 is the change in price then most of the time that scrip rallied. It was just an example.

If that is what you're looking for or that kind of analysis then I will strongly recommend use proper statistical software like Revolution R or Matlab. Excel has lot of limitations, and best thing about these softwares is that they are capable to produce add on for Excel itself. So if any function is absent in Excel then Excel will use Matlab's functions in the form of that add-on.

Regards

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go To Topic Listing

  • Topics

  • Posts

    • RJo
      Scalping System

      By RJo · Posted

      @sxiqxx, Well done on making your first post a promising strategy. @everyone, post up if you want this coded into an EA. Although I switched to TradeStation, I still have an active MT5 demo with MetaEditor. I can code it without referencing object oriented programming which should be retroactively compatible with MT4. Let me know...
    • RJo
      What are the biggest lessons you have learned in the corporate world?

      By RJo · Posted

      Please allow me to retort (in jest): RESPONSE 1 : Get a job supervising others where you're in control of performance reports and ride those others 100%. This makes your performance 100% with little to no effort.   RESPONSE 2: Feel free to piss off your boss but stay nonviolent. When the side effects of his viagra and testosterone boosters cause him to physically assault you, you have the legal upper hand. This can result in a boatload of trading capital.   RESPONSE 3: Feel free to have intimate relations with your boss if she finds you attractive. Rest assured that mum's the word because once again, you have the legal upper hand. This can also result in a boatload of trading capital.   RESPONSE 4: Don't be fake friends with any enemies... unless you need information from them. Being fake friends with everyone will cause you to become an empty shell of a person with no direction in life.   REPONSE 5: Get your boss to become reliant on your performance (really, just the performance of your subordinates), and then plan an "overheard" conversation wherein you fake an interview with another potential employer. You'll probably get a pay increase or a promotion.   RESPONSE 6: If you can give your 75% percent to a project, give 50% and rely on your legal upper hand(s). Learn to write trading algo's during your other 50%.   RESPONSE 7: Take all of the office boys out to nightclub where you merely sip soft drinks on a weeknight. Upon your return to the office in the morning, inform the security guards that all of the office boys are intoxicated. Your boss will love you for it.   RESPONSE 8: Never try to prove your client wrong or find faults in their processes, but do secretly collect their information in case you jump ship or "someone you know" decides to start his own company.   RESPONSE 9: Never stay in a firm for too long. Instead, use your ill-gotten capital to exit the rat-race and start trading.   RESPONSE 10: Trading pays more than your career. Interpersonal skills are now irrelevant. Use your technical skills for trading. Never stop learning and keep updating your technical skills.😁
    • aimhi
      Anybody trading with Wyckoff

      By aimhi · Posted

      There are a lot of trading strategies like elliot waves, wyckoff etc so we need to apply those who best suited to our need and are understandable too.
    • aimhi
      Scalping System

      By aimhi · Posted

      Scalping can be good during the high volatile markets however the new traders should be careful while entering and exiting the markets too quickly since they can make losses as well. If the broker support news trading we can make most out of the scalping in my opinion.  
    • aimhi
      Candlestick for profits

      By aimhi · Posted

      In my opinion these candlestick charts are more easier to understand as compared with the other charts.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.

  I accept