8 New Messages
Digest #2763
Messages
Sat Sep 7, 2013 6:51 am (PDT) . Posted by:
tomasi1957
Correct.......I meant to put in the original message that it was
return the value "NA".
--- In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
An example and a description of "quit working" would have
helped...
I just tried it with ticker symbol MMM and got "N/A" returned.
Unfortunately, that's what Yahoo is sending. I'm assuming the
"N/A" is what you mean by "quit working"?
On Fri, Sep 6, 2013 at 6:07 PM, <tomasi1957@...> wrote:
I have noticed that my getyahooquotes quit working for dividend
pay dates. the element I am using is r1 for the date......any
thoughts?
return the value "NA"
--- In smf_addin@yahoogrou
An example and a description of "quit working" would have
helped...
I just tried it with ticker symbol MMM and got "N/A" returned.
Unfortunately, that's what Yahoo is sending. I'm assuming the
"N/A" is what you mean by "quit working"
On Fri, Sep 6, 2013 at 6:07 PM, <tomasi1957@
I have noticed that my getyahooquotes quit working for dividend
pay dates. the element I am using is r1 for the date......any
thoughts?
Sat Sep 7, 2013 7:48 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
To be honest, I could not figure out how to make the RCHGetHTMLTable() solution work.
Maybe, I am not putting forth enough effort but I have spent a lot of time on this.
I'll try the RCHGetHTMLTable() solution again. But could use any guidance you have to offer.
Thanks, Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, September 06, 2013 10:20 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Cannot figure out hw to use the smfgettagcontent function
What was wrong with the RCHGetHTMLTable() solution? That was quick and easy. Parsing that data out will be a mess.
On Fri, Sep 6, 2013 at 4:17 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
Randy, I am still fighting how to get the correct results using the smfGetTagContent.
Using this =smfGetTagContent("http://getsplithistory.com/IBM","tr",0,"Split date","tr")
I get this returned in the cell
</tdead><tbody><tr class="2"><td>May 27, 1999</td><td class="bold"><span class="c-blue">2</span> : 1</td><td>116.00</td><td>236.25 <span class="f-11 c-light">(May 26)</span></td><td><span class="c-red">-1.80%</span></td><td class="a-right"><input type="text" class="calculation";></td>
What I really want is to create a table from this data using the fields shown in larger text and bold.
I have been fighting this for a few weeks and I guess I am just to inept to understand how to do it.
If you can show me how to do the first TR I hope I can do the rest.
I really appreciate any help you can provide.
Maybe, I am not putting forth enough effort but I have spent a lot of time on this.
I'll try the RCHGetHTMLTable(
Thanks, Kermit
From: smf_addin@yahoogrou
Sent: Friday, September 06, 2013 10:20 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Cannot figure out hw to use the smfgettagcontent function
What was wrong with the RCHGetHTMLTable(
On Fri, Sep 6, 2013 at 4:17 PM, Kermit W. Prather <kermitp@tampabay.
Randy, I am still fighting how to get the correct results using the smfGetTagContent.
Using this =smfGetTagContent(
I get this returned in the cell
</tdead>
What I really want is to create a table from this data using the fields shown in larger text and bold.
I have been fighting this for a few weeks and I guess I am just to inept to understand how to do it.
If you can show me how to do the first TR I hope I can do the rest.
I really appreciate any help you can provide.
Sat Sep 7, 2013 8:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Take a look at:
SMF-Example-GetSplitHistory.xls
...in the "Requested Samples" folder of the FILES area.
On Sat, Sep 7, 2013 at 7:48 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
>
> To be honest, I could not figure out how to make the RCHGetHTMLTable()
> solution work. ****
>
> ** **
>
> Maybe, I am not putting forth enough effort but I have spent a lot of time
> on this. ****
>
> ** **
>
> I'll try the RCHGetHTMLTable() solution again. But could use any guidance
> you have to offer. ****
>
> ** **
>
>
>
SMF-Example-
...in the "Requested Samples" folder of the FILES area.
On Sat, Sep 7, 2013 at 7:48 AM, Kermit W. Prather
<kermitp@tampabay.
>
> To be honest, I could not figure out how to make the RCHGetHTMLTable(
> solution work. ****
>
> ** **
>
> Maybe, I am not putting forth enough effort but I have spent a lot of time
> on this. ****
>
> ** **
>
> I'll try the RCHGetHTMLTable(
> you have to offer. ****
>
> ** **
>
>
>
Sat Sep 7, 2013 8:40 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
WOW! That is exactly what I wanted. I truly appreciate your doing that.
You did that in the time it took me to reprint the documentation for the RCHGetHTMLTable function.
I was just rereading it. I still have trouble defining the arrays.
THANK YOU SO MUCH,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, September 07, 2013 11:17 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Cannot figure out how to use the smfGetTagContent function
Take a look at:
SMF-Example-GetSplitHistory.xls
...in the "Requested Samples" folder of the FILES area.
On Sat, Sep 7, 2013 at 7:48 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
To be honest, I could not figure out how to make the RCHGetHTMLTable() solution work.
Maybe, I am not putting forth enough effort but I have spent a lot of time on this.
I'll try the RCHGetHTMLTable() solution again. But could use any guidance you have to offer.
You did that in the time it took me to reprint the documentation for the RCHGetHTMLTable function.
I was just rereading it. I still have trouble defining the arrays.
THANK YOU SO MUCH,
Kermit
From: smf_addin@yahoogrou
Sent: Saturday, September 07, 2013 11:17 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Cannot figure out how to use the smfGetTagContent function
Take a look at:
SMF-Example-
...in the "Requested Samples" folder of the FILES area.
On Sat, Sep 7, 2013 at 7:48 AM, Kermit W. Prather <kermitp@tampabay.
To be honest, I could not figure out how to make the RCHGetHTMLTable(
Maybe, I am not putting forth enough effort but I have spent a lot of time on this.
I'll try the RCHGetHTMLTable(
Sat Sep 7, 2013 7:34 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Hi Randy,
I friend of mine did up a spreadsheet with the smf addin, but has loaded the XLA file in the C: drive directly. He wants me to add the addin there. I don't know if his XLA file is different from yours or not.
If I load his XLA file in its required location, in addition to yours where it's supposed to be and have both activated, will your spreadsheets still work?
Thanks,
Jim
I friend of mine did up a spreadsheet with the smf addin, but has loaded the XLA file in the C: drive directly. He wants me to add the addin there. I don't know if his XLA file is different from yours or not.
If I load his XLA file in its required location, in addition to yours where it's supposed to be and have both activated, will your spreadsheets still work?
Thanks,
Jim
Sat Sep 7, 2013 8:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
EXCEL should just use the add-in listed first in the add-in manager, and
ignore the second.
So if you have workbooks that use the add-in in the second location, you
might end up with unresolved links that would need to be manually changed.
See the "Location Errors" item in the LINKS area of the group.
On Sat, Sep 7, 2013 at 7:34 PM, Jim Ranum <amt2100@gmail.com> wrote:
>
> I friend of mine did up a spreadsheet with the smf addin, but has loaded
> the XLA file in the C: drive directly. He wants me to add the addin there.
> I don't know if his XLA file is different from yours or not.****
>
> ** **
>
> If I load his XLA file in its required location, in addition to yours
> where it's supposed to be and have both activated, will your spreadsheets
> still work?****
>
>
>
ignore the second.
So if you have workbooks that use the add-in in the second location, you
might end up with unresolved links that would need to be manually changed.
See the "Location Errors" item in the LINKS area of the group.
On Sat, Sep 7, 2013 at 7:34 PM, Jim Ranum <amt2100@gmail.
>
> I friend of mine did up a spreadsheet with the smf addin, but has loaded
> the XLA file in the C: drive directly. He wants me to add the addin there.
> I don't know if his XLA file is different from yours or not.****
>
> ** **
>
> If I load his XLA file in its required location, in addition to yours
> where it's supposed to be and have both activated, will your spreadsheets
> still work?****
>
>
>
Sat Sep 7, 2013 9:09 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks Randy.
Hopefully the XLA file is the same.
I am still having this same previous problem I mentioned last week of whenever I shut down my computer and restart and open Excel, then open a spreadsheet with the SMF addin, it tries to point to the appdata/roaming/addins folder again. I have to keep updating the link againback to the Program Files folder. I don't understand why I seem to be the only person having this problem.
Any ideas would be appreciated.
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Saturday, September 07, 2013 11:53 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Question about multiple SMF addins loaded at the same time
EXCEL should just use the add-in listed first in the add-in manager, and ignore the second.
So if you have workbooks that use the add-in in the second location, you might end up with unresolved links that would need to be manually changed. See the "Location Errors" item in the LINKS area of the group.
On Sat, Sep 7, 2013 at 7:34 PM, Jim Ranum <amt2100@gmail.com> wrote:
I friend of mine did up a spreadsheet with the smf addin, but has loaded the XLA file in the C: drive directly. He wants me to add the addin there. I don't know if his XLA file is different from yours or not.
If I load his XLA file in its required location, in addition to yours where it's supposed to be and have both activated, will your spreadsheets still work?
Hopefully the XLA file is the same.
I am still having this same previous problem I mentioned last week of whenever I shut down my computer and restart and open Excel, then open a spreadsheet with the SMF addin, it tries to point to the appdata/roaming/
Any ideas would be appreciated.
Thanks,
Jim
From: smf_addin@yahoogrou
Sent: Saturday, September 07, 2013 11:53 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Question about multiple SMF addins loaded at the same time
EXCEL should just use the add-in listed first in the add-in manager, and ignore the second.
So if you have workbooks that use the add-in in the second location, you might end up with unresolved links that would need to be manually changed. See the "Location Errors" item in the LINKS area of the group.
On Sat, Sep 7, 2013 at 7:34 PM, Jim Ranum <amt2100@gmail.
I friend of mine did up a spreadsheet with the smf addin, but has loaded the XLA file in the C: drive directly. He wants me to add the addin there. I don't know if his XLA file is different from yours or not.
If I load his XLA file in its required location, in addition to yours where it's supposed to be and have both activated, will your spreadsheets still work?
Sat Sep 7, 2013 11:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I thought the "reset" process I gave you before worked? Otherwise, I'm out
of ideas...sorry.
On Sat, Sep 7, 2013 at 9:09 PM, Jim Ranum <amt2100@gmail.com> wrote:
>
> I am still having this same previous problem I mentioned last week of
> whenever I shut down my computer and restart and open Excel, then open a
> spreadsheet with the SMF addin, it tries to point to the
> appdata/roaming/addins folder again. I have to keep updating the link
> againback to the Program Files folder. I don't understand why I seem to be
> the only person having this problem.
>
>
>
of ideas...sorry.
On Sat, Sep 7, 2013 at 9:09 PM, Jim Ranum <amt2100@gmail.
>
> I am still having this same previous problem I mentioned last week of
> whenever I shut down my computer and restart and open Excel, then open a
> spreadsheet with the SMF addin, it tries to point to the
> appdata/roaming/
> againback to the Program Files folder. I don't understand why I seem to be
> the only person having this problem.
>
>
>
Tidak ada komentar:
Posting Komentar