Forum Discussion
dattmuffy15
Sep 26, 2024Copper Contributor
AUTOMATE EXCEL STOCK DATABASE WITH FIRST FLAT LINEAR REGRESSION
WILL SOMEONE PLEASE AUTOMATE MY "IFO" & "AVG$" COLUMNS ? " IFO " IS AN ACRONYM I MADE UP FOR INITIAL FLAT OFFERING. " AVG$ " IS AVERAGE STOCK PRICE IN THE FIRST FLAT LINEAR REGRESSION. FROM A MAX...
dattmuffy15
Copper Contributor
do u comprehend the question?
many ways to skin a cat
easy example use slope functions at spectrums of time vs the current price to identify the first time the first flat linear regression is where slope equals zero
many stocks have multiple flat linear regressions
i am only after the very first
im looking for someone who can do this for one stock like msft and replicate it for the rest of my database so i dont have to keep manually researching data my data entries avg is the avg in the correct slope = 0 "ifo" its pretty simple i just dont know how to query or code and stuff i am not even familiar with all the language. i failed vba in college. but i love computer science. i love excel. i need better instructors. i need smarter people in my life. im already a 40 million dollar whistleblower with one city that could be a class action of 2 - 26 billion us states dollars because epa isnt following water law. blah blah blah.....
many ways to skin a cat
easy example use slope functions at spectrums of time vs the current price to identify the first time the first flat linear regression is where slope equals zero
many stocks have multiple flat linear regressions
i am only after the very first
im looking for someone who can do this for one stock like msft and replicate it for the rest of my database so i dont have to keep manually researching data my data entries avg is the avg in the correct slope = 0 "ifo" its pretty simple i just dont know how to query or code and stuff i am not even familiar with all the language. i failed vba in college. but i love computer science. i love excel. i need better instructors. i need smarter people in my life. im already a 40 million dollar whistleblower with one city that could be a class action of 2 - 26 billion us states dollars because epa isnt following water law. blah blah blah.....
dattmuffy15
Oct 30, 2024Copper Contributor
i can manually calculate the area of the max obv or price and the current price based on the ifo and it predicts which stages the combinations of permutations is for a pattern that this system exhibits. its kind of like a football shape yin yang. or a sine wave. and the most typical maximum percent confidence interval is nearly 77% this about the maximum amount of screen to find the most money to bet on the rarest dips in stocks to illustrate when to buy in at the maximum potential time. its kind of like the all seeing eye. it can be better represented with binomial distributions for added confidence. it reminds me of sunshine gold mint logo. every "ifo" repeat these patterns with my top 500 growth stocks backed with decades of confidence.