15 Messages
Digest #4335
Messages
Sat Jun 2, 2018 10:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Neither attachment came through...
On Sat, Jun 2, 2018 at 10:14 AM, brad.reel@
...
wrote:
> Hi Randy. I'm afraid I'm stumped and not really sure if you can help or
> not. I have a tool I subscribe to called TradeStops. I'd like to be able
> to pull a value off of the webpage for a given ticker, but cannot even
> begin to figure out how to locate it on the page. The value I want is the
> SSI Yellow Zone price.
>
>
> Obviously, since this is all behind a login, you won't be able to get to
> it. I've attached a screen shot of an example ticker and the page source
> code. Not sure if that will help you or not. The value I am trying to get
> in this example is the 5.49.
>
>
> I assume I need to use either SMFGetTagContent or RCHGetTableCell, but not
> even certain there's not a better way. Any assistance you can provide
> would be greatly appreciated. However, please don't spend too long on it,
> don't want to waste your time.
>
>
> Thanks!
>
> BR
>
>
>
>
> Attachment(s) from brad.reel@yahoo.com [smf_addin] | View attachments on
> the web
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/2059634019;_ylc=X3oDMTJyOTg1Zm41BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDdmlld09uV2ViBHN0aW1lAzE1Mjc5NTk2NjI->
>
> 1 of 1 Photo(s)
> [image: 2018-06-02.png]
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/2059634019;_ylc=X3oDMTJuMnNoYTc3BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTUyNzk1OTY2Mg--?itemid=1524261954>
> 2018-06-02.png
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/2059634019;_ylc=X3oDMTJuMnNoYTc3BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTUyNzk1OTY2Mg--?itemid=1524261954>
>
> 1 of 1 File(s)
> view-source_https___cbe.tradestops.com_position-card_12182710_tab=6.html
> <https://xa.yimg.com/kq/groups/18094620/1030533704/name/view-source_https___cbe%2Etradestops%2Ecom_position-card_12182710_tab%3D>
>
On Sat, Jun 2, 2018 at 10:14 AM, brad.reel@
...
wrote:
> Hi Randy. I'm afraid I'm stumped and not really sure if you can help or
> not. I have a tool I subscribe to called TradeStops. I'd like to be able
> to pull a value off of the webpage for a given ticker, but cannot even
> begin to figure out how to locate it on the page. The value I want is the
> SSI Yellow Zone price.
>
>
> Obviously, since this is all behind a login, you won't be able to get to
> it. I've attached a screen shot of an example ticker and the page source
> code. Not sure if that will help you or not. The value I am trying to get
> in this example is the 5.49.
>
>
> I assume I need to use either SMFGetTagContent or RCHGetTableCell, but not
> even certain there's not a better way. Any assistance you can provide
> would be greatly appreciated. However, please don't spend too long on it,
> don't want to waste your time.
>
>
> Thanks!
>
> BR
>
>
>
>
> Attachment(s) from brad.reel@yahoo.com [smf_addin] | View attachments on
> the web
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/2059634019;_ylc=X3oDMTJyOTg1Zm41BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDdmlld09uV2ViBHN0aW1lAzE1Mjc5NTk2NjI->
>
> 1 of 1 Photo(s)
> [image: 2018-06-02.png]
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/2059634019;_ylc=X3oDMTJuMnNoYTc3BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTUyNzk1OTY2Mg--?itemid=1524261954>
> 2018-06-02.png
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/2059634019;_ylc=X3oDMTJuMnNoYTc3BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTUyNzk1OTY2Mg--?itemid=1524261954>
>
> 1 of 1 File(s)
> view-source_https___cbe.tradestops.com_position-card_12182710_tab=6.html
> <https://xa.yimg.com/kq/groups/18094620/1030533704/name/view-source_https___cbe%2Etradestops%2Ecom_position-card_12182710_tab%3D>
>
Sat Jun 2, 2018 10:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There are elements defined that pull them from Yahoo's Key Statistics web
page:
=RCHGetElementNumber("MMM";,13865)
=RCHGetElementNumber("MMM";,13867)
On Sat, Jun 2, 2018 at 10:01 AM, tdyboc@
...
wrote:
>
> Anyone comment on where I might obtain data for both sector and industry?
> I used to use RCHGetTableCell pointing to finance.yahoo.com.
>
>
>
page:
=RCHGetElementNumbe
=RCHGetElementNumbe
On Sat, Jun 2, 2018 at 10:01 AM, tdyboc@
...
wrote:
>
> Anyone comment on where I might obtain data for both sector and industry?
> I used to use RCHGetTableCell pointing to finance.yahoo.
>
>
>
Mon Jun 4, 2018 6:47 am (PDT) . Posted by:
tzewei_79
Hi,
I'm trying to extract the "Years Paying" with the same command to extract "Dividend Yield" bt I got an error. I tried to understand the document on smfGetTagContent function but there's no explanation on how to interpret span,1 and what does the ,,,,1 ,,2 means.
Can someone help to explain how I can troubleshoot this so that I can do it in future for other extractions on dividata?
=smfGetTagContent("http://dividata.com/stock/"&A4,"span",1,">Years Paying",,,,1,,2)
I'm trying to extract the "Years Paying" with the same command to extract "Dividend Yield" bt I got an error. I tried to understand the document on smfGetTagContent function but there's no explanation on how to interpret span,1 and what does the ,,,,1 ,,2 means.
Can someone help to explain how I can troubleshoot this so that I can do it in future for other extractions on dividata?
=smfGetTagContent("http://dividata.com/stock/"&A4,"
Mon Jun 4, 2018 10:31 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("https://dividata.com/stock/PNR","span",1,">Years
Paying",,,,1)
That says to:
1. Retrieve the source code of web page "https://dividata.com/stock/PNR"
2. Search for the string ">Years Paying" within that source code
3. After finding that string, look for the 1st "span" tag following it, and
extract the string within that span tag.
4. The final "1" parameter tells the add-in to convert that string into a
numeric value, if possible
This is the relevant section of the source code within the web page:
....ividend.">Years Paying</abbr><span class="nobadge bigstat">30</span
></l...
On Mon, Jun 4, 2018 at 6:45 AM, tzewei_79@... wrote:
>
> I'm trying to extract the "Years Paying" with the same command to extract "Dividend
> Yield" bt I got an error. I tried to understand the document on
> smfGetTagContent function but there's no explanation on how to interpret
> span,1 and what does the ,,,,1 ,,2 means.
>
> Can someone help to explain how I can troubleshoot this so that I can do
> it in future for other extractions on dividata?
>
> =smfGetTagContent("http://dividata.com/stock/"&A4,"span",1,">Years
> Paying",,,,1,,2)
>
>
>
=smfGetTagContent("https://dividata.com/stock/PNR","span",1,">Years
Paying",,,,1)
That says to:
1. Retrieve the source code of web page "https://dividata.com/stock/PNR"
2. Search for the string ">Years Paying" within that source code
3. After finding that string, look for the 1st "span" tag following it, and
extract the string within that span tag.
4. The final "1" parameter tells the add-in to convert that string into a
numeric value, if possible
This is the relevant section of the source code within the web page:
....ividend.">Years Paying</abbr><span class="nobadge bigstat">30</span
></l...
On Mon, Jun 4, 2018 at 6:45 AM, tzewei_79@... wrote:
>
> I'm trying to extract the "Years Paying" with the same command to extract "Dividend
> Yield" bt I got an error. I tried to understand the document on
> smfGetTagContent function but there's no explanation on how to interpret
> span,1 and what does the ,,,,1 ,,2 means.
>
> Can someone help to explain how I can troubleshoot this so that I can do
> it in future for other extractions on dividata?
>
> =smfGetTagContent("http://dividata.com/stock/"&A4,"
> Paying"
>
>
>
Mon Jun 4, 2018 7:08 am (PDT) . Posted by:
tzewei_79
Just realised they changed to https, but =RCHGetTableCell("https://dividata.com/stock/"&A3,1,"Years Paying:") did not work now. A3 is the ticker symbol PNR.
I also tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,"Dividend") , and it showed 0.70 which matches what was displayed on the website https://dividata.com/stock/PNR https://dividata.com/stock/PNR.
In the element, there is only 1 element that has the value 0.7 and the title is actually "52 Week Dividend".
When I tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,"52 Week Dividend"), it gave me an error.. I'm very confused on how to extract the data on dividata .
I also wanted to extract the following items.
1. Years Paying Dividend
2. Over Rating
3. Dividend Yield Rating
4. Dividend History Rating
Can someone please guide me?
I also tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,"Dividend") , and it showed 0.70 which matches what was displayed on the website https://dividata.com/stock/PNR https://dividata.com/stock/PNR.
In the element, there is only 1 element that has the value 0.7 and the title is actually "52 Week Dividend".
When I tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,
I also wanted to extract the following items.
1. Years Paying Dividend
2. Over Rating
3. Dividend Yield Rating
4. Dividend History Rating
Can someone please guide me?
Mon Jun 4, 2018 10:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("https://dividata.com/stock/PNR","span",1,">Years
Paying",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Overall
Rating:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
Yield:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1)
On Mon, Jun 4, 2018 at 7:08 AM, tzewei_79@
...
wrote:
>
> Just realised they changed to https, but =RCHGetTableCell("https://
> dividata.com/stock/"&A3,1,"Years Paying:") did not work now. A3 is the
> ticker symbol PNR.
>
> I also tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,"Dividend")
> , and it showed 0.70 which matches what was displayed on the website
> https://dividata.com/stock/PNR.
>
> In the element, there is only 1 element that has the value 0.7 and the
> title is actually "52 Week Dividend".
> When I tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,"52
> Week Dividend"), it gave me an error. I'm very confused on how to extract
> the data on dividata .
>
> I also wanted to extract the following items.
> 1. Years Paying Dividend
> 2. Over Rating
> 3. Dividend Yield Rating
> 4. Dividend History Rating
>
> Can someone please guide me?
>
>
=smfGetTagContent("https://dividata.com/stock/PNR","span",1,">Years
Paying",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Overall
Rating:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
Yield:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1)
On Mon, Jun 4, 2018 at 7:08 AM, tzewei_79@
...
wrote:
>
> Just realised they changed to https, but =RCHGetTableCell("https://
> dividata.com/stock/"&A3,1,"Years Paying:") did not work now. A3 is the
> ticker symbol PNR.
>
> I also tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,"Dividend")
> , and it showed 0.70 which matches what was displayed on the website
> https://dividata.com/stock/PNR.
>
> In the element, there is only 1 element that has the value 0.7 and the
> title is actually "52 Week Dividend".
> When I tried =RCHGetTableCell("https://www.finviz.com/quote.ashx?t="&A3,1,
> Week Dividend"
> the data on dividata .
>
> I also wanted to extract the following items.
> 1. Years Paying Dividend
> 2. Over Rating
> 3. Dividend Yield Rating
> 4. Dividend History Rating
>
> Can someone please guide me?
>
>
Mon Jun 4, 2018 8:14 am (PDT) . Posted by:
tzewei_79
Reference to https://dividata.com/stock/PNR https://dividata.com/stock/PNR
Is it possible to extract the following items?
1. The "Excellent (5)" text String of Overall Ratings
2. The "Excellent (5)" text String of Dividend Yield
3. The "Excellent (5)" text String of Dividend History
Is it possible to extract the following items?
1. The "Excellent (5)" text String of Overall Ratings
2. The "Excellent (5)" text String of Dividend Yield
3. The "Excellent (5)" text String of Dividend History
Mon Jun 4, 2018 10:37 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Overall
Rating:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
Yield:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1)
If you want just the numeric rating, just extract what's between the
parenthesese:
=smfStrExtr(smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1),"(",")",1)
Or, to pull just the verbal portion:
=smfStrExtr(smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1),"~"," (")
On Mon, Jun 4, 2018 at 8:14 AM, tzewei_79@
...
wrote:
> Reference to https://dividata.com/stock/PNR
>
> Is it possible to extract the following items?
>
> 1. The "Excellent (5)" text String of Overall Ratings
>
> 2. The "Excellent (5)" text String of Dividend Yield
>
> 3. The "Excellent (5)" text String of Dividend History
>
>
>
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Overall
Rating:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
Yield:",,,,1)
=smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1)
If you want just the numeric rating, just extract what's between the
parenthesese:
=smfStrExtr(smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1),"(",")",1)
Or, to pull just the verbal portion:
=smfStrExtr(smfGetTagContent("https://dividata.com/stock/PNR","div",1,"Dividend
History:",,,,1),"~"," (")
On Mon, Jun 4, 2018 at 8:14 AM, tzewei_79@
...
wrote:
> Reference to https://dividata.com/stock/PNR
>
> Is it possible to extract the following items?
>
> 1. The "Excellent (5)" text String of Overall Ratings
>
> 2. The "Excellent (5)" text String of Dividend Yield
>
> 3. The "Excellent (5)" text String of Dividend History
>
>
>
Mon Jun 4, 2018 12:09 pm (PDT) . Posted by:
sdavidson@miradorllc.com
Curious as to how up to date the list of securities is? Also curious about the DTN IQ database.
Mon Jun 4, 2018 9:40 pm (PDT) . Posted by:
lawleesh
Hi Randy
May I know why these two formulas don't work with this page?
http://www.4-traders.com/COMCAST-CORPORATION-4864/financials/ http://www.4-traders.com/COMCAST-CORPORATION-4864/financials/
thanks
May I know why these two formulas don't work with this page?
http://www.4-traders.com/COMCAST-CORPORATION-4864/financials/ http://www.4-traders.com/COMCAST-CORPORATION-4864/financials/
thanks
Mon Jun 4, 2018 10:07 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Which two formulas?
On Mon, Jun 4, 2018 at 9:39 PM, lawrence.leesh@
...
wrote:
>
> May I know why these two formulas don't work with this page?
>
> http://www.4-traders.com/COMCAST-CORPORATION-4864/financials/
>
>
>
On Mon, Jun 4, 2018 at 9:39 PM, lawrence.leesh@
...
wrote:
>
> May I know why these two formulas don't work with this page?
>
> http://www.4-traders.com/COMCAST-CORPORATION-4864/financials/
>
>
>
Tue Jun 5, 2018 12:14 am (PDT) . Posted by:
lawleesh
=smfGetTagContent("http://www.4-traders.com/THK-CO-LTD-6491755/financials/ http://www.4-traders.com/THK-CO-LTD-6491755/financials/","td",-1,"Fiscal Period",,,,1)
=smfGetTagContent("http://www.4-traders.com/THK-CO-LTD-6491755/financials/ http://www.4-traders.com/THK-CO-LTD-6491755/financials/","b",1,"Fiscal Period")
=smfGetTagContent("http://www.4-traders.com/THK-CO-LTD-6491755/financials/ http://www.4-traders.com/THK-CO-LTD-6491755/financials/","
Tue Jun 5, 2018 12:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
For me, accessing the web page via EXCEL returns this message:
* Acces Denied.Please contact us (+33)478304142*
I tried the URL in the IE browser and did a ctrl+F5 to refresh the web page
completely (without using any cached items). When I went back into EXCEL
and ran the smfForceRecalculation macro to grab a fresh copy of the web
page, it worked...
Go figure? :(
On Tue, Jun 5, 2018 at 12:14 AM, lawrence.leesh@
...
wrote:
>
> =smfGetTagContent("http://www.4-traders.com/THK-CO-LTD-6491755/financials/
> ","td",-1,"Fiscal Period",,,,1)
> =smfGetTagContent("http://www.4-traders.com/THK-CO-LTD-6491755/financials/
> ","b",1,"Fiscal Period")
>
>
* Acces Denied.Please contact us (+33)478304142*
I tried the URL in the IE browser and did a ctrl+F5 to refresh the web page
completely (without using any cached items). When I went back into EXCEL
and ran the smfForceRecalculation macro to grab a fresh copy of the web
page, it worked...
Go figure? :(
On Tue, Jun 5, 2018 at 12:14 AM, lawrence.leesh@
...
wrote:
>
> =smfGetTagContent("http://www.4-traders.com/THK-CO-LTD-6491755/financials/
> ","td",-1,"Fiscal Period",,,,1)
> =smfGetTagContent("http://www.4-traders.com/THK-CO-LTD-6491755/financials/
> ","
>
>
Tue Jun 5, 2018 1:11 am (PDT) . Posted by:
lawleesh
Thanks Randy.
I tried again in Excel and this time it works. Don't know why. Maybe some problems with their server at that time.
I tried again in Excel and this time it works. Don't know why. Maybe some problems with their server at that time.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar