Any demand learning to write your own algos?

[themickey]

Google sheets is the wrong tool for the job. IMO

You are way better using any server side programming language and then, if you need a UI use Socket.IO to display any data on a local website.

Would you care to describe in bullet points what would be the content of your course and why did you choose Google Sheets over any other platform?

A developer wouldn't use Google Sheets for trading, is it fair to say that you are not a developer?

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.

 

[themickey]

For the grand price of free, thrown in is also historical data

 

[Drawdown Addict]

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, you'll maybe only get OHLCV, delayed usually EOD and pay a hefty price.

Sheets offer streaming data day and night:
“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.

 

[themickey]

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.

 

[themickey]

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.