<?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.post6863389307718970029..comments</id><updated>2024-12-13T03:11:35.450-08:00</updated><title type='text'>Comments on ListenData: How to Import Dividend Data into Excel</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/6863389307718970029/comments/default'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html'/><link rel="hub" href="http://pubsubhubbub.appspot.com/"/><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>16</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-608906068743301075</id><published>2024-10-31T11:36:42.904-07:00</published><updated>2024-10-31T11:36:42.904-07:00</updated><title type='text'>Yep it works now.  However it is too bad that Yaho...</title><content type='html'>Yep it works now.  However it is too bad that Yahoo does&amp;#39;nt provide some of the performance data for Mutual Funds and ETFs.  But thanks for the quick fix...</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/608906068743301075'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/608906068743301075'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730399802904#c608906068743301075' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/310344514790802055'/><author><name>boiler49</name><uri>https://www.blogger.com/profile/04054806223025160742</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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1026106786"/><gd:extendedProperty name="blogger.displayTime" value="October 31, 2024 at 11:36 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-746439095763808587</id><published>2024-10-30T17:51:42.442-07:00</published><updated>2024-10-30T17:51:42.442-07:00</updated><title type='text'>YF made a few changes to the backend so I updated ...</title><content type='html'>YF made a few changes to the backend so I updated the code accordingly. Please download the latest file and try again. Let me know if it works for you.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/746439095763808587'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/746439095763808587'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730335902442#c746439095763808587' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/310344514790802055'/><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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 30, 2024 at 5:51 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-310344514790802055</id><published>2024-10-30T11:10:17.700-07:00</published><updated>2024-10-30T11:10:17.700-07:00</updated><title type='text'>The WebHelpers fix still works after a day (Great!...</title><content type='html'>The WebHelpers fix still works after a day (Great!), but today the &amp;quot;Summary&amp;quot; button does not work.  The macro ends with no data and a MsgBox with   Error Code: 404...  At the same time the &amp;quot;Get Historical Data&amp;quot; macro works just fine...Ideas???</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/310344514790802055'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/310344514790802055'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730311817700#c310344514790802055' title=''/><author><name>boiler49</name><uri>https://www.blogger.com/profile/04054806223025160742</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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1026106786"/><gd:extendedProperty name="blogger.displayTime" value="October 30, 2024 at 11:10 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-5390063015530416067</id><published>2024-10-29T10:47:52.101-07:00</published><updated>2024-10-29T10:47:52.101-07:00</updated><title type='text'>Thank you for quick response.  Qualifying by chang...</title><content type='html'>Thank you for quick response.  Qualifying by changinging to WebHelpers.ParseJson seems to do the trick.   It worked last night, but dd not this morning.   But appears to be fixed now.  By the way am using Windows 11  and Excel 2021.  </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/5390063015530416067'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/5390063015530416067'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730224072101#c5390063015530416067' title=''/><author><name>boiler49</name><uri>https://www.blogger.com/profile/04054806223025160742</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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1026106786"/><gd:extendedProperty name="blogger.displayTime" value="October 29, 2024 at 10:47 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-7160880380976584071</id><published>2024-10-29T09:50:18.160-07:00</published><updated>2024-10-29T09:50:18.160-07:00</updated><title type='text'>Try replacing ParseJson with WebHelpers.ParseJson ...</title><content type='html'>Try replacing ParseJson with WebHelpers.ParseJson in Historical Module and see if it works.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/7160880380976584071'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/7160880380976584071'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730220618160#c7160880380976584071' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1764798168798864387'/><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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 29, 2024 at 9:50 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2594827992207328623</id><published>2024-10-29T09:35:39.491-07:00</published><updated>2024-10-29T09:35:39.491-07:00</updated><title type='text'>Which OS you are using? Mac or Windows? I can&amp;#39;...</title><content type='html'>Which OS you are using? Mac or Windows? I can&amp;#39;t reproduce this issue on Windows.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/2594827992207328623'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/2594827992207328623'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730219739491#c2594827992207328623' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1764798168798864387'/><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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 29, 2024 at 9:35 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1764798168798864387</id><published>2024-10-29T08:21:04.484-07:00</published><updated>2024-10-29T08:21:04.484-07:00</updated><title type='text'>Am looking at the Import Dividend Data into Excel ...</title><content type='html'>Am looking at the Import Dividend Data into Excel Worksheet.  am getting an error in the Historical module... in the Sub ExtractData...  the line   Set json = ParseJson(response.Content)  gives an error during runtime.   The error is  Compile error:  Ambiguous Name Detected:  ParseJson&lt;br /&gt;What is the fix?   Thanks&lt;br /&gt;</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1764798168798864387'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1764798168798864387'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730215264484#c1764798168798864387' title=''/><author><name>boiler49</name><uri>https://www.blogger.com/profile/04054806223025160742</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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1026106786"/><gd:extendedProperty name="blogger.displayTime" value="October 29, 2024 at 8:21 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4236054181764827260</id><published>2024-10-28T07:12:23.112-07:00</published><updated>2024-10-28T07:12:23.112-07:00</updated><title type='text'>I am glad you found it useful. Cheers!</title><content type='html'>I am glad you found it useful. Cheers!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/4236054181764827260'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/4236054181764827260'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730124743112#c4236054181764827260' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1687009801504100565'/><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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="October 28, 2024 at 7:12 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1687009801504100565</id><published>2024-10-28T06:50:32.422-07:00</published><updated>2024-10-28T06:50:32.422-07:00</updated><title type='text'>Mega thanks. Brilliant. Thank you SO much. </title><content type='html'>Mega thanks. Brilliant. Thank you SO much. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1687009801504100565'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1687009801504100565'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1730123432422#c1687009801504100565' title=''/><author><name>Erica and Jon Dyson</name><uri>https://www.blogger.com/profile/12772937936623550739</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='24' src='http://1.bp.blogspot.com/_l-nNLw3w-gY/SMLr8G8oxDI/AAAAAAAAAAY/czscrL6IQ2M/S220/Forest.jpg'/></author><thr:in-reply-to xmlns:thr='http://purl.org/syndication/thread/1.0' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1525522582"/><gd:extendedProperty name="blogger.displayTime" value="October 28, 2024 at 6:50 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4964603931544022229</id><published>2024-09-23T12:26:26.287-07:00</published><updated>2024-09-23T12:26:26.287-07:00</updated><title type='text'>Cool. Cheers!</title><content type='html'>Cool. Cheers!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/4964603931544022229'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/4964603931544022229'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1727119586287#c4964603931544022229' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/62635041665398760'/><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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 12:26 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-62635041665398760</id><published>2024-09-23T12:25:51.931-07:00</published><updated>2024-09-23T12:25:51.931-07:00</updated><title type='text'>Yep - that fix worked perfectly. This is an amazin...</title><content type='html'>Yep - that fix worked perfectly. This is an amazing spreadsheet - thank you. !!!!</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/62635041665398760'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/62635041665398760'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1727119551931#c62635041665398760' 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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 12:25 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-6706849254298283841</id><published>2024-09-23T12:19:40.165-07:00</published><updated>2024-09-23T12:19:40.165-07:00</updated><title type='text'>I guess the problem lies in underlying data.. It&amp;#...</title><content type='html'>I guess the problem lies in underlying data.. It&amp;#39;s easy to fix. Replace Array(1, 2, 3, 4) with Array(1, 3, 4) and it should fix the duplicate issue.. Let me know if it works for you.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/6706849254298283841'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/6706849254298283841'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1727119180165#c6706849254298283841' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1249052825281416936'/><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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 12:19 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-1249052825281416936</id><published>2024-09-23T12:10:19.962-07:00</published><updated>2024-09-23T12:10:19.962-07:00</updated><title type='text'>Thanks - very strange indeed. Is there a way I can...</title><content type='html'>Thanks - very strange indeed. Is there a way I can share my spreadsheet with you (which is just the same one I downloaded from you), and the only thing I changed is the date range and the ticker? Not a huge deal, I can always just move the position of the symbol and it seems to resolve itself. I re-downloaded the sheet again from your link above and still getting the same behaviour with the duplicate $0.80</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1249052825281416936'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/1249052825281416936'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1727118619962#c1249052825281416936' 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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 12:10 PM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-4701061158399540268</id><published>2024-09-23T11:47:46.837-07:00</published><updated>2024-09-23T11:47:46.837-07:00</updated><title type='text'>Thanks for reporting the issue. However, I am gett...</title><content type='html'>Thanks for reporting the issue. However, I am getting 0.796 only irrespective of the position of this ticker.</content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/4701061158399540268'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/4701061158399540268'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1727117266837#c4701061158399540268' title=''/><link rel='related' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/3221452438158635394'/><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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-966036103"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 11:47 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-2956463442890810799</id><published>2024-09-23T11:29:34.692-07:00</published><updated>2024-09-23T11:29:34.692-07:00</updated><title type='text'>A little more info on the bug that I reported - wh...</title><content type='html'>A little more info on the bug that I reported - what&amp;#39;s strange is that it appears to only happen to VTI when it is in the first position in the list of tickers. When I put a different ticker first, then I don&amp;#39;t get that duplicate. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/2956463442890810799'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/2956463442890810799'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1727116174692#c2956463442890810799' 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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 11:29 AM"/></entry><entry><id>tag:blogger.com,1999:blog-7958828565254404797.post-3221452438158635394</id><published>2024-09-23T11:14:18.802-07:00</published><updated>2024-09-23T11:14:18.802-07:00</updated><title type='text'>Hi Deepanshu, thanks so much for putting in the ef...</title><content type='html'>Hi Deepanshu, thanks so much for putting in the effort for this. Will be super useful to so many people. I think there be a small bug in your macro - not sure exactly how to fix it, but I used the ticker VTI. And I had the Start date as Aug 23, 2022 and End date of Sept 23, 2024 and when I clicked Historical Info, I get a duplicate entry. for Sept 23, 2022 - one shows $0.80 and the second for the same date shows $0.796 (the second agrees with what Yahoo has). I can send you a screenshot, but not sure how to attach it to this post. </content><link rel='edit' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/3221452438158635394'/><link rel='self' type='application/atom+xml' href='https://www.blogger.com/feeds/7958828565254404797/6863389307718970029/comments/default/3221452438158635394'/><link rel='alternate' type='text/html' href='https://www.listendata.com/2024/09/how-to-import-dividend-data-into-excel.html?showComment=1727115258802#c3221452438158635394' 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/2024/09/how-to-import-dividend-data-into-excel.html' ref='tag:blogger.com,1999:blog-7958828565254404797.post-6863389307718970029' source='http://www.blogger.com/feeds/7958828565254404797/posts/default/6863389307718970029' type='text/html'/><gd:extendedProperty name="blogger.itemClass" value="pid-1102190386"/><gd:extendedProperty name="blogger.displayTime" value="September 23, 2024 at 11:14 AM"/></entry></feed>