I'm definitely no pro, just a homebody retail coder. I don't code for anybody but myself. Neither am I on social media other than ET, neither do I publish content other than privately to a couple of friends, although that now discontinued as it had got to the stage they now need stand on their own two feet. Google sheets suits me as it is free, updates automatically and the 'excel' language/formulas I love working with, it's easy. If you subscribe to a charting package for ASX, you'll maybe only get OHLCV, delayed usually EOD and pay a hefty price and then only ASX. Sheets offer streaming data day and night for several exchanges: “price” Stock price. In real-time but with a delay of up to 20 minutes. “priceopen” Opening price (price at market open). “high” High price of the current day. “low” Low price of the current day. “volume” The trading volume of the current day. “marketcap” The market capitalization of the stock. “tradetime” The time of the last trade of the stock. “datadelay” The delay time for the real-time data. “volumeavg” The average daily trading volume. “pe” Price-to-earnings ratio “eps” Earnings per share “high52” The highest price in the last 52 weeks. “low52” The lowest price in the last 52 weeks. “change” The stock price change since the end of yesterday’s trading. “beta” The beta value “changepct” The percentage change in price since the end of yesterday’s trading. “closeyest” Yesterday’s closing price. “shares” The number of shares outstanding. “currency” The currency that the stock is priced in. So there's quite a bit of data here on offer you can crunch a thousand different ways.
Thank you for the detailed explanation. Have you explored PineScript with TradingView?, I feel like you could get a lot more from your time there. It is not much different from spreadsheet formulas, they have their own API that you'll have to learn but once you get familiar with it, there are tons of traders trying to get some knowledge there. With your experience I feel like that could be the right tool. You can deploy your calculations in one single script, so it is easy to handle for people that are not full time coders. Then if you are trying to get your hands on teaching, 'TradingView' on the title of the course will improve your chances to get students.
Yeah, I looked at Tradingview but decided it was more work starting over and couldnt see what was going to improve. Yeah, I don't really want students. I was mulling placing a type blackbox algo onto cloud, free, which was a stock selector and timer. It would be available to anyone with the link. The problem with that idea, it would offer me nothing but negativity. I'll explain. Take the market this week on the ASX as an example, the whole week was hammered. The best stocks would go up one or two days then get hammered down. This week was brutal, I'm sure the algo would lose 'customers' money this week. 'Clients' remember with vivid clarity the losses and take for granted the wins. Yeah, it's not something which sits comfortable with me.
I was just comparing 600 of the best stocks today I have on a watchlist, about 66% of them went underwater this week, the other 34% made a piddly amount, a handful were outstanding.
Atm there are 40 stocks out of 573 on the watchlist which are rated BUY, that equates to 7%. There are a couple in there which are recent takover targets so prices have burst out and I wouldn't call them a buy any longer. The majority are gold - copper/gold stocks. Below is the list, this is not investment advice, there are a handful in there I would not touch with a barge pole. Some have run up too long a time period and I would be hesitant to buy those. The below list is roughly graded from best to worst. ASX:AII Almonty Industries CDI Tungsten, Molybdenum, producer ASX:CZR Czr Resources Ltd IRON ORE ASX:EOL Energy One Ltd Software and services to energy companies and utilities. Specializing in the wholesale energy, environmental, and carbon trading markets ASX:SM1 Synlait Milk Ltd MILK POWDER ASX:EML EML Payments Ltd FINTECH ASX DRO DroneShield Ltd TECHNOLOGY ASX:GG8 Gorilla Gold Mines Ltd GOLD explorer WA. Formerly LABYRINTH RESOURCES ASX: DHG Domain Holdings Australia Ltd ASX: PDI Predictive Discovery Ltd GOLD-GUINEA-AFRICA ASX:EBR EBR Systems Inc HEALTH ASX: PBH Pointsbet Holdings Ltd GAMING ASX:MYX Mayne Pharma Group Ltd BIOTECHNOLOGY ASX:NAN Nanosonics Ltd. ASX:MM8 Medallion Metals Ltd GOLD RAVENSTHORPE ASX:MEK Meeka Metals Ltd GOLD DEVELOPER ASX:CHN Chalice Mining Ltd RARE EARTHS ASX:MP1 Megaport Ltd ASX:ARU Arafura Rare Earths Ltd RARE EARTHS ASX:BC8 Black Cat Syndicate Ltd GOLD, WA ASX:WAF West African Resources Ltd GOLD ASX:KPG Kelly Partners Group Holdings Ltd FINANCIAL CPA ASX:M7T Mach7 Technologies Ltd Healthcare diagnostic imaging ASX:RXL Rox Resources Ltd NICKEL-GOLD ASX:WIA WIA Gold Ltd GOLD AFRICA ASX:OBM Ora Banda Mining Ltd GOLD ASX: PNR Pantoro Ltd GOLD ASX:FFM Firefly Metals Ltd COPPER-GOLD CANADA ASX:CYL Catalyst Metals Ltd GOLD ASX:ASB Austal Ltd industrial ASX:TCG Turaco Gold Ltd GOLD, Cote d'Ivoire AFRICA ASX:A1M AIC Mines Ltd (Australia) COPPER PRODUCER ASX:SMI Santana Minerals Ltd GOLD NZ ASX:SVM Sovereign Metals Ltd RUTILE, MALAWI AFRICA ASX:BGL Bellevue Gold Ltd GOLD ASX:ALK Alkane Resources Ltd NSW GOLD producer & explorer ASX:RMS Ramelius Resources Ltd GOLD ASX:SXL Southern Cross Media Group Ltd MEDIA, radio, TV ASX:LTM Arcadium Lithium CDI LITHIUM