[smf_addin] Digest Number 4408

EXCEL Stock Market Functions Add-in Group

7 Messages

Digest #4408

1a

Re: Fidelity not returning Dividend info by bobobfd

1b

Re: Fidelity not returning Dividend info by bobobfd

1c

Re: Fidelity not returning Dividend info by bobobfd

1d

Re: Fidelity not returning Dividend info by bobobfd

1e

Re: Fidelity not returning Dividend info by bobobfd

1f

Re: Fidelity not returning Dividend info by bobobfd

1g

Re: Fidelity not returning Dividend info by "Randy Harmelink" rharmelink

Messages

1a

Re: Fidelity not returning Dividend info

Fri Oct 5, 2018 2:25 pm (PDT) . Posted by:

bobobfd

If I could provide you with a screen print and the html source of the referenced page would that be enough to debug? ~ Thanks.

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1b

Re: Fidelity not returning Dividend info

Fri Oct 5, 2018 2:33 pm (PDT) . Posted by:

bobobfd

Here are the links
HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing


Screen print - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing


Thanks ~ Bruce

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1c

Re: Fidelity not returning Dividend info

Fri Oct 5, 2018 2:39 pm (PDT) . Posted by:

bobobfd

Sorry - screen print is here.


https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1d

Re: Fidelity not returning Dividend info

Fri Oct 5, 2018 2:40 pm (PDT) . Posted by:

bobobfd

If I could provide you with a screen print of the source page and a copy of the page's html code would that be enough to find the problem.


Thanks ~ Bruce


Screen print - https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing


HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1e

Re: Fidelity not returning Dividend info

Fri Oct 5, 2018 2:45 pm (PDT) . Posted by:

bobobfd

If I could provide you with a screen print of the source page and a copy of the page's html code would that be enough to find the problem.


Thanks ~ Bruce


Screen print - https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing


HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing






If I could provide you with a screen print of the source page and a copy of the page's html code would that be enough to find the problem.


Thanks ~ Bruce


Screen print - https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing


HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing






If I could provide you with a screen print of the source page and a copy of the page's html code would that be enough to find the problem.


Thanks ~ Bruce


Screen print - https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing


HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing






If I could provide you with a screen print of the source page and a copy of the page's html code would that be enough to find the problem.


Thanks ~ Bruce


Screen print - https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing


HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing






If I could provide you with a screen print of the source page and a copy of the page's html code would that be enough to find the problem? Specifically I'm looking to extract the Ex-dividend date and Dividend amount.



Thank you ~ Bruce


Screen print - https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing


HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1f

Re: Fidelity not returning Dividend info

Fri Oct 5, 2018 2:46 pm (PDT) . Posted by:

bobobfd

If I could provide you with a screen print of the source page and a copy of the page's html code would that be enough to find the problem? Specifically I want to extract the Ex-Dividend Date and Dividend Amount.



Thank you ~ Bruce


Screen print - https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing https://drive.google.com/file/d/10_KsiHZs4NSkUzeBl-QNmT6kHLFfG1Me/view?usp=sharing


HTML - https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing https://drive.google.com/file/d/1BtRtiK0odXeGh0yOYEBNVfZUxNHXsZp6/view?usp=sharing

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

1g

Re: Fidelity not returning Dividend info

Fri Oct 5, 2018 2:59 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

From what you sent for the screenshot, it looks like the URL hasn't
changed. And your formulas appear to work fine with the HTML source code
you sent. You probably just need to create the IE security cookie so EXCEL
and the add-in can access the secured web pages.

Use the EXCEL IE object (keyboard shortcut alt+d+d+w), go to the website
and login, then cancel out of the IE object. Then run the
smfForceRecalculation macro to purge any saved copies of web pages, and try
again.

On Wed, Oct 3, 2018 at 3:31 PM bobobfd@... wrote:

>
> I have the following entries in my smf-elements-20.txt file which worked
> fine until today. I don't know why it's not working anymore. Can you help?
> Thanks ~ Bruce
>
> 18902;Fidelity;Ex-Dividend Date;=RCHGetTableCell("
> https://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=~~~~~
> ",1,"Ex-Dividend")
> 18903;Fidelity;Dividend Amt;=RCHGetTableCell("
> https://eresearch.fidelity.com/eresearch/evaluate/quote.jhtml?symbols=~~~~~
> ",2,"Ex-Dividend";,,,,2,"</table")
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (7) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use