Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by olli.excel; 03-08-2017 at 06:45 PM.
Here some code that I use to get stock prices for which ever day you choose.
Please Login or Register to view this content.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank you for the answer! I haven`t use a function before in VBA, so I am wondering how to excecute the function? Want the code to work on all sheets. Seems like its not possible to get the closing price for the same day into excel from Yahoo. Also tried without macro.
This link should help you
http://www.fontstuff.com/vba/vbatut01.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks