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Ай бұрын
Why using log returns are more accurate?
@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.
@NareshSen6 ай бұрын
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Ай бұрын
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?
@Icantthinkofanyname489 ай бұрын
Thank you. Very straightforward
@chongqiqu9 ай бұрын
Thank you,sir
@namansinghyadav305310 ай бұрын
These prices are opening price or closing price ?
@xkolm4910 ай бұрын
It is already some time since I made this video so don't recall exactly but it is almost surely closing.
@ronny987110 ай бұрын
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'
@xkolm4910 ай бұрын
I suppose you are using python 3.12? Have a look here: stackoverflow.com/a/77638756/2743931
@ronny987110 ай бұрын
@@xkolm49 thanks, yesterday reinstalled anaconda and everything worked
@auliasucik3173 Жыл бұрын
Thank you, good explanation 👍
@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 Жыл бұрын
I'm new in trading, but after your videos I'm starting to undestand it really better!
@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Ай бұрын
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 Жыл бұрын
If i use c++ swig to python, is it possible to keep performance of c++?
@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 Жыл бұрын
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 Жыл бұрын
Which data is this opening or closing
@PES2011vsFifa11 Жыл бұрын
This was very useful, thank you!
@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
@jonesing7772 жыл бұрын
Thanks 🙏
@ЕвгенийКрасилов-о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...
@xkolm492 жыл бұрын
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о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)
@newtonocharimenyenya24582 жыл бұрын
Great. Thanks so much. A Very Great Piece.
@FlablessGuy2 жыл бұрын
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.
@amit706073 жыл бұрын
Explanation flow was very organized, logical and simple. Hence, interesting and easy to understand. Nice job. looking forward for more videos.
@Silvertestrun3 жыл бұрын
Ty
@mas150313 жыл бұрын
Could you pls make video on how to calculate implied volality intraday of options
@lnk773 жыл бұрын
poor explanationn and very log, Oher examples are max. 5 min, shortles and more descriptive
@VincentAutos3 жыл бұрын
excellent video. works for me. thanks so much
@coolck5playmc3 жыл бұрын
get a better mic bro
@raulantonioboadaoporto21453 жыл бұрын
Excellent
@Archak773 жыл бұрын
Thats a real good one...if u can make a video on usinf COM introp in C# and using it in asp.net
@over61283 жыл бұрын
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.
@over61283 жыл бұрын
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.
@over61283 жыл бұрын
But like said, when I removed 'yahoo' or 'google' I instead recieve the KeyError for 'symbol'
@tieptran31023 жыл бұрын
Please help me, How to use *.DLL 32 bit for VBA (Excel) in Windows 64 bit???
@ΑπόστολοςΜουμτζής-π5χ3 жыл бұрын
when searching excel tutorials the one with the smaller duration wins.
@statisticalanalysiswithiva79143 жыл бұрын
Thank you! This very helpful .
@byzetaweb3 жыл бұрын
Congratulation for the video. I have a question is posible put location like asi: ActiveWorkbook.path & "\squareDLL.dll" ?
@ahmed1997tareq4 жыл бұрын
thank you
@farmkess19314 жыл бұрын
Now i know how to use a C or C++ program. It helps me to continue study C ans C++. Thank you.
@capullincolorado56294 жыл бұрын
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.
@cnaccio4 жыл бұрын
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.
@Dinunzilicious4 жыл бұрын
For anyone using Visual Studio 2019, this might be helpful: scriptreference.com/interfacing-a-c-dll-with-excel-2016-using-visual-studio-2019/
@Andrei_Solomin4 жыл бұрын
Спасибо!
@baileystark76294 жыл бұрын
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?
@bugrahankalayci3 жыл бұрын
When you run, it stops at the breakpoint, then enter 'n' it goes next line and shows variable on variable explorer.
@zaphbeeblebrox53334 жыл бұрын
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.
@genli36414 жыл бұрын
Thanks for the tutorial. Would please update this tutorial with recent VS2019 and Excel 2019? Looks like lots of things have changed.
@wolfix200214 жыл бұрын
Thanks a lot!
@elietaillard99444 жыл бұрын
Does it works with .Net dll ?
@IOIOI_RiyanKhoiriSiregar4 жыл бұрын
mantap bosq
@Mlbbupdates20254 жыл бұрын
i have a problem in void main () how to fix this?
@dilrubaakbulut47884 жыл бұрын
you can use only 'int main ()'
@alleyjohn4 жыл бұрын
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
@mahgoubishakabullahabdulna9384 жыл бұрын
Very good video, it is useful in probit
@evangelizadorevangelizador96204 жыл бұрын
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_x004 жыл бұрын
Dude your typing and you are sooo slow omg
@beerensaft4133 жыл бұрын
speed up ++
@黄鼎-u5e4 жыл бұрын
Your voice and the way you speak are really like one of my tutors. what a coincidence.