Forum Discussion

dattmuffy15's avatar
dattmuffy15
Copper Contributor
Sep 26, 2024

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 MAXIMUM TIME BASIS I USE SCHWABS LINEAR REGRESSION INDICATOR TOOL.

I ZOOM IN TOWARDS CURRENT DATE UNTIL LINEAR REGRESSION SLOPE EQUALS ABOUT ~ ZERO.

I USE THIS "IFO" TO STANDARDIZE MY 500 GROWTH STOCKS FOR SWING TRADING.

 

I NEED THE "IFO" DATE & "AVG$" TO ALWAYS BE BASED ON TODAYS CURRENT DATE.

AN EXAMPLE IS MICROSOFT "MSFT" TODAY IS THURSDAY SEP 26TH 2024 PRICE IS $431.

THE IFO DATE IS ABOUT ~ 4/30/2024 AND THE AVERAGE STOCK PRICE IS ABOUT ~ $426.

 

IVE RESEARCHED ALL 5555 US STOCKS ON FINVIS FINANCIAL VISUALIZER WEBSITE.

IVE TRADED 382K @ ABOUT 21% IN 13 MONTHS WITH NO OPTIONS ONLY BUY & SELL.

IVE TEMPORARILY OUTPACED THE NASDAQ QQQ INDEX 3 TIMES.

I EXPECT TO STAY AHEAD THIS TIME.

ANYTHING HELPS.

THANKS.

 

FOR CLARIFICATION

I HAVE BEEN MANUALLY ENTERING THIS DATA BY HAND FROM CHARLES SCHWAB CHARTS 

IT TAKES ALOT OF TIME SO ID LIKE SOMEONE TO AUTOMATE THE DATA ENTRY 

THE COLUMNS IM REFERRING TO ARE ON THE "MARGIN" SHEET 

ANOTHER EXAMPLE 

 

TODAY IS 9/27/24

NVDA  $120

"IFO" IS ~5/20/24

AVG$ IS ~$117 

 

AAPL $227

IFO 7/2/24

AVG$ $223

 

GOOG $165

IFO 3/28/24

AVG$ 169

 

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Sep 27, 2024
    Without an indication on how the IFO date and AVG$ need to be calculated, your question is impossible to answer.
    By the way: Please, please do not write in ALL CAPS, it makes your question hard to read.
    • dattmuffy15's avatar
      dattmuffy15
      Copper Contributor
      Oct 30, 2024
      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.....
      • dattmuffy15's avatar
        dattmuffy15
        Copper Contributor
        Oct 30, 2024
        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.

Resources