what happened that he did not finish the series ?? i am waiting for the last parts
@charlottephillips46389 сағат бұрын
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!
@charlottephillips463810 сағат бұрын
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!
@carlosandrescastromarin777522 сағат бұрын
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.
@ITNec10 күн бұрын
thanks, useful =))
@kebincui13 күн бұрын
👍❤
@kebincui13 күн бұрын
Excellent video, very clear explanation. Thanks ❤❤👍👍
@kebincui13 күн бұрын
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 ❤👍
@predator21youtoube15 күн бұрын
gracias
@adnanaqeel605522 күн бұрын
How do you set it to export each table from the PowerPoint as a separate Worksheet in the Excel Workbook?
@GandalfTheBald24 күн бұрын
I am doing this in 2024 does this still work?
@willostrand655525 күн бұрын
15:41 me looking at code I literally wrote: 🤔 The coding flow state is real
@beginnerGuy2229 күн бұрын
Finally got all this to work - how do you delete the data in a table and then add the data you want.
@mattg844429 күн бұрын
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
@sid5dharthАй бұрын
This is really helpful. Could you please explain how to define 1st chart as "Chart1" to use ChartObjects("Chart1") call?
@amirrezamashaallahi1187Ай бұрын
the view count on this is criminal
@edmel144Ай бұрын
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.
@easyspeak101Ай бұрын
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.. ☺️
@chemiZtryАй бұрын
Will this work with the new Schwab since they bought out TDAmeritrade?
@srinivasbolem2870Ай бұрын
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")
@razzzoredgeАй бұрын
Extremely helpful tutorial ;-) I just wonder, how I can extract a certain record from one of the tables to a spreadsheet.....
@brandon-mr3ipАй бұрын
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
@adampatterson3125Ай бұрын
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.
@joekopplin4214Ай бұрын
Was really hoping to see the final 3 videos of this series. I hope he returns
@joekopplin4214Ай бұрын
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.
@carlosdasilva91242 ай бұрын
Really well done, clear and concise.... Any knowledge on how to get values from the row in the selected column?
@kebincui2 ай бұрын
👍👍
@TarushiKhanna2 ай бұрын
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!!
@prasathjs2 ай бұрын
Why are you using redirect url and what redirect url ur are using?
@carlosrobertomartinezandra91202 ай бұрын
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?
@ysnbtr2 ай бұрын
Hi Alex, thanks so much for creating this series. Hwever, I struggle with the create_session method which keeps on throwing an error.
@ysnbtr2 ай бұрын
what's the actual difference between the server and portfolio accounts?
@Luapnampahc2 ай бұрын
You write film number for form number
@WLSG4222 ай бұрын
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. 😮
@EVB6.02 ай бұрын
Hi! i have a proyect in vb6, do you know how to do or include that function send/receive for read mails
@Edgar_Scott2 ай бұрын
How did you get that 'code' pane inside of Word? Seems super convenient.
@user-gg5je2it5p2 ай бұрын
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! 😍
@tiptea81452 ай бұрын
Hi, could you please point me to the video on filling the form that you mentioned at the beginning of the video? Thank you.
@malakiyah60362 ай бұрын
How do I add or update the portfolio?
@nodswal2 ай бұрын
I need more content :)
@abhaykumar-cd5gu3 ай бұрын
Hey how to get access to range selected by user and then do something on that range?
@decbro24033 ай бұрын
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
@carlosdasilva91243 ай бұрын
Hi Alex, great job with these tutorials....would you know what the equivalent of application.onkey(excel) be for PowerPoint?
@kadaliakshay67703 ай бұрын
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?)
@echidne3 ай бұрын
I'm sad you did not publish video after that one about Winforms with pythonnet and about your project to code a Excel Lib
@Doomload3 ай бұрын
Hello. I didn't get the 'Alex_credentials'. What is that? When it was defined? Tks
@kebincui3 ай бұрын
Super video 👍👍 thanks
@jaysont53113 ай бұрын
I know I'm 4 years late, but your so impressive. I'm watching and this feels like magic. Thanks for sharing
@stevenoct19673 ай бұрын
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 .