User Profile
djk5214
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: VBA / Macro / Spilled Array / StockHistory
And regardless of what I plan to use the macro for, I still would like to understand why this specific function does not want to work within a macro. This could have implications for a wide variety of uses. If the issue is with spilled arrays itself, then stockhistory isn't the only way to create a spilled array, and I'm sure others would like to know how to fix this issue as well.Re: VBA / Macro / Spilled Array / StockHistory
The macro in the screenshot is just a basic script to show what my issue is. In actuality, I want to test my strategies on a hundred different stocks or so. So instead of me manually performing a stock history lookup on every single stock, I want a macro to automatically run through a list of stocks and collect data from each stockhistory lookup. That way, I just click "run" once and I get my list of data. It would save me a huge amount of time.VBA / Macro / Spilled Array / StockHistory
Hi, I'm struggling to get a simple VBA macro to get data from a stockhistory spilled array. Please see screenshots. Basically, the stockhistory function runs fine manually outside of a macro. But if the stockhistory function attempts to pull stock data within a macro, it gets stuck on a #Busy! error indefinitely until the macro is aborted. As soon as I end the macro run, the spilled array will automatically finish populating without any additional input on my part. This proves to me that there's nothing wrong with the input. For some reason, Excel does not want to finish performing this stockhistory function while the macro is still running, or while in debugging/step mode. I don't know if this is an issue with stockhistory, with spilled arrays, with pulling info from external sources, etc. I'm hoping there's just a setting or a trick that I don't know about yet. Thanks for any help!Data Types (Stocks and Geography) Do not Appear in Excel
I recently purchased the Microsoft 365 personal subscription specifically for the new Stocks feature under Date Types, but so far I have not been able to make it appear in my Excel program installed on my computer. I can get it to show up in the Excel App on Office.com, but I really need it to be functional on the Excel installed on my PC as well. (See attached images) Solutions I've already attempted: -I uninstalled everything related to Office and reinstalled the latest versions. -I updated my Windows 10 to the latest version. -I did a quick repair on my Office program. -I made sure my language is set to English. -I made sure I'm connected to the internet. My system and hardware: -Windows 10 Version 20H2 Build 19042.985 -Microsoft Excel Version 2104 Build 13929.20296 Thanks for your help
