How to Build a Trading Simulator using Excel VBA

[@Excelmacromastery]

Hi Everyone. I hope you enjoy this video. This video is different in that 90% of the code is written using class modules. Please let me know what you think in the comments below.

[@johnwayne8059]

Hey Mr. VBA Master, again a cool video for increase the coding ability! Great, please continue, that's truly helpful for all your followers! ;)

[@Excelmacromastery]

Thanks John.

[@johnwayne8059]

@@Excelmacromastery hey Paul, just a small question: if there's any gap for you, can you help me, might be us all, with handle the strconv-function (especially conversion vbunicode&vbfromunicode and these lcid stuff!)

[@muhannad_youssef]

hi sir can you explain to us why written code in 32 bit not work on 64 bit and what the solution plezzzzzzzzzzzzzzzz

[@mehmetturan8500]

thank you so much all your videoes. You are very good sound and capability

[@sifar786]

- Why not use the With `Events` keywords in a module and add the default ScrollBar events instead of creating a separate events module? - A rough sketch would bring clarity in logic employed, of : - how many class modules are required, - how many methods need to be defined in each class module and - how the entire flow works and integrates together. Also, is there a way not to scroll the Y-axis with the points when played or reset, but have it shown and updated at the beginning only? Excellent example!

[@cpro671]

Paul, this is one of your best videos. It encompasses a complete (and useful) project and really illustrates the usefulness of classes. Very well done.

[@Excelmacromastery]

Thanks a lot Charlie.

[@Lykoskia]

I'm amazed, confused and speechless... I hope some day I will be half as godly in VBA (and possibly other languages) as you are :)

[@Excelmacromastery]

Thanks Arthas:)

[@johnwayne8059]

Hey Arthas, for sure you will, just follow your current interests! And in this channel you've got all the needed support! A half year ago I started coding vba, with this channel I could learn amazingly much and this so rapidly, truly unbelievable. And all with a completely different home language...

[@VipulKarkar]

It was one of the best video that I had seen till date with extensive use of VBA class modules. I generally use a singly function for multiple actions like Play/Pause/Stop with enum as input in function and then designing the actions based on what has provided to function via enum selection. Loved all your videos as they help anyone to understand the concepts in the simplest way. Thank you.

[@Excelmacromastery]

Thanks Vipul.

[@vbaclasses3553]

Absolutely brilliant. I am most grateful for your generosity in sharing your knowledge, expertise and wisdom. God bless you.

[@Excelmacromastery]

You are very welcome

[@RobertWoodman]

Paul, this was an excellent, helpful video. Thank you!

[@SimpleExcelVBA]

As always quality video on really complex topic, looking further for more!

[@MrScarymaster]

Insane!! Very nice work, well done!

[@richardshi1896]

This video proves that Excel VBA can deliver what is typically expected of an object-oriented programming language. Nice job, Paul. Would be perfect if you could add in the codes to enable simulated trading which you briefly demoed during the overview.

[@Sancarn]

Was there any debate? VBA still can't do a plethera of other things very well. E.G. constructors. Yes there are hacks around constructors like using factory or static classes, but even they have their limitations. VBA also has loads of issues when it comes to code cleanliness too. Don't get me wrong, I love VBA. But I'm not sure VBA is the most dreaded language due to its lack of capabilities...

[@davidunger7425]

Paul, thanks for this excellent video, this really helped in giving me more insight into using class modules. I did have to change all "FullSeriesCollection" references to "SeriesCollection" so it would run on my xl2010. I rarely work with charts, so I'm not 100% sure what impact those changes would have, if any, but it seems to work just fine. Thanks again, looking forward to more videos like this.

[@Excelmacromastery]

You're welcome David.

[@rogeriopalma2386]

Paul once again thanks for your time and share you knowledge ! It also useful in any data demos!

[@Excelmacromastery]

You're welcone Rogerio

[@johnwayne8059]

The next legendary coding terminator video! :) Thanks for this great sample using class modules! I want to watch more takes like these great video please!😎🍻🥳

[@Excelmacromastery]

You're welcome 😀

[@amarnadhg6896]

Rare content, unleash Excel, keep up the good work.

[@Excelmacromastery]

Thanks, will do!

[@dougrobinson2024]

Oh...that's a beautiful spreadsheet. I was just working on something extremely similar today and now I see you've already done it, and made a tutorial on KZbin and you are making available the files, too! Ain't KZbin great? Thank you! Just subscribed.. :)

[@Excelmacromastery]

Glad you like it Doug.

[@rayberi9582]

@@Excelmacromastery I was trying to download the VBA code for Trading Simulator as you mentioned this but never received email with instructions...checked my spam.. nothing there!? Where can i get the code if its possible?

[@nedimozbey9150]

quite complicated. I have to try to understand. thanks a lot.

[@giorgiomya4546]

Paul, I am infinitely grateful for all the material and experience you share with us, especially for the great quality in all aspects of your tutorials: topic, methodology, clarity of explanation, etc. I also thank you for the absence of the annoying background music in other tutorials. Also the emails with your tips and advices ( I am subscribed!) I have a newbie question: Why or how do you decide to make a class, in the case of the clsFrame class, and not a Custom Type? Thanks Again!

[@Excelmacromastery]

My pleasure!

[@shindersamra4020]

Thank you very good and informative video. Looking forward for more.

[@benponderin]

Well done! I am going to use this to teach my kids investing on a scale I can define

[@Excelmacromastery]

Thanks Brigh

[@rrrprogram8667]

Vba noble prize to be given to you

[@grahamparker7729]

Wowza, over my head but very enjoyable to watch 👌🏻

[@Excelmacromastery]

Glad you like it Graham.

[@marytesson2843]

Love the content thanks for sharing!

[@Excelmacromastery]

You're welcome Mary.

[@wayneedmondson1065]

Hi Paul.. this is great! Looking forward to a detailed viewing and rolling up the sleeves to do some fun coding :)) Thanks for this clever and innovative tutorial and example. Thumbs up!!

[@Excelmacromastery]

You are welcome Wayne.

[@noviceprogrammer2011]

Paul, I think what might be good is if you could create an additional "prequel" video to this. For example, if one were asked to write this simulator in OOP fashion, how would they plan it? How would they know how many classes are required, which classes depend on which, etc. This "prequel" video need not contain code but instead diagrams on a piece of paper and explain how it all "gels". Thanks

[@Excelmacromastery]

Thanks for the suggestion.

[@tangsh497]

Mr VBA Master

[@ОлегВоропаев-к6ъ]

Hello, good video! How to built backtester tick by tick? I've got 1 min OHLC, Volume, time and tick data.

[@eedeatlikkle3652]

Great vid! How do you create the trading interface shown in 4:18?? Do you have the code for it? Please answer ASAP

[@bogdanexit1]

1 billion like from me or a infinite loop You are the best from all KZbin. How afect the speed code if it's check the pause ⏸? Nice work with sleep loop 🙂 Can you do in the future ArrayList and Sorted.List? Thanks

[@Excelmacromastery]

Thanks Bogdan. Glad you liked it so much.

[@yashchawla8360]

Please do this kind of examples more sir for different things.

[@Achieve_FinancialFreedom]

This is excellent one like software. can you please update the code link. link given in description is not working.

[@noisearchitect]

Thank you,

[@grant7934]

Hello Paul, I did the same in Excel with real-time data some years ago. Why would VBA be more suitable for this kind of application? The best VBA videos I've seen but yet to be convinced.

[@golfmedic100]

great video - just wondering if you are going to make new one but with candlestick charts

[@panayiotisyannopoulos2668]

Hi I am trying to make a phishing excel for all vessels expected arrivals, at specific given ports / anchorages through VesselFinder I have paying subscription. So far I manage to log in through excel and that’s about it really Is such / relevant topic around?

[@jdthefirst]

Wonderful. Please share the code to add the trading component and indicators.

[@yeahnick4260]

11:49 what are the advantages of writing properties this way, instead of setting all the properties of the clsSettings Class into the clsReadSettings Class ? Isn't it more efficent ?

[@TheJaebeomPark]

Can't believe it!

[@Mark1969w]

Does this work in excel for mac? i subscribe to office with the yearly payment. I try to run and it says file not found.

[@hariomgupta4677]

Sir can u please make vba for bank reconciliation between two data first data from bank statement and second accounting software

[@VinodKRamachandra]

Hey, when are you bringing next episode on VBA Regex

[@Excelmacromastery]

No plans at the moment.

[@VinodKRamachandra]

@@Excelmacromastery Okies

[@muhannad_youssef]

hi sir can you explain to us why written code in 32 bit not work on 64 bit and what the solution plezzzzzzzzzzzzzzzz

[@sabilabry]

Hi!.. Please. may i know your screen recorder app?

[@Excelmacromastery]

Camtasia

[@sabilabry]

@@Excelmacromastery thank you so much. im learning a lot. i feel bad i dont have a budget to get your full training so maybe you videos at least will help a lot.. thank you

[@yashchawla8360]

Epic

[@AI-ec2qb]

you are treasure!

[@Rice0987]

ptnpnh

[@marvinmachitar7229]

i thought i am expert in vba.. until i saw this tutorial 😂

[@hariomgupta4677]

Sir i make a filter vba but my vba code show some errors. I try to solve error but my vba errors not solve can u please solve my vba error and how can i send my error vba file please help 🙏🙏🙏🙏🙏🙏

[@lakshminarasaiah6357]

can you please write same code in python.....

[@Rice0987]

I think, for real simulator better to use candels, if we speak about not investments only.

[@mustavogaia2655]

At least some OHLC bars.

[@Rice0987]

@@mustavogaia2655 Excel has classical stock graphs with japan candles.

[@mustavogaia2655]

@@Rice0987 Ok, sometimes I prefer bars charts. Anyway, adding open/high/low/ close data, could help to turn this into a backtest app.

[@Excelmacromastery]

Thanks John. I might do video in the future using one of those charts.

[@HungLe-gp9gb]

Yeah, Could you do a video with candel? Or tell us how to modify the current code. It would be very helpful with learning how to trade.

[@yashchawla8360]

Omg I'm too naive to understand class modules