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

    • AMZN Amazon stock, nice buying at the 187.26 triple+ support area at https://stockconsultant.com/?AMZN
    • DELL Dell Technologies stock, good day moving higher off the 90.99 double support area, from Stocks to Watch at https://stockconsultant.com/?DELL
    • MCK Mckesson stock, nice trend and continuation breakout at https://stockconsultant.com/?MCK
    • lmfx just officially launched their own LMGX token, Im planning to grab a couple of hundred and maybe have the option to stake them. 
    • Date: 2nd April 2025.   Market on Edge: Tariff Announcement and Volatility Ahead!   The US economic and employment data continues to deteriorate with the job vacancies figures dropping to a 5-month low. In addition to this, the IMS Manufacturing PMI also fell below expectations. However, both the US Dollar and Gold declined simultaneously following the release of the two figures, an uncommon occurrence in the market. Traders expect a key factor to be today’s ‘liberation day’ where the US will impose tariffs on imports. USDJPY - Traders Await Tariff Confirmation! Traders looking to determine how the USDJPY will look today will find it difficult to determine until the US confirms its tariff plan. Today is the day when Trump previously stated he would finalize and announce his tariff plan. The administration has not yet released the policy, but investors expect it to be the most expansionary in a century. President Trump is due to speak at 20:00 GMT. On HFM's Calendar the speech is stated as "US Liberation Day Tariff Announcement". Currently, analysts are expecting Trump’s Tariff Plan to impose tariffs on the EU, chips and pharmaceuticals later today as well as reciprocal tariffs. Economists have a good idea of how these tariffs may take effect, but reciprocal tariffs are still unspecified. In addition to this, 25% tariffs on the car industry will start tomorrow. The tariffs on the foreign cars industry are a factor which will particularly impact Japan. Although, traders should note that this is what is expected and is not yet finalised. Last week, President Trump stated that he would implement retaliatory tariffs but allow exemptions for certain US trade partners. Treasury Secretary Mr Bessent and National Economic Council Director Mr Hassett suggested that the restrictions would primarily target 15 countries responsible for the bulk of the US trade deficit. However, yesterday, Trump contradicted these statements, asserting that additional duties would be imposed on any country that has implemented similar measures against US products. The day’s volatility will depend on which route the US administration takes. The harshness of the policy will influence both the Japanese Yen as well as the US Dollar.   USDJPY 5-Minute Chart   US Economic and Employment Data The JOLT Job Vacancies figure fell below expectations and is lower than the previous month’s figure. The JOLT Job Vacancies read 7.57 million whereas the average of the past 6 months is 7.78 million. The ISM Manufacturing Index also fell below the key level of 50.00 and was 5 points lower than what analysts were expecting. The data is negative for the US Dollar, particularly as the latest release applies more pressure on the Federal Reserve to cut interest rates. However, this is unlikely to happen if the trade policy ignites higher and stickier inflation. In the Bank of Japan’s Governor's latest speech, Mr Ueda said that the tariffs are likely to trigger higher inflation. USDJPY Technical Analysis Currently, the Japanese Yen Index is the worst performing of the day while the US Dollar Index is more or less unchanged. However, this is something traders will continue to monitor as the EU session starts. In the 2-hour timeframe, the USDJPY is trading at the neutral level below the 75-bar EMA and 100-bar SMA. The RSI and MACD is also at the neutral level meaning traders should be open to price movements in either direction. On the smaller timeframes, such as the 5-minute timeframe, there is a slight bias towards a bullish outcome. However, this is only likely if the latest bearish swing does not drop below the 200-Bar SMA.     The key resistant level can be seen at 150.262 and the support level at 149.115. Breakout levels are at 149.988 and 149.674. Key Takeaway Points: Job vacancies hit a five-month low, and the ISM Manufacturing PMI missed expectations, adding pressure on the Federal Reserve regarding interest rate decisions. Traders await confirmation on Trump’s tariff policy, which is expected to impact the EU, chips, pharmaceuticals, and foreign car industries. The severity of the tariffs will influence both the JPY and the USD, with traders waiting for final policy details. The Japanese Yen Index is the worst index of the day while the US Dollar Index is unchanged. 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.
×
×
  • Create New...

Important Information

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