Stock Simulation Spreadsheet

[Jtalk4456]

In the pursuit of figuring out if stocks would be worth investing in and whether I have the intuition for it, I've made myself a stock simulation spreadsheet in excel. I'm having fun with it thus far and figured someone else might want to mess with it.

It has a sheet for normal stock trading and two sheets for options trading (calls and puts).

Let me know what you think. Also I'm not an excel master so I may be doing this more complicated than it needs to be. Let me know if you have a better way

Empty Stocks Chart.xlsx

[NoxiousOdor]

https://www.marketwatch.com/game

 

This might be easier

[Jtalk4456]

14 hours ago, WhisperingKnickers said:

https://www.marketwatch.com/game

 

This might be easier

I've seen the app version before but haven't looked enough into it

[NoxiousOdor]

3 hours ago, Jtalk4456 said:

I've seen the app version before but haven't looked enough into it

It uses realtime stock info and functions very similar to if you were actually trading. It gives you imaginary money to work with and you get to see if what you used actually turn a profit over a set period of time. It is actually pretty fun

[Jtalk4456]

42 minutes ago, WhisperingKnickers said:

It uses realtime stock info and functions very similar to if you were actually trading. It gives you imaginary money to work with and you get to see if what you used actually turn a profit over a set period of time. It is actually pretty fun

i'll give that a try, does it let you simulate options?

[NoxiousOdor]

1 hour ago, Jtalk4456 said:

i'll give that a try, does it let you simulate options?

Can you be more specific?

When you first set up the game it gives you the options of difficulty which change how realistic it is, harder being more realistic. You also get to choose how long the game will go on as well as how much money you want to have on the start.

[Jtalk4456]

50 minutes ago, WhisperingKnickers said:

Can you be more specific?

When you first set up the game it gives you the options of difficulty which change how realistic it is, harder being more realistic. You also get to choose how long the game will go on as well as how much money you want to have on the start.

https://www.investopedia.com/terms/s/stockoption.asp

[Clanscorpia]

Im not sure about other banks, but RBC has a type of investment account that simulates an actual account using the normal stock exchange, but without making actual purchases. I really like it because its using actual investment software without real money. It gives you 100,000 dollars to start with just to play with to figure out the software before you start actually investing.

[Jtalk4456]

11 hours ago, Clanscorpia said:

Im not sure about other banks, but RBC has a type of investment account that simulates an actual account using the normal stock exchange, but without making actual purchases. I really like it because its using actual investment software without real money. It gives you 100,000 dollars to start with just to play with to figure out the software before you start actually investing.

interesting. Sadly I don't live in canada