what happened that he did not finish the series ?? i am waiting for the last parts

Hi! Do you have any idea how I could pull out information based not just on tag, but on member? I can't find that info in the JSON response. Thank you!

Is there a way to get more specific info than just the tag? Eg instead of just us-gaap: RevenueFromContractWithCustomerExcludingAssessedTax, could we get the Member or Axis too (to distinguish between revenues from different things)? Thank you!

You assumed your data to be IID, all the code until the modeling part is good, modeling is problematic, time series data (specially non-stationary) is not IID, may be DID, but a strong assumption, so the train/test is just contaminated with samples from the future into the past, there is a parameter not to shuffle in train_test_split, but you would end with only one training and testing split, hard to evaluate the estimated error of a time-series model with just one train and test sample. Anything else nice job with the data preprocessing part.

thanks, useful =))

👍❤

Excellent video, very clear explanation. Thanks ❤❤👍👍

Thanks for the 3 parts of the video about Power Pivot, Pivot Tables, and DAX in VBA. They are so clear and easy to understand due to your merticulous design and explanation. Looking forward to more like this. Thank you very much ❤👍

gracias

How do you set it to export each table from the PowerPoint as a separate Worksheet in the Excel Workbook?

I am doing this in 2024 does this still work?

15:41 me looking at code I literally wrote: 🤔 The coding flow state is real

Finally got all this to work - how do you delete the data in a table and then add the data you want.

Really been good watching your trading bot creation so far. I know this is an old video but are you still keeping up with this script or is there a new one? I will check GitHub Thanks

This is really helpful. Could you please explain how to define 1st chart as "Chart1" to use ChartObjects("Chart1") call?

the view count on this is criminal

I thinking of creating another version of a “command bar” where a key binding opens up a form with a text and list box and you can search items using fizzy find. You could have all works sheet names and names ranges populate the list box and selecting them by hitting Enter would navigate there. Also you can add all you user defined subs like ‘RollWorkbook’ we have daily dates work books. Also you could have templates to populate from the active cell. This would make excel more like a modern app like the Obsidian note taking app.

Thank you.. What are the pre requisites (hardware/software) for getting started from scratch to enter into this realm without going to university? I ask because little is said on my 'phone'. Is it possible from books and being unplugged from internet..? A lot of hidden traps by design it's not explicit as shown in this video. Nicely explained.. ☺️

Will this work with the new Schwab since they bought out TDAmeritrade?

Hi, Iam trying this combination of com objects and python on solidworks application to read diagram annotations, but Iam unable to generate the makepy It throws an error like this: Please run makepy manually as running automatic makepy couldn't happen on this app # sldDispatch = win32.gencache.EnsureDispatch("SldWorks.Application")

Extremely helpful tutorial ;-) I just wonder, how I can extract a certain record from one of the tables to a spreadsheet.....

4 years late here, i can see that in this example you specified a range is there a way to use the data to specify range like for instance you already had A2 selected, so using the data you want to import and the current selected cell to determine the range

I was hung up on this code for a while until I figured out a few things. 1. You have to to Tools>References then find Outlook and Word and activate them and 2. I was using a very large amount of data so I had to switch my Datatype to "wdPasteEnhancedMetafile" and that worked.

Was really hoping to see the final 3 videos of this series. I hope he returns

Since Schwab bought TD Ameritrade after this series was put out, do you have a fix or recommendation for a similar API? TD won't let me sign up for their old API in favor of Schwab's. Apologies if this was already explained somewhere and I missed it.

Really well done, clear and concise.... Any knowledge on how to get values from the row in the selected column?

👍👍

WOW! Your content is amazing and genuinely helpful in practical applications, not just the regular tutorials with almost the same stuff. I really liked this series!!

Why are you using redirect url and what redirect url ur are using?

Hello, it is a pleasure to see this type of content, a question, do you have a video in which each item of a slicer can be whistled in a different color, for example? I have a "category" slicer and has the following items 1. warehouse 2. store 3. purchases then in the slicer on the slicer button store this red color on the store slicer button this is yellow on the slicer button you buy this one green is it possible to do that?

Hi Alex, thanks so much for creating this series. Hwever, I struggle with the create_session method which keeps on throwing an error.

what's the actual difference between the server and portfolio accounts?

You write film number for form number

edit: setting user agent fix this prob Hi there, first off huge thanks for the tutorial vids. However when I was testing the code (the soup.find_all(“table”, class_=“tableFile2”) part), I got an error saying I somehow exceeded the rate limit of SEC so it got me wondering how you could make it to make it run. 😮

Hi! i have a proyect in vb6, do you know how to do or include that function send/receive for read mails

How did you get that 'code' pane inside of Word? Seems super convenient.

Many thanks for this excellent video! I have gone through this and the 2 earlier videos for creating data imports via VBA. Now I am feeling very well prepared for my tasks and could even generate all needed code while I followed your video! I was googling hours and hours for automated imports to EXCEL before - your 3 videos cover the topic totally! 😍

Hi, could you please point me to the video on filling the form that you mentioned at the beginning of the video? Thank you.

How do I add or update the portfolio?

I need more content :)

Hey how to get access to range selected by user and then do something on that range?

I am trying to get the data from a query instead of a table, but it doesn't pull any data back. I used .BOF and .EOF and there are no records even though I have opened the query in Access and can see the data. Am I missing something. Thanks in advance

Hi Alex, great job with these tutorials....would you know what the equivalent of application.onkey(excel) be for PowerPoint?

awesome dude ya bot a new sub and like, keep up the work... i haven't come to the deep part of the course yet (but is it paper trading or actual real money trading?)

I'm sad you did not publish video after that one about Winforms with pythonnet and about your project to code a Excel Lib

Hello. I didn't get the 'Alex_credentials'. What is that? When it was defined? Tks

Super video 👍👍 thanks

I know I'm 4 years late, but your so impressive. I'm watching and this feels like magic. Thanks for sharing

Why did you not just point the task to the wscript.exe and pass the vbs as a parameter, this way you don't need the bat file .