How to Build a Trading Simulator using Excel VBA

  Рет қаралды 43,079

Excel Macro Mastery

Excel Macro Mastery

Күн бұрын

Пікірлер: 89
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
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
@johnwayne8059 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
Thanks John.
@johnwayne8059
@johnwayne8059 4 жыл бұрын
@@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
@muhannad_youssef 4 жыл бұрын
hi sir can you explain to us why written code in 32 bit not work on 64 bit and what the solution plezzzzzzzzzzzzzzzz
@mehmetturan8500
@mehmetturan8500 Жыл бұрын
thank you so much all your videoes. You are very good sound and capability
@sifar786
@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
@cpro671 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
Thanks a lot Charlie.
@Lykoskia
@Lykoskia 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
Thanks Arthas:)
@johnwayne8059
@johnwayne8059 4 жыл бұрын
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
@VipulKarkar 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
Thanks Vipul.
@vbaclasses3553
@vbaclasses3553 4 жыл бұрын
Absolutely brilliant. I am most grateful for your generosity in sharing your knowledge, expertise and wisdom. God bless you.
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
You are very welcome
@RobertWoodman
@RobertWoodman Жыл бұрын
Paul, this was an excellent, helpful video. Thank you!
@SimpleExcelVBA
@SimpleExcelVBA 4 жыл бұрын
As always quality video on really complex topic, looking further for more!
@MrScarymaster
@MrScarymaster Жыл бұрын
Insane!! Very nice work, well done!
@richardshi1896
@richardshi1896 4 жыл бұрын
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
@Sancarn 4 жыл бұрын
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
@davidunger7425 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
You're welcome David.
@rogeriopalma2386
@rogeriopalma2386 4 жыл бұрын
Paul once again thanks for your time and share you knowledge ! It also useful in any data demos!
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
You're welcone Rogerio
@johnwayne8059
@johnwayne8059 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
You're welcome 😀
@amarnadhg6896
@amarnadhg6896 4 жыл бұрын
Rare content, unleash Excel, keep up the good work.
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
Thanks, will do!
@dougrobinson2024
@dougrobinson2024 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
Glad you like it Doug.
@rayberi9582
@rayberi9582 4 жыл бұрын
@@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
@nedimozbey9150 3 жыл бұрын
quite complicated. I have to try to understand. thanks a lot.
@giorgiomya4546
@giorgiomya4546 3 жыл бұрын
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
@Excelmacromastery 3 жыл бұрын
My pleasure!
@shindersamra4020
@shindersamra4020 4 жыл бұрын
Thank you very good and informative video. Looking forward for more.
@benponderin
@benponderin 4 жыл бұрын
Well done! I am going to use this to teach my kids investing on a scale I can define
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
Thanks Brigh
@rrrprogram8667
@rrrprogram8667 4 жыл бұрын
Vba noble prize to be given to you
@grahamparker7729
@grahamparker7729 4 жыл бұрын
Wowza, over my head but very enjoyable to watch 👌🏻
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
Glad you like it Graham.
@marytesson2843
@marytesson2843 4 жыл бұрын
Love the content thanks for sharing!
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
You're welcome Mary.
@wayneedmondson1065
@wayneedmondson1065 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
You are welcome Wayne.
@noviceprogrammer2011
@noviceprogrammer2011 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
Thanks for the suggestion.
@tangsh497
@tangsh497 3 жыл бұрын
Mr VBA Master
@ОлегВоропаев-к6ъ
@ОлегВоропаев-к6ъ Жыл бұрын
Hello, good video! How to built backtester tick by tick? I've got 1 min OHLC, Volume, time and tick data.
@eedeatlikkle3652
@eedeatlikkle3652 3 жыл бұрын
Great vid! How do you create the trading interface shown in 4:18?? Do you have the code for it? Please answer ASAP
@bogdanexit1
@bogdanexit1 4 жыл бұрын
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
@Excelmacromastery 4 жыл бұрын
Thanks Bogdan. Glad you liked it so much.
@yashchawla8360
@yashchawla8360 4 жыл бұрын
Please do this kind of examples more sir for different things.
@Achieve_FinancialFreedom
@Achieve_FinancialFreedom 8 ай бұрын
This is excellent one like software. can you please update the code link. link given in description is not working.
@noisearchitect
@noisearchitect 2 жыл бұрын
Thank you,
@grant7934
@grant7934 3 жыл бұрын
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
@golfmedic100 3 жыл бұрын
great video - just wondering if you are going to make new one but with candlestick charts
@panayiotisyannopoulos2668
@panayiotisyannopoulos2668 3 жыл бұрын
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
@jdthefirst 2 жыл бұрын
Wonderful. Please share the code to add the trading component and indicators.
@yeahnick4260
@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
@TheJaebeomPark 7 ай бұрын
Can't believe it!
@Mark1969w
@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
@hariomgupta4677 4 жыл бұрын
Sir can u please make vba for bank reconciliation between two data first data from bank statement and second accounting software
@VinodKRamachandra
@VinodKRamachandra 4 жыл бұрын
Hey, when are you bringing next episode on VBA Regex
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
No plans at the moment.
@VinodKRamachandra
@VinodKRamachandra 4 жыл бұрын
@@Excelmacromastery Okies
@muhannad_youssef
@muhannad_youssef 4 жыл бұрын
hi sir can you explain to us why written code in 32 bit not work on 64 bit and what the solution plezzzzzzzzzzzzzzzz
@sabilabry
@sabilabry 4 жыл бұрын
Hi!.. Please. may i know your screen recorder app?
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
Camtasia
@sabilabry
@sabilabry 4 жыл бұрын
@@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
@yashchawla8360 4 жыл бұрын
Epic
@AI-ec2qb
@AI-ec2qb 4 жыл бұрын
you are treasure!
@Rice0987
@Rice0987 4 жыл бұрын
ptnpnh
@marvinmachitar7229
@marvinmachitar7229 3 жыл бұрын
i thought i am expert in vba.. until i saw this tutorial 😂
@hariomgupta4677
@hariomgupta4677 4 жыл бұрын
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
@lakshminarasaiah6357 Жыл бұрын
can you please write same code in python.....
@Rice0987
@Rice0987 4 жыл бұрын
I think, for real simulator better to use candels, if we speak about not investments only.
@mustavogaia2655
@mustavogaia2655 4 жыл бұрын
At least some OHLC bars.
@Rice0987
@Rice0987 4 жыл бұрын
@@mustavogaia2655 Excel has classical stock graphs with japan candles.
@mustavogaia2655
@mustavogaia2655 4 жыл бұрын
@@Rice0987 Ok, sometimes I prefer bars charts. Anyway, adding open/high/low/ close data, could help to turn this into a backtest app.
@Excelmacromastery
@Excelmacromastery 4 жыл бұрын
Thanks John. I might do video in the future using one of those charts.
@HungLe-gp9gb
@HungLe-gp9gb 4 жыл бұрын
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
@yashchawla8360 4 жыл бұрын
Omg I'm too naive to understand class modules
How to Use Class Interfaces in Excel VBA
20:16
Excel Macro Mastery
Рет қаралды 81 М.
5 Things I wish I knew When I started using Excel VBA
12:45
Excel Macro Mastery
Рет қаралды 339 М.
龟兔赛跑:好可爱的小乌龟#short #angel #clown
01:00
Super Beauty team
Рет қаралды 100 МЛН
Когда отец одевает ребёнка @JaySharon
00:16
История одного вокалиста
Рет қаралды 17 МЛН
Бенчик, пора купаться! 🛁 #бенчик #арти #симбочка
00:34
Симбочка Пимпочка
Рет қаралды 4 МЛН
Do You Need to SWITCH from Excel VBA Macros to Office Scripts?
13:02
Leila Gharani
Рет қаралды 383 М.
How to get the Last Row in VBA(The Right Way!)
15:41
Excel Macro Mastery
Рет қаралды 163 М.
How To Master Arrays In Excel VBA + FREE MACROS & CHEAT SHEET
29:09
Excel For Freelancers
Рет қаралды 9 М.
How to use Class Modules with the VBA Dictionary
14:30
Excel Macro Mastery
Рет қаралды 51 М.
Enums(Enumeration): The Key to Cleaner, More Efficient VBA Code
9:58
Excel Macro Mastery
Рет қаралды 31 М.
Python in Excel vs. VBA - What You Should Learn in 2024!
10:05
David Langer
Рет қаралды 55 М.
VBA Classes - The Definitive Guide
31:03
Data Ben
Рет қаралды 36 М.
Watch these 28 minutes if you want to become an Advanced VBA user...
29:01
Excel Macro Mastery
Рет қаралды 55 М.
Learn Excel VBA to Automate Anything
14:02
Kenji Explains
Рет қаралды 467 М.
龟兔赛跑:好可爱的小乌龟#short #angel #clown
01:00
Super Beauty team
Рет қаралды 100 МЛН