15 Messages
Digest #3904
Messages
Mon Jan 30, 2017 6:11 am (PST) . Posted by:
"Donald McKinnon" dgmckin
Randy
I see you are posting and hope you are fully recovered. Take care of
yourself. We missed you.
Don McKinnon
I see you are posting and hope you are fully recovered. Take care of
yourself. We missed you.
Don McKinnon
Mon Jan 30, 2017 9:41 am (PST) . Posted by:
buckleca
Hi Randy,
I've been trying to grab the Monitor (HTML5) CSV file and don't see how to get this without clicking on the CSV tab. Not finding in the HTML code.
Just wondering if there's a method using your addin.
Thanks
I've been trying to grab the Monitor (HTML5) CSV file and don't see how to get this without clicking on the CSV tab. Not finding in the HTML code.
Just wondering if there's a method using your addin.
Thanks
Mon Jan 30, 2017 12:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It appears to stream the CSV data. Very strange. I've not seen that before.
But that means it's generated on the fly and not a "file" to be downloaded?
On Mon, Jan 30, 2017 at 10:41 AM, buckleca@
...wrote:
>
> I've been trying to grab the Monitor (HTML5) CSV file and don't see how to
> get this without clicking on the CSV tab. Not finding in the HTML code.
>
> Just wondering if there's a method using your addin.
>
>
But that means it's generated on the fly and not a "file" to be downloaded?
On Mon, Jan 30, 2017 at 10:41 AM, buckleca@
...wrote:
>
> I've been trying to grab the Monitor (HTML5) CSV file and don't see how to
> get this without clicking on the CSV tab. Not finding in the HTML code.
>
> Just wondering if there's a method using your addin.
>
>
Mon Jan 30, 2017 1:00 pm (PST) . Posted by:
buckleca
Thanks for looking.
I guess the other option is for me to write something that clicks the button and grabbed the file.
Otherwise would it be possible to grab the contents of monitor from the HTML code? I was trying to extract as a table, but not having any success.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :
It appears to stream the CSV data. Very strange. I've not seen that before. But that means it's generated on the fly and not a "file" to be downloaded?
On Mon, Jan 30, 2017 at 10:41 AM, buckleca@ ...wrote:
I've been trying to grab the Monitor (HTML5) CSV file and don't see how to get this without clicking on the CSV tab. Not finding in the HTML code.
Just wondering if there's a method using your addin.
I guess the other option is for me to write something that clicks the button and grabbed the file.
Otherwise would it be possible to grab the contents of monitor from the HTML code? I was trying to extract as a table, but not having any success.
---In smf_addin@yahoogroups.com, <rharmelink@
It appears to stream the CSV data. Very strange. I've not seen that before. But that means it's generated on the fly and not a "file" to be downloaded?
On Mon, Jan 30, 2017 at 10:41 AM, buckleca@ ...wrote:
I've been trying to grab the Monitor (HTML5) CSV file and don't see how to get this without clicking on the CSV tab. Not finding in the HTML code.
Just wondering if there's a method using your addin.
Mon Jan 30, 2017 1:05 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Since it is dynamically updating, the add-in won't be able to do much. The
add-in extracts data from the source code of the originally sent web page.
You'd need to write your own VBA routine that interacts with the HTML
object. Which you'd need to do anyway to click the button.
On Mon, Jan 30, 2017 at 2:00 PM, buckleca@
...wrote:
>
> I guess the other option is for me to write something that clicks the
> button and grabbed the file.
>
> Otherwise would it be possible to grab the contents of monitor from the
> HTML code? I was trying to extract as a table, but not having any success.
>
>
add-in extracts data from the source code of the originally sent web page.
You'd need to write your own VBA routine that interacts with the HTML
object. Which you'd need to do anyway to click the button.
On Mon, Jan 30, 2017 at 2:00 PM, buckleca@
...wrote:
>
> I guess the other option is for me to write something that clicks the
> button and grabbed the file.
>
> Otherwise would it be possible to grab the contents of monitor from the
> HTML code? I was trying to extract as a table, but not having any success.
>
>
Mon Jan 30, 2017 10:35 am (PST) . Posted by:
"Jose Jacob" pepecan47
Hello Randy, I am really glad that you are back home. Hoping for your prompt recovery.
I remember some people asking you if there is a way to give you something in return for your effort and dedication to the SMF. You mention that a good way would be to donate to a charity.
I would like to make a donation to a charity related to the illness you are having. Do you have any suggestion?
Regards,
Jose L. Jacob
I remember some people asking you if there is a way to give you something in return for your effort and dedication to the SMF. You mention that a good way would be to donate to a charity.
I would like to make a donation to a charity related to the illness you are having. Do you have any suggestion?
Regards,
Jose L. Jacob
Mon Jan 30, 2017 11:29 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Diabetes is that thing that's getting me the most these days. It affects
almost everything in the body.
On Mon, Jan 30, 2017 at 11:35 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:
> Hello Randy, I am really glad that you are back home. Hoping for your
> prompt recovery.
>
> I remember some people asking you if there is a way to give you something
> in return for your effort and dedication to the SMF. You mention that a
> good way would be to donate to a charity.
>
> I would like to make a donation to a charity related to the illness you
> are having. Do you have any suggestion?
>
> Regards,
> Jose L. Jacob
>
>
almost everything in the body.
On Mon, Jan 30, 2017 at 11:35 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:
> Hello Randy, I am really glad that you are back home. Hoping for your
> prompt recovery.
>
> I remember some people asking you if there is a way to give you something
> in return for your effort and dedication to the SMF. You mention that a
> good way would be to donate to a charity.
>
> I would like to make a donation to a charity related to the illness you
> are having. Do you have any suggestion?
>
> Regards,
> Jose L. Jacob
>
>
Mon Jan 30, 2017 11:44 am (PST) . Posted by:
"simona G" simona4051
Dear Randy, so sorry to hear about it. Hope that you are getting the best medical advice. I'm actually for the industry (Pharma) and there are some effective treatments almost regardless of the disease stage. Let me know if you would want to talk about it.
Simona
Sent from my iPhone
> On 30 Jan 2017, at 20:29, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Diabetes is that thing that's getting me the most these days. It affects almost everything in the body.
>
>> On Mon, Jan 30, 2017 at 11:35 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:
>> Hello Randy, I am really glad that you are back home. Hoping for your prompt recovery.
>>
>> I remember some people asking you if there is a way to give you something in return for your effort and dedication to the SMF. You mention that a good way would be to donate to a charity.
>>
>> I would like to make a donation to a charity related to the illness you are having. Do you have any suggestion?
>>
>> Regards,
>> Jose L. Jacob
>>
>
>
Simona
Sent from my iPhone
> On 30 Jan 2017, at 20:29, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Diabetes is that thing that's getting me the most these days. It affects almost everything in the body.
>
>> On Mon, Jan 30, 2017 at 11:35 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <smf_addin@yahoogroups.com> wrote:
>> Hello Randy, I am really glad that you are back home. Hoping for your prompt recovery.
>>
>> I remember some people asking you if there is a way to give you something in return for your effort and dedication to the SMF. You mention that a good way would be to donate to a charity.
>>
>> I would like to make a donation to a charity related to the illness you are having. Do you have any suggestion?
>>
>> Regards,
>> Jose L. Jacob
>>
>
>
Mon Jan 30, 2017 1:35 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I started a low calorie Keto diet while in the hospital. Which basically
means high protein at my body size. Still doing it now. Before the
hospital, I was taking 400 units of insulin a day and averaging a 160 BG
reading. I haven't used any insulin since I left rehab, and my BG has
varied from 93 to 117.
On Mon, Jan 30, 2017 at 12:51 PM, simona G simona4051@yahoo.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
>
> Dear Randy, so sorry to hear about it. Hope that you are getting the best
> medical advice. I'm actually for the industry (Pharma) and there are some
> effective treatments almost regardless of the disease stage. Let me know if
> you would want to talk about it.
> Simona
>
> Sent from my iPhone
>
> On 30 Jan 2017, at 20:29, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
>
> Diabetes is that thing that's getting me the most these days. It affects
> almost everything in the body.
>
>
means high protein at my body size. Still doing it now. Before the
hospital, I was taking 400 units of insulin a day and averaging a 160 BG
reading. I haven't used any insulin since I left rehab, and my BG has
varied from 93 to 117.
On Mon, Jan 30, 2017 at 12:51 PM, simona G simona4051@yahoo.com [smf_addin]
<smf_addin@yahoogroups.com> wrote:
>
>
> Dear Randy, so sorry to hear about it. Hope that you are getting the best
> medical advice. I'm actually for the industry (Pharma) and there are some
> effective treatments almost regardless of the disease stage. Let me know if
> you would want to talk about it.
> Simona
>
> Sent from my iPhone
>
> On 30 Jan 2017, at 20:29, Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
>
> Diabetes is that thing that's getting me the most these days. It affects
> almost everything in the body.
>
>
Mon Jan 30, 2017 11:39 am (PST) . Posted by:
rharmelink
GuruFocus has an add-in that allowed retrieval of some groups of data. They have now expanded it to have user-defined functions similar to the SMF add-in:
http://www.gurufocus.com/news/476372/new-feature-announcement-excel-userdefined-functions http://www.gurufocus.com/news/476372/new-feature-announcement-excel-userdefined-functions
For example:
=GURUF("AAPL","price")
http://www.gurufocus.com/news/476372/new-feature-announcement-excel-userdefined-functions http://www.gurufocus.com/news/476372/new-feature-announcement-excel-userdefined-functions
For example:
=GURUF("
Mon Jan 30, 2017 11:40 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I just took the easy route and had FireFox display the image all by itself.
Then I copied the URL of the image.
On Sun, Jan 29, 2017 at 2:42 PM, jhfrazer@
...wrote:
>
> My other question is the meaning and purpose of the "r=" value.
> Stockcharts did not give me that in theemail link? And when i inspect the
> element using firefox i come up with..
>
> <img class="chartimg buttons-present" id="chartImg"
> src="/c-sc/sc?s=AAPL&;p=D&yr=3&mn=0&dy=0&
> amp;i=p78116736167&r=1485725768284">
>
> Am i totally on the WRONG TRACK. Which would be very disappointing as I
> am really trying to learn more about web scraping in excel. I have been
> reading what I can, I even bought a book/booklet on web scraping in excel
> on amazon but it was not as enlightening as i had hoped. Guidance would be
> GREATLY appreciated.
>
>
Then I copied the URL of the image.
On Sun, Jan 29, 2017 at 2:42 PM, jhfrazer@
...wrote:
>
> My other question is the meaning and purpose of the "r=" value.
> Stockcharts did not give me that in theemail link? And when i inspect the
> element using firefox i come up with..
>
> <img class="
> src="/c-
> amp;i=p78116736167&
>
> Am i totally on the WRONG TRACK. Which would be very disappointing as I
> am really trying to learn more about web scraping in excel. I have been
> reading what I can, I even bought a book/booklet on web scraping in excel
> on amazon but it was not as enlightening as i had hoped. Guidance would be
> GREATLY appreciated.
>
>
Mon Jan 30, 2017 11:40 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The "1" is indeed what makes it stay visible all the time. The positioning
parameters only work if the comment is visible. They don't work for pop-ups.
On Sun, Jan 29, 2017 at 4:10 PM, jhfrazer@
...wrote:
>
> It looks like the last digit of the function you provided, the "1" tells
> the chart to be permanent. Is that correct? It seems to have cleared up
> the issue. As to positioning, the "top" and "left" variables in the
> function. if I understand correctly an entry on 100 for "top" should shift
> the top of the chart up to 100 pixels above the top of the cell. Is that
> correct? If so I wonder why that is not working for me? any thoughts?
>
parameters only work if the comment is visible. They don't work for pop-ups.
On Sun, Jan 29, 2017 at 4:10 PM, jhfrazer@
...wrote:
>
> It looks like the last digit of the function you provided, the "1" tells
> the chart to be permanent. Is that correct? It seems to have cleared up
> the issue. As to positioning, the "top" and "left" variables in the
> function. if I understand correctly an entry on 100 for "top" should shift
> the top of the chart up to 100 pixels above the top of the cell. Is that
> correct? If so I wonder why that is not working for me? any thoughts?
>
Mon Jan 30, 2017 1:01 pm (PST) . Posted by:
carroll_g
I have been using the options tracker to input and track my put options. I have entered two(2) tickers that I get errors in the put tab and on the summary tab. The cells on the tabs show (NAME and VALUE) through out the program. Can some one explain to me how to correct this problem? Tickers (ATVI, LULU)
Mon Jan 30, 2017 1:13 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
No idea what "options tracker" is...
#NAME? usually means the function is not defined (i.e. no add-in?). #VALUE?
would then cascade from there...?
On Mon, Jan 30, 2017 at 1:29 PM, carroll_g@
...wrote:
> I have been using the options tracker to input and track my put options. I
> have entered two(2) tickers that I get errors in the put tab and on the
> summary tab. The cells on the tabs show (NAME and VALUE) through out the
> program. Can some one explain to me how to correct this problem? Tickers
> (ATVI, LULU)
>
>
#NAME? usually means the function is not defined (i.e. no add-in?). #VALUE?
would then cascade from there...?
On Mon, Jan 30, 2017 at 1:29 PM, carroll_g@
...wrote:
> I have been using the options tracker to input and track my put options. I
> have entered two(2) tickers that I get errors in the put tab and on the
> summary tab. The cells on the tabs show (NAME and VALUE) through out the
> program. Can some one explain to me how to correct this problem? Tickers
> (ATVI, LULU)
>
>
Mon Jan 30, 2017 1:24 pm (PST) . Posted by:
gbullr
RchGetHTML Table error
Not getting anything back and this used to work great.
thoughts?
=rchgethtmltable("http://www. investing.com/rates-bonds/ world-government-bonds http://www.investing.com/rates-bonds/world-government-bonds",E2)
E2 = "Switzerland 1Y" w/o the quotes
Thank you
Not getting anything back and this used to work great.
thoughts?
=rchgethtmltable("http://www. investing.com/rates-bonds/ world-government-bonds http://www.investing.com/rates-bonds/world-government-bonds",E2)
E2 = "Switzerland 1Y" w/o the quotes
Thank you
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar