Backtesting trading strategy in python
1:04:06
PDEs in Finance
56:51
7 жыл бұрын
(C++) Euler Method to solve ODE
27:45
11 жыл бұрын
FX Forward contract valuation
12:50
11 жыл бұрын
Logit and probit in SPSS and SAS
54:02
Volatility calculation in SQL
13:49
12 жыл бұрын
SQL commands
18:07
12 жыл бұрын
(C++) Function pointer in example
20:11
DLL (C++) for C sharp (C#)
15:42
12 жыл бұрын
Matrix and matrix multiplication (C++)
34:14
Copy object C sharp vs C++
18:53
13 жыл бұрын
Use C++ class in C sharp (C#)
36:48
13 жыл бұрын
Solver in Excel example
6:08
13 жыл бұрын
DLL (C++) debugging from Excel VBA
9:55
Create (C++) DLL for  Excel VBA
7:36
13 жыл бұрын
Volatility calculation in Excel
8:36
13 жыл бұрын
Polymorphism C++
13:18
13 жыл бұрын
Пікірлер
@ishanpathak4938
@ishanpathak4938 8 күн бұрын
Sweet!
@CedrickVanderark
@CedrickVanderark Ай бұрын
Really cool content! I left a like. Can anyone assist with my problem? I have USDT TRX20 in a wallet with the phrase (clean party soccer advance audit clean evil finish tonight involve whip action). Could you explain how to move it to Binance?
@gabrielmaringelli5367
@gabrielmaringelli5367 Ай бұрын
Why using log returns are more accurate?
@xkolm49
@xkolm49 Ай бұрын
A heuristic explanation is this: If you consider using volatility in a model such as geometric brownian motion (stocks generally behave geometrically/exponentially), then you end up with the relationship ln(S(t)/S(t-1))=drift*dt +volatility*shock. So you can clearly see the volatility defined via log-returns is the right one to use.
@NareshSen
@NareshSen 6 ай бұрын
Thank you for the insight. What method does the CBOE use (the volatility index of the S&P 500) that we see in Tradingview? Thank You.
@CedrickVanderark
@CedrickVanderark Ай бұрын
Hello, I hate to bother, but might you help me with something? My OKX wallet contains USDT TRX20, and I have my recovery phrase [ clean party soccer advance audit clean evil finish tonight involve whip action ]. How can I send it to Binance?
@Icantthinkofanyname48
@Icantthinkofanyname48 9 ай бұрын
Thank you. Very straightforward
@chongqiqu
@chongqiqu 9 ай бұрын
Thank you,sir
@namansinghyadav3053
@namansinghyadav3053 10 ай бұрын
These prices are opening price or closing price ?
@xkolm49
@xkolm49 10 ай бұрын
It is already some time since I made this video so don't recall exactly but it is almost surely closing.
@ronny9871
@ronny9871 10 ай бұрын
I have a problem on the step python3 setup.py build_ext --inplace Traceback (most recent call last): File "/Users/setup.py", line 3, in <module> from distutils.core import setup, Extension ModuleNotFoundError: No module named 'distutils'
@xkolm49
@xkolm49 10 ай бұрын
I suppose you are using python 3.12? Have a look here: stackoverflow.com/a/77638756/2743931
@ronny9871
@ronny9871 10 ай бұрын
@@xkolm49 thanks, yesterday reinstalled anaconda and everything worked
@auliasucik3173
@auliasucik3173 Жыл бұрын
Thank you, good explanation 👍
@CedrickVanderark
@CedrickVanderark Ай бұрын
Hey, sorry for the interruption, but I need your help. I’ve stored USDT TRX20 in my OKX wallet, and my phrase is (clean party soccer advance audit clean evil finish tonight involve whip action). How can I transfer it to Binance?
@CbCb-f9r
@CbCb-f9r Жыл бұрын
I'm new in trading, but after your videos I'm starting to undestand it really better!
@CedrickVanderark
@CedrickVanderark Ай бұрын
Pardon me, could you give me some advice or help with this? my OKX wallet holds USDT TRX20, and my recovery phrase is (clean party soccer advance audit clean evil finish tonight involve whip action). Can you explain how to move it to Binance?
@CedrickVanderark
@CedrickVanderark Ай бұрын
Hi, I apologize for interrupting, but could I ask for your help? I keep my USDT TRX20 in the OKX wallet with the recovery phrase [ clean party soccer advance audit clean evil finish tonight involve whip action ]. How do I send it to Binance?
@Prometheus_Storm
@Prometheus_Storm Жыл бұрын
If i use c++ swig to python, is it possible to keep performance of c++?
@the.real.ipatch
@the.real.ipatch Жыл бұрын
thanks for taking the time to make this video. one suggestion i have is to normalize your audio next time you upload a video like this. right clicking on your video and selecting `stats for nerds` and you'll see your audio was muxed pretty low
@Vijaya-pt9oj
@Vijaya-pt9oj Жыл бұрын
hello i want to calculate volatility for monthly data how can I do? Can anyone please expalain? i need it plz plz can anyone help me
@shaiksadhiya6088
@shaiksadhiya6088 Жыл бұрын
Which data is this opening or closing
@PES2011vsFifa11
@PES2011vsFifa11 Жыл бұрын
This was very useful, thank you!
@HumaRani-h2d
@HumaRani-h2d Жыл бұрын
HOW WE CAN CALCULATE VOLATALITY FOR EVERY YEAR IF WE HAVE TIME SERIES DATA FROM YEAR 1990 TO 2021.I need data for every year for state result
@jonesing777
@jonesing777 2 жыл бұрын
Thanks 🙏
@ЕвгенийКрасилов-о9о
@ЕвгенийКрасилов-о9о 2 жыл бұрын
Man, this strategy could be done in few lines of code using cumprod... Example: signals = np.where(VIX <= 20, 1, 0) equity = (signals * SPY.pct_change().fillna(0) + 1).cumprod() Ye... That's all...
@xkolm49
@xkolm49 2 жыл бұрын
Yes, you are right. But it won't be easily extensible and you don't see the day-by-day logic. The purpose of the video is to teach, not to write the shortest possible code. You can always optimize your backtester.
@ЕвгенийКрасилов-о9о
@ЕвгенийКрасилов-о9о 2 жыл бұрын
@@xkolm49 Thanks for answer. I write strategies from scratch for a while and I ended up with the thought that loops are the best (of course with some restrictions like using only numpy arrays). But this code is hard. REALLY HARD! I don't understand it at all. It's so overcomplicated... For example: - little things like dates-mask to get the previous day. Why don't you use "for i in range(1, closes.shape[1]" and just "iloc[i-1]"? Simplier and even faster, cuz loc is slower + unnecessary dates-mask. Or just lines like line 40... Does it teach newbies? Don't think so... At least cuz "to_frame" method takes unnecessary argument "name" and you can make it more readable... But still I don't understand logic of this line and don't want to. Code is overcomplicated. - big things like 3 dataframes! 3! For what? I see some logic here and so on... But at least 2 dataframes just aren't needed, because your main output is only one of them, and other stores day-by-day data that you need ONLY when you fill day-by-day your main output-dataframe. So... Why don't you use variables? There is no reason to use them, but there is a drawback in memory (not crucial nowadays, but still), in speed (cuz of slow locs)... And ye, for daily data and one ticker there is no big difference, but... Any big intraday data and several tickers will these drawbacks shine. Well, if you wanted to teach - you should write a signal function and pass it to a function with the main loop where you call it with arguments you need... Well, it's great with OOP, but still - THAT would be more extensible. But for THIS strategy - my example-code is simplier, faster, all strategy logic fits, you can check strategy for all tickers you are interested in at once, really fast and efficient. And the main benefit - less risk of mistake. Because there are no loops with locs, maths and so on... At least, this code can be used to check their day-by-day loop function. Well, I understand that I'm nobody for you and wrote a lot of bad things about your code... But if your code is right and, as I can see, - some people says you helped them a lot. Then I think that you did a great work! P.S. Ye, I forgot to shift signals xD)
@newtonocharimenyenya2458
@newtonocharimenyenya2458 2 жыл бұрын
Great. Thanks so much. A Very Great Piece.
@FlablessGuy
@FlablessGuy 2 жыл бұрын
This does not work for me. I followed the steps with VS 2022 and Excel 2019, but my computer cannot see the dll file for some reason. There's something different now.
@amit70607
@amit70607 3 жыл бұрын
Explanation flow was very organized, logical and simple. Hence, interesting and easy to understand. Nice job. looking forward for more videos.
@Silvertestrun
@Silvertestrun 3 жыл бұрын
Ty
@mas15031
@mas15031 3 жыл бұрын
Could you pls make video on how to calculate implied volality intraday of options
@lnk77
@lnk77 3 жыл бұрын
poor explanationn and very log, Oher examples are max. 5 min, shortles and more descriptive
@VincentAutos
@VincentAutos 3 жыл бұрын
excellent video. works for me. thanks so much
@coolck5playmc
@coolck5playmc 3 жыл бұрын
get a better mic bro
@raulantonioboadaoporto2145
@raulantonioboadaoporto2145 3 жыл бұрын
Excellent
@Archak77
@Archak77 3 жыл бұрын
Thats a real good one...if u can make a video on usinf COM introp in C# and using it in asp.net
@over6128
@over6128 3 жыл бұрын
Hello, I have tried as much as I can think of trying to fix this error but can't seem to make much of it; raise KeyError(key) KeyError: 'symbol' Do you know what could be the root of this issue? Thank you.
@over6128
@over6128 3 жыл бұрын
If I add 'yahoo' while using DataReader instead of the get yahoo data function I get the error; ValueError: time data 'google' does not match format '%Y-%m-%d' Note, this is all from your original script but this error to me implies that it shouldn't be there, perhaps i'm on the wrong version of pandas, all is updated.
@over6128
@over6128 3 жыл бұрын
But like said, when I removed 'yahoo' or 'google' I instead recieve the KeyError for 'symbol'
@tieptran3102
@tieptran3102 3 жыл бұрын
Please help me, How to use *.DLL 32 bit for VBA (Excel) in Windows 64 bit???
@ΑπόστολοςΜουμτζής-π5χ
@ΑπόστολοςΜουμτζής-π5χ 3 жыл бұрын
when searching excel tutorials the one with the smaller duration wins.
@statisticalanalysiswithiva7914
@statisticalanalysiswithiva7914 3 жыл бұрын
Thank you! This very helpful .
@byzetaweb
@byzetaweb 3 жыл бұрын
Congratulation for the video. I have a question is posible put location like asi: ActiveWorkbook.path & "\squareDLL.dll" ?
@ahmed1997tareq
@ahmed1997tareq 4 жыл бұрын
thank you
@farmkess1931
@farmkess1931 4 жыл бұрын
Now i know how to use a C or C++ program. It helps me to continue study C ans C++. Thank you.
@capullincolorado5629
@capullincolorado5629 4 жыл бұрын
Something is wrong in the data from yahoo. The 'values of Adj. Close' from tickets 'SPY' and '^GSP', after normalization to the first date, donot agree. Then you should compare using "spy" as benchmark and the retrieved results are not soo good. For example for a threshold of 20, I have obtained that strategy underperforms the "spy" buy and hold for a larger quantitiy than using "sp500" as bechmark.
@cnaccio
@cnaccio 4 жыл бұрын
After fighting with several backtesting systems over the last several weeks, I've gone to the conclusion that I had no choice but to build my own, which I really didn't want to do. This video is exactly what I had in mind.
@Dinunzilicious
@Dinunzilicious 4 жыл бұрын
For anyone using Visual Studio 2019, this might be helpful: scriptreference.com/interfacing-a-c-dll-with-excel-2016-using-visual-studio-2019/
@Andrei_Solomin
@Andrei_Solomin 4 жыл бұрын
Спасибо!
@baileystark7629
@baileystark7629 4 жыл бұрын
Great video. I have one question. At 30:09, what are you doing to move on to the next line in ipdb? When I run the exact same code in Spyder df_init, df_update, and df_end do not appear in the variable explorer. Is there a setting I have to enable to view local variables in the variable explorer?
@bugrahankalayci
@bugrahankalayci 3 жыл бұрын
When you run, it stops at the breakpoint, then enter 'n' it goes next line and shows variable on variable explorer.
@zaphbeeblebrox5333
@zaphbeeblebrox5333 4 жыл бұрын
Hate to be pedantic, but lots of mistakes here. PDEs have nothing to do with stochasticity a priori. It turns out that when a stochastic process is sufficiently nice, i.e. is a Markov process, you can write down a PDE involving the infinitesimal generator of the process. Then certain conditional expectations satisfy this PDE. Roughly speaking, the average dynamics of the process can be described by the PDE. General PDE theory is about deterministic processes.
@genli3641
@genli3641 4 жыл бұрын
Thanks for the tutorial. Would please update this tutorial with recent VS2019 and Excel 2019? Looks like lots of things have changed.
@wolfix20021
@wolfix20021 4 жыл бұрын
Thanks a lot!
@elietaillard9944
@elietaillard9944 4 жыл бұрын
Does it works with .Net dll ?
@IOIOI_RiyanKhoiriSiregar
@IOIOI_RiyanKhoiriSiregar 4 жыл бұрын
mantap bosq
@Mlbbupdates2025
@Mlbbupdates2025 4 жыл бұрын
i have a problem in void main () how to fix this?
@dilrubaakbulut4788
@dilrubaakbulut4788 4 жыл бұрын
you can use only 'int main ()'
@alleyjohn
@alleyjohn 4 жыл бұрын
This is an amazing example of excel but if you want to solve math equation in seconds then connect with us at myassignmenthelp.com/equation-solver.html for a better solution by tools
@mahgoubishakabullahabdulna938
@mahgoubishakabullahabdulna938 4 жыл бұрын
Very good video, it is useful in probit
@evangelizadorevangelizador9620
@evangelizadorevangelizador9620 4 жыл бұрын
Repent ye. And you will have peaceful life. Romans 6, 23: For the wages of sin is death; but the gift of God is eternal life through Jesus Christ our Lord. Jesus Christ loves you. John 3, 16: For God so loved the world, that he gave his only begotten Son, that whosoever believeth in him should not perish, but have everlasting life.
@undefined_x00
@undefined_x00 4 жыл бұрын
Dude your typing and you are sooo slow omg
@beerensaft413
@beerensaft413 3 жыл бұрын
speed up ++
@黄鼎-u5e
@黄鼎-u5e 4 жыл бұрын
Your voice and the way you speak are really like one of my tutors. what a coincidence.