<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:gd="http://schemas.google.com/g/2005"><id>tag:blogger.com,1999:blog-7958828565254404797.post683456374716730421..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: How to Download Historical Stock Data to Excel for Free</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='https://www.listendata.com/feeds/comments/default'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><link rel='next' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default?start-index=26&max-results=25'/><author><name>Deepanshu Bhalla</name><uri>http://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>44</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3522079668805763778</id><published>2024-10-19T05:33:28.047-07:00</published><updated>2024-10-19T05:33:28.047-07:00</updated><title type='text'>Thanks, will do!</title><content type='html'>Thanks, will do!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3522079668805763778'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3522079668805763778'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1729341208047#c3522079668805763778' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><author><name>Évariste Galois</name><uri>https://www.blogger.com/profile/02620297275343168286</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-477306749"/><gd:extendedProperty name="blogger.displayTime" value="October 19, 2024 at 5:33 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3969526698337669038</id><published>2024-10-19T04:05:12.972-07:00</published><updated>2024-10-19T04:05:12.972-07:00</updated><title type='text'>I don&#39;t know what&#39;s causing this issue. It...</title><content type='html'>I don&#39;t know what&#39;s causing this issue. It seems related to the recent updates. Contact Microsoft support team.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3969526698337669038'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3969526698337669038'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1729335912972#c3969526698337669038' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 19, 2024 at 4:05 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5423108981766908457</id><published>2024-10-18T23:51:25.325-07:00</published><updated>2024-10-18T23:51:25.325-07:00</updated><title type='text'>Hi Deepanshu, it seems I&#39;m unlucky these days....</title><content type='html'>Hi Deepanshu, it seems I&#39;m unlucky these days... Your macro worked fine last week but now I get an error message box on Mac:<br />&quot;microsoft visual basic - Internal error&quot;<br />Any idea why it doesn&#39;t work? I can&#39;t even compile the VB code. I&#39;m on Mac OS Ventura 13.7 and MS Office 365 on Mac.<br />(It still work on Windows.)</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/5423108981766908457'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/5423108981766908457'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1729320685325#c5423108981766908457' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><author><name>Évariste Galois</name><uri>https://www.blogger.com/profile/02620297275343168286</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-477306749"/><gd:extendedProperty name="blogger.displayTime" value="October 18, 2024 at 11:51 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2843598718781737575</id><published>2024-10-13T01:27:37.885-07:00</published><updated>2024-10-13T01:27:37.885-07:00</updated><title type='text'>Thanks a lot Deepanshu. Have a nice day!</title><content type='html'>Thanks a lot Deepanshu. Have a nice day!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2843598718781737575'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2843598718781737575'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1728808057885#c2843598718781737575' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><author><name>Évariste Galois</name><uri>https://www.blogger.com/profile/02620297275343168286</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-477306749"/><gd:extendedProperty name="blogger.displayTime" value="October 13, 2024 at 1:27 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4087849654381275988</id><published>2024-10-12T23:23:22.571-07:00</published><updated>2024-10-12T23:23:22.571-07:00</updated><title type='text'>I have removed the password. </title><content type='html'>I have removed the password. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4087849654381275988'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4087849654381275988'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1728800602571#c4087849654381275988' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 12, 2024 at 11:23 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4754270586544590231</id><published>2024-10-12T11:15:07.876-07:00</published><updated>2024-10-12T11:15:07.876-07:00</updated><title type='text'>Hi Deepanshu, thanks for the update. The latest ma...</title><content type='html'>Hi Deepanshu, thanks for the update. The latest macro seems to work on macOS. However, the VBA code is password protected and I&#39;d like to access to it (I made some slight adjustments to the previous version). Would you mind removing the password? Or sending it to me in a separate email (gsdl@free.fr)? Thanks!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4754270586544590231'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4754270586544590231'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1728756907876#c4754270586544590231' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><author><name>Évariste Galois</name><uri>https://www.blogger.com/profile/02620297275343168286</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-477306749"/><gd:extendedProperty name="blogger.displayTime" value="October 12, 2024 at 11:15 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2244979707086477181</id><published>2024-10-12T06:41:21.763-07:00</published><updated>2024-10-12T06:41:21.763-07:00</updated><title type='text'>The macro can run on both Windows and macOS. Downl...</title><content type='html'>The macro can run on both Windows and macOS. Download the latest file. Please check and confirm the same. Thanks!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2244979707086477181'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2244979707086477181'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1728740481763#c2244979707086477181' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 12, 2024 at 6:41 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3734821736660786388</id><published>2024-10-12T00:23:42.606-07:00</published><updated>2024-10-12T00:23:42.606-07:00</updated><title type='text'>Hi Deepanshu, your macro works perfectly fine on W...</title><content type='html'>Hi Deepanshu, your macro works perfectly fine on Windows but there&#39;s an error when running on Mac. I know you don&#39;t provide support on iOS but maybe you can help me searching in the right direction. In sub &quot;getCookieCrumb&quot;, I get an error at line: <br /> Set objRequest = CreateObject(&quot;WinHttp.WinHttpRequest.5.1&quot;)<br />The error message is:<br /> Run-time error 429: ActiveX component can&#39;t create object<br />Any idea what I could do to fix it?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3734821736660786388'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1728717822606#c3734821736660786388' title=''/><author><name>Évariste Galois</name><uri>https://www.blogger.com/profile/02620297275343168286</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-477306749"/><gd:extendedProperty name="blogger.displayTime" value="October 12, 2024 at 12:23 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3760697314080144529</id><published>2024-09-27T07:59:49.936-07:00</published><updated>2024-09-27T07:59:49.936-07:00</updated><title type='text'>Thanks for highlighting</title><content type='html'>Thanks for highlighting</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3760697314080144529'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3760697314080144529'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1727449189936#c3760697314080144529' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3887836945299890408'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 27, 2024 at 7:59 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3887836945299890408</id><published>2024-09-27T03:23:21.210-07:00</published><updated>2024-09-27T03:23:21.210-07:00</updated><title type='text'>Hi Deepanshu,

Just a quick pointer:

StartPos wil...</title><content type='html'>Hi Deepanshu,<br /><br />Just a quick pointer:<br /><br />StartPos will always be &gt; 0, as you have added Len(startTag)<br /><br />-----------------<br /><br />Function ExtractValue(ByVal json As String, ByVal startTag As String, ByVal endTag As String) As String<br /> Dim startPos As Long<br /> Dim endPos As Long<br /> Dim extractedValue As String<br /> <br /> startPos = InStr(1, json, startTag) + Len(startTag) &#39; &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;<br /> endPos = InStr(startPos, json, endTag)<br /> <br /> If startPos &gt; 0 And endPos &gt; 0 Then<br /> extractedValue = Mid(json, startPos, endPos - startPos)<br /> ExtractValue = Trim(extractedValue)<br /> Else<br /> ExtractValue = &quot;&quot;<br /> End If<br />End Function</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3887836945299890408'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3887836945299890408'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1727432601210#c3887836945299890408' title=''/><author><name>Chris Muller</name><uri>https://www.blogger.com/profile/13804157515030056309</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-44267306"/><gd:extendedProperty name="blogger.displayTime" value="September 27, 2024 at 3:23 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-518446219037321401</id><published>2024-09-24T06:56:42.760-07:00</published><updated>2024-09-24T06:56:42.760-07:00</updated><title type='text'>Each URL (API) has a different structure and can&#...</title><content type='html'>Each URL (API) has a different structure and can&#39;t be as simple as just replacing the URL. I don&#39;t provide support that&#39;s beyond the code mentioned in the article.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/518446219037321401'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/518446219037321401'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1727186202760#c518446219037321401' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4875281129024181466'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 24, 2024 at 6:56 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4239682802359717477</id><published>2024-09-24T06:34:42.723-07:00</published><updated>2024-09-24T06:34:42.723-07:00</updated><title type='text'>used new URL https://query2.finance.yahoo.com/v8/f...</title><content type='html'>used new URL https://query2.finance.yahoo.com/v8/finance/chart/ still result is blank. Please if u allow i&#39;ll share my VBA excel file link (wetransfer)</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4239682802359717477'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4239682802359717477'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1727184882723#c4239682802359717477' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4875281129024181466'/><author><name>vishu</name><uri>https://www.blogger.com/profile/16398707903170925611</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2131501459"/><gd:extendedProperty name="blogger.displayTime" value="September 24, 2024 at 6:34 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3930136483008798169</id><published>2024-09-24T04:49:08.486-07:00</published><updated>2024-09-24T04:49:08.486-07:00</updated><title type='text'>The old URL you were using no longer works. Use th...</title><content type='html'>The old URL you were using no longer works. Use the macro file mentioned in the article.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3930136483008798169'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3930136483008798169'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1727178548486#c3930136483008798169' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4875281129024181466'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 24, 2024 at 4:49 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4875281129024181466</id><published>2024-09-24T01:52:07.990-07:00</published><updated>2024-09-24T01:52:07.990-07:00</updated><title type='text'>Hi Deepanshu thank you very much for your code wor...</title><content type='html'>Hi Deepanshu thank you very much for your code working perfect.<br />But when i am trying to implement (just change url) in my sheet its giving no error and result blank. if possible can you check code and modify please as i dont have any codeing knowlage below code also i pickup from internet only and did my required changes in excel file and if i want to share my excel vba file please suggest the option. Saying comment is too long</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4875281129024181466'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/4875281129024181466'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1727167927990#c4875281129024181466' title=''/><author><name>vishu</name><uri>https://www.blogger.com/profile/16398707903170925611</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-2131501459"/><gd:extendedProperty name="blogger.displayTime" value="September 24, 2024 at 1:52 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8474820485813724698</id><published>2024-09-23T10:10:59.516-07:00</published><updated>2024-09-23T10:10:59.516-07:00</updated><title type='text'>I have prepared the macro. Check out this link - h...</title><content type='html'>I have prepared the macro. Check out this link - https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/8474820485813724698'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/8474820485813724698'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1727111459516#c8474820485813724698' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3918476608785290025'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 10:10 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8523109713355979380</id><published>2024-09-19T17:41:26.509-07:00</published><updated>2024-09-19T17:41:26.509-07:00</updated><title type='text'>thanks Deepanshu. Looking forward to it - suspect ...</title><content type='html'>thanks Deepanshu. Looking forward to it - suspect your spreadsheet/macro will get fantastic usage as many people look to download historic dividend info. I certainly will find it incredibly helpful. Thank you in advance !!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/8523109713355979380'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/8523109713355979380'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726792886509#c8523109713355979380' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3918476608785290025'/><author><name>Quick Hand Sally</name><uri>https://www.blogger.com/profile/12989981991572505317</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 19, 2024 at 5:41 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6418567545134659893</id><published>2024-09-19T15:36:26.838-07:00</published><updated>2024-09-19T15:36:26.838-07:00</updated><title type='text'>Got it. It&#39;s in the same API only. I will work...</title><content type='html'>Got it. It&#39;s in the same API only. I will work on it tomorrow and update you. I will create a new post for this as it will be confusing to include dividend in this macro.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/6418567545134659893'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/6418567545134659893'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726785386838#c6418567545134659893' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3918476608785290025'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 19, 2024 at 3:36 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3135974845975072842</id><published>2024-09-19T14:23:51.420-07:00</published><updated>2024-09-19T14:23:51.420-07:00</updated><title type='text'>And for clarity, allow the user to enter a list of...</title><content type='html'>And for clarity, allow the user to enter a list of symbols (by way of a table), and have the API return all dividends for all the symbols in the table for the given time period. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3135974845975072842'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3135974845975072842'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726781031420#c3135974845975072842' title=''/><author><name>Quick Hand Sally</name><uri>https://www.blogger.com/profile/12989981991572505317</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 19, 2024 at 2:23 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-8935531879345769021</id><published>2024-09-19T14:21:52.536-07:00</published><updated>2024-09-19T14:21:52.536-07:00</updated><title type='text'>Similar to historical stock prices that you have, ...</title><content type='html'>Similar to historical stock prices that you have, allow the user to enter a symbol, start and end date and return all the dividend payouts for the dates for that symbol. see this screen on Yahoo <br />https://finance.yahoo.com/quote/MSFT/history/?period1=1695158409&amp;period2=1726780809&amp;interval=capitalGain%7Cdiv%7Csplit&amp;filter=div&amp;frequency=1d&amp;includeAdjustedClose=true</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/8935531879345769021'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/8935531879345769021'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726780912536#c8935531879345769021' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3918476608785290025'/><author><name>Quick Hand Sally</name><uri>https://www.blogger.com/profile/12989981991572505317</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 19, 2024 at 2:21 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-202132818949894177</id><published>2024-09-19T14:17:15.204-07:00</published><updated>2024-09-19T14:17:15.204-07:00</updated><title type='text'>No, dividend information is not stored in this API...</title><content type='html'>No, dividend information is not stored in this API. It&#39;s a separate API. What exactly dividend information do you want? </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/202132818949894177'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/202132818949894177'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726780635204#c202132818949894177' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3918476608785290025'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 19, 2024 at 2:17 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3918476608785290025</id><published>2024-09-19T09:54:24.457-07:00</published><updated>2024-09-19T09:54:24.457-07:00</updated><title type='text'>Hi Deepanshi - does your macro have (or can it be ...</title><content type='html'>Hi Deepanshi - does your macro have (or can it be modified) to download dividend info from Yahoo after the recent change in Sept that Yahoo made?</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3918476608785290025'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3918476608785290025'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726764864457#c3918476608785290025' title=''/><author><name>Quick Hand Sally</name><uri>https://www.blogger.com/profile/12989981991572505317</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 19, 2024 at 9:54 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2967107890435004212</id><published>2024-09-12T02:49:47.467-07:00</published><updated>2024-09-12T02:49:47.467-07:00</updated><title type='text'>I don&#39;t provide support that&#39;s beyond the ...</title><content type='html'>I don&#39;t provide support that&#39;s beyond the code mentioned in the article</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2967107890435004212'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2967107890435004212'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726134587467#c2967107890435004212' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2411341945017178721'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 12, 2024 at 2:49 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7235912136419876255</id><published>2024-09-12T01:31:22.506-07:00</published><updated>2024-09-12T01:31:22.506-07:00</updated><title type='text'>Hi</title><content type='html'>Hi</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/7235912136419876255'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/7235912136419876255'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726129882506#c7235912136419876255' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/2411341945017178721'/><author><name>JB</name><uri>https://www.blogger.com/profile/03578302051201990102</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-143518158"/><gd:extendedProperty name="blogger.displayTime" value="September 12, 2024 at 1:31 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3620772626396499442</id><published>2024-09-11T02:45:56.388-07:00</published><updated>2024-09-11T02:45:56.388-07:00</updated><title type='text'>Yes, the HandleNulls function works fine now 👍, t...</title><content type='html'>Yes, the HandleNulls function works fine now 👍, thanks!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3620772626396499442'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/3620772626396499442'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726047956388#c3620772626396499442' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/7043955870352187276'/><author><name>Évariste Galois</name><uri>https://www.blogger.com/profile/02620297275343168286</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-477306749"/><gd:extendedProperty name="blogger.displayTime" value="September 11, 2024 at 2:45 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7392601320775162762</id><published>2024-09-11T01:29:54.247-07:00</published><updated>2024-09-11T01:29:54.247-07:00</updated><title type='text'>Awesome. Just wanted to double check the updated f...</title><content type='html'>Awesome. Just wanted to double check the updated function HandleNulls works for you.. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/7392601320775162762'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/7392601320775162762'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html?showComment=1726043394247#c7392601320775162762' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/683456374716730421/comments/default/7043955870352187276'/><author><name>Deepanshu Bhalla</name><uri>https://www.blogger.com/profile/09802839558125192674</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='32' src='//blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXm_iOrXFR9Ls-mjtOci4qd1m1V1TXkkWJINuMy84-Axo5pNS6CG7oKwR7hfHHI3tB1yuz8W_qo9HK2Cw5fHfe_4cL_2DCf_LyoK9LMLicZojbNYgypIP-RXNsw1GsVhk/s100/pic.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2021/02/excel-macro-historical-stock-data.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-683456374716730421' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/683456374716730421' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 11, 2024 at 1:29 AM"/></entry></feed>