Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
does any one know a platform or excel add in that can calculate things like below and with a distribution of results:
1. If XX goes up 5% in 2 days what is the outcome for day by day for next 10 days. And then show the result as a distribution. As example, for the last 100 times this happened stock went up more than 1% day 1 after in 65 of the outcomes
2. If stock hits new ATH then what happens next day, next 10 days, next 100 days. And then again with clear check, in the last 20 cases 15 went up and 5 down etc
Is there any good platform or software to do this sort of analysis?
Kind regards
Loop
Can you help answer these questions from other members on NexusFi?
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,049 since Dec 2013
Thanks Given: 4,388
Thanks Received: 10,207
That would be very easy to do in Morningstar's Commodity Excel Addin ( Link) or Commodity Query ( Link) but unfortunately it's not cheap software.
Query would look something like
SHOW
0: Close of SYMBOL
1: Close of SYMBOL 1 value later
2: Close of SYMBOL 2 value later
3: Close of SYMBOL 3 value later
4: Close of SYMBOL 4 value later
When
(Close of SYMBOL / Close of SYMBOL 2 values ago) > 1.05
You'd have to set up your own histogram in Excel though.