You are right about getting price change for any look back period. But please remember that I need the daily price change to calculate the SD. That is why I have populated my Sheets that way.
Trust this clarifies.
Posts tagged Value Pickr
Avanti Feeds (09-12-2023)
Latest update on ADD and CVD from US
US ITC (International Trade Commission) has voted to continue investigations for AD and CVD. [source]
So far proceedings seems to be going as per expected timelines. Next steps regarding investigations to be conducted by US DOC (Department of Commerce) are the time consuming parts, especially for ADD related investigations.
Expected timeline is as below [source] –
PS: Alleged dumping margins on Ecuador is 9.55% to 25.82% and Indonesia is 26.13% to 33.95%. CVD on Ecuador, India, Indonesia and Vietnam seems to be a non-event with <2% impact.
Gabriel India Ltd. – Shock free ride? (09-12-2023)
Q2FY23 Updates
Top 5 shock absorber manufacturers in the world and market leaders for 60 years
Market Leadership in Aftermarket – 37% after market
YTD SEGMENT
2W&3W – 32% Market Share, 61% % to Total Sales
PASSENGER VEHICLES – 24% Market Share, 25% % to Total Sales
COMMERCIAL VEHICLES – 89% Market Share, 11% % to Total Sales
Merger & Acquisition- Inalfa roof System – leading in roof systems technology and solutions, delivering roof systems to almost every major car and truck manufacturer in the world.
Smallcap momentum portfolio (09-12-2023)
Hello Viswa
I’m not sure if you’re using the most efficient way to source the raw data for each stock. Following formula gives you the raw price data for last 365 days
=query(sort(googlefinance(“NSE:”& A2,“price”,today()-365,today()),1,0),“select Col2”)
Replace A2 with any stock you want
You can change the no. of day from 365 to any number you want
Hope this helps
Praveen
Avanti Feeds (09-12-2023)
Hi Harsh, I have read about your views about Avanti, Sharath, but not about Apex Frozen. Do you find any major issues with Apex?
Genus Power – Smart Metering (09-12-2023)
Till now the share price increase was dependent on orders being received. Now the trigger would be based on the execution of those orders. If the company is not able to execute then it will result in sharp correction.
Was invested from 74 to 250. Sold around 250 mark. Hence Biased
Muthoot Finance (09-12-2023)
during the top of gold price cycle in 2021 , it traded at 5XBV where as now its trading at 2.2x . This stock would be a good proxy play on gold price
Semiconductor world – CPU/GPU Wars (09-12-2023)
WoW. She is saying 2B$ is clear line of sight. And they have supply beyond that. “we plan for success” says when asked for supply constraints beyond 2B$. Nvda has backlogs till 2025. This is bumper for amd. Unbelievable. I invested in amd for cpu lead over intel and ended up staying for AI (DC GPU).
Good article on what happened on AMD AI day. And implication of open source, implications of msft/dell/meta/supermicro on stage. Stellar execution till now.
Out of words.
IDFC First Bank Limited (09-12-2023)
his age is 55 . this guy left ICICI bank , did merger with idfc – all because of his dream to build a retail bank as md and ceo. dont think he is going to leave unless rbi forces ( for some scary reason ) or he is at retirement age.
and if he stays another 5 years and delivers what he is promising then that would be enough for investor like us.
Case Study: Felix Industries (09-12-2023)
Valuepickr is not here to give investment recommendations Sir.
cc: @Donald