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

    • MRCY Mercury Systems stock, watch for a top of range breakout above 47.36 at https://stockconsultant.com/?MRCY
    • Date: 21st March 2025.   Gold is Up 14% in 2025 But Has It Peaked?   Gold prices fell on Thursday for the first time this week after reaching a new all-time high. The asset’s safe-haven status drives its bullish trend as the White House confirms new tariffs on April 2nd. On the other hand, the decline, which continues this morning potentially is due to fears the price is overbought or at its peak. Why Is Gold Increasing in Value? The main bullish price driver for Gold is the risk appetite of the market due to fears of a recession. Even the White House acknowledges a short-term downturn, though the administration calls it a ‘transitional period’. A potential recession has also been mentioned by economists including the previous Treasury Secretary, Lawrence Summers, who advises the chances of a recession in 2025 is around 50%. The possibility of a recession due to the new trade policy is not only driving the price of Gold but also bond yields and the stock market. The SNP500 has fallen almost 11% over the past 4-weeks. The risk appetite of the market can be seen through the poor performance of the stock market. Furthermore, the VIX index has fallen almost 11% while demand for bonds has risen. In addition to this, the Federal Reserve made it clear that there is no clear sign yet that the economy will not experience a recession but does expect lower economic growth. The Federal Reserve reduced its projections for the US GDP Growth Rates. The Chairman of the Federal Reserve told journalists that the central bank will continue its wait-and-see approach due to the uncertainties of the trade policy. The Federal Reserve will opt for a reactive approach rather than a proactive approach which may unnecessarily push inflation higher. Trade Tariffs on April 2nd Donald Trump imposed 20% tariffs on all Chinese imports, along with 25% duties on goods from Canada and Mexico. He also enforced 25% sanctions on imported steel and aluminium, prompting retaliatory measures. Meanwhile, unemployment rose to 4.1%, retail sales by only 0.2%, and business activity remained sluggish. Treasury Secretary Scott Bessent warned of a potential US recession, and experts suggest that if the trend continues, the Federal Reserve may adopt a more ‘dovish’ stance, pressuring the US dollar. At 20:00 (GMT+2) today, investors await the regulator’s meeting results and a new dot chart forecasting interest rate cuts. Any signal of borrowing cost adjustments could drive XAU/USD prices upward. XAUUSD (Gold) - Technical Analysis The price of XAUUSD this morning during the Asian Session fell, forming a lower swing low for the first time since March 10th. The question which most traders are now asking is whether the price will now continue retracing downwards. Currently, the price in the medium term remains above the 75-EMA and above the 100-SMA which indicates the price still maintains its bullish bias.     However, the price below the VWAP and order flow shows that so far sell orders outnumber buy orders. Therefore, due to the mixed signals, the volatility in the short term will be vital for technical analysts. For example, if the price falls to $3,026, 65% of the retracement has regained downward momentum potentially indicating a downward trend in the short term. Alternatively, at $3,027.90 the instrument will form a bearish breakout which again potentially indicates downward momentum. However, if the price increases above $3,034.17, a bullish breakout would have formed and the price will be again trading above the main Moving Average. Key Takeaway Points: Gold prices surged to an all-time high before dropping, possibly due to overbought concerns. Economic uncertainty and trade policies fuel demand for gold, bonds, and a declining stock market. The Federal Reserve acknowledges economic slowdown risks but remains reactive rather than proactive. The US plans tariffs on China, Canada, and Mexico, contributing to market volatility and economic concerns. Always trade with strict risk management. Your capital is the single most important aspect of your trading business.   Please note that times displayed based on local time zone and are from time of writing this report.   Click HERE to access the full HFM Economic calendar.   Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE!   Click HERE to READ more Market news.   Michalis Efthymiou HFMarkets   Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in Leveraged Products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • PLTR Palantir Technologies stock, watch for a local breakout, target 106 area at https://stockconsultant.com/?PLTR
    • I wonder how we can use these timeframes lower than the one minute yet they might be helpful for high frequency trading bots. 
    • Prizes won are kinda satisfaction and acknowledgement for the success achieved among the other contestants in my opinion.
×
×
  • Create New...

Important Information

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