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

Recommended Posts

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

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

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
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

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

@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.


  • Topics

  • Posts

    • ...hallucinates.... Student: “What if we gave the monkey LSD?” Guru: “The monkey already did LSD”
    • Question: To those that had/have cancer, what were the signs that made you think “something is not right here” to make you go see a doctor? Answer: So, 5/25/2018, I woke up, got ready for work, and as I walked to my car, I started gagging. Like something was stuck in my throat and I needed to clear it. And then it went away.   But 10 minutes after that, I was T-boned at 40mph on the driver side door. But what made me see a doctor was while my muscles felt better and bruises were going away, the gagging still continued, I started having fevers, my neck felt swollen, I was having such a hard time breathing, and I'd have random sharp pains in my chest, but not from where the seat belt saved me.   2 weeks after the accident, I finally see an urgent care doctor, who looks me over, tells me I'm fine, but luckily requests a neck X-ray. And I ask for a chest X-ray, which he rolls his eyes but let me have (most of my pain was in the neck, so I understand).   The very next day, he calls and says “So, that chest X-ray shows there's a 4 inch mass on your heart and lungs, and your lungs have been filling up with fluid, as well as in your pericardial (heart) wall. We need you to come in tomorrow.”   Turns out the big mass, due to the accident, caused my heart and lungs to tear and fill with fluid, the swollen neck and gagging was caused by 2 metastasized tumors, and the fevers and weight loss were symptoms. Stage 4b Hodgkin's Lymphoma.   But thankfully, we went very aggressive with chemo (and had a lot of bad side effects that don't normally happen to patients), and now I'm about 16 months cancer-free. Yay lucky X-rays! Rachel Jurina, Quora Source: https://www.quora.com/To-those-that-had-have-cancer-what-were-the-signs-that-made-you-think-something-is-not-right-here-to-make-you-go-see-a-doctor   Profits from free accurate cryptos signals: https://www.predictmag.com/  
    • As a man, the reality of life is the harshest part. I don’t mind looking older or becoming weaker over time; it’s nature.   Have you ever heard that the only people who will be loved unconditionally are women and children? Men will only be loved as long as they can provide until they are no longer needed. It doesn’t matter if you already did your best to get your kids to the best school or get the best things for them, if you stop before they’re done with it, there will be no thank you. The only thing they will remember is that they have to quit school at 15, ignoring all the previous 15 years of life you provided for them. The only people who will accept you, no matter what, are your parents. But in this situation, you might be that ungrateful child.   EDIT: Wow, I didn’t think this would get so much attention.   For those who disagree, I can only say that everyone has their problem. If you don’t get the chance to face such a thing, be grateful. Remember, sometimes what you throw in the garbage is something that someone wishes ever to have.” – ElZee, Quora   Profits from free accurate cryptos signals: https://www.predictmag.com/    
    • The good thing i had noticed so far is that the traderpot value is also on the rise..
    • yup its a gradual rollout the right way in my opinion, its really good and its exciting for the sto in 2027
×
×
  • Create New...

Important Information

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