SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Technology Stocks : Semi Equipment Analysis
SOXX 296.26-3.9%4:00 PM EST
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
Recommended by:
Return to Sender
Sr K
Sun Tzu
To: Return to Sender who wrote (91868)3/6/2024 3:29:48 PM
From: Kirk ©3 Recommendations  Read Replies (2) of 95346
 
Interesting. Nice work!
The SOX is setting new highs again today. Tomorrow we finish out the quarter with the reports of AVGO and MRVL. The table below shows that only six stocks out of the over 30 I share here have so far raised guidance.
It was hard to find these six quickly....

So I thought of a nice enhancement to the table. I can make "Raised" a green box and "Lowered" a red box so you can quickly scan with non color blind eyeballs to get the count. If I really wanted to get cute, I could probably do the math for the next four columns based on what you enter in the "Direction" column so then you'd just enter direction and SOX prices for each update.

I learned that Seeking Alpha lets you make a portfolio of stocks and then sort them by earnings date. You could probably make the next quarter's table and prefill the data info once and have an earnings schedule built into this table plus it would scale the graph with the first update.

If you want me to try, send this one via email and I'll give it a go.

I've had fun learning new Excel tricks by asking the AI. The hardest problem is figuring out how to ask what I want...

Late update... I could also make the ticker cells turn red or green based on raised or lowered so it would be easier to find what six raised...
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News