Sabtu, 07 Februari 2015

[smf_addin] Digest Number 3315

10 Messages

Digest #3315
1b
Re: Looking for RCH_Stock_Market_Functions.xla by "Randy Harmelink" rharmelink
3
Dividend Explorer workbook by bobsledproductions
4a
Pull in Chart Data by zacharycal
4b
Re: Pull in Chart Data by "Randy Harmelink" rharmelink
4c
5
Re: Digest Number 3314 by "Christopher Chang Sue" cchangsue
6
7
52 week high/low by "Christopher Chang Sue" cchangsue

Messages

Fri Feb 6, 2015 7:50 am (PST) . Posted by:

bselvaradjou@att.net

Can someone tell me how to download the library file "RCH_Stock_Market_Functions.xla"?


Fri Feb 6, 2015 7:55 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's in one of the ZIP archives of the add-in and its related files on the
SMF add-in web site.

You may need all of the files in the ZIP if you are updating to a new
version of the add-in.

On Fri, Feb 6, 2015 at 8:38 AM, barathi7@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Can someone tell me how to download the library file
> "RCH_Stock_Market_Functions.xla"?
>

Fri Feb 6, 2015 7:54 am (PST) . Posted by:

rharmelink

Thanks for the heads up.

I just uploaded a new smf-elements-9.txt to the SMF add-in web site to correct the element definitions.


They changed the structure of the web page and are now stacking the data as two separate tables instead of displaying the data adjacent to each other in a single table.


On Fri, Feb 6, 2015 at 7:26 AM, Dave Brown <dave.trader7@... mailto:dave.trader7@gmail.com> wrote:
Hi Randy! Is there a quick way I can verify if a site has "suspended&quot; access to various data elements. For some reason Barchart still allows access to most of its elements, but has been returning errors for several days now on existing code using RCHGetElementNumber() on the Percent of Stocks Above Moving Average items ~(1195 through 1214). Has this changed? If so, is there a different method I should use to access the info? Thank you!! --Dave







Fri Feb 6, 2015 8:36 am (PST) . Posted by:

bobsledproductions

Just finished creating a dividend explorer workbook that you can access / download from here.


http://toteboard.net/blog/workbooks/dividend-explorer/ http://toteboard.net/blog/workbooks/dividend-explorer/





Fri Feb 6, 2015 2:44 pm (PST) . Posted by:

zacharycal

Hey Randy,


Quick question, is there a function where I can pull in the data from a chart? I am trying to pull in the dates and values for the chart here:


http://www.tradingeconomics.com/euro-area/unemployment-rate http://www.tradingeconomics.com/euro-area/unemployment-rate



I want to compare data from the past 12 months.


Thanks!

Zach

Fri Feb 6, 2015 4:08 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Nope, sorry. I don't have a way to extract data from an image.

On Fri, Feb 6, 2015 at 3:44 PM, zabrams@... wrote:

>
> Quick question, is there a function where I can pull in the data from a
> chart? I am trying to pull in the dates and values for the chart here:
>
> http://www.tradingeconomics.com/euro-area/unemployment-rate
>
> I want to compare data from the past 12 months.
>
>

Fri Feb 6, 2015 5:04 pm (PST) . Posted by:

"Christopher Chang Sue" cchangsue

Hi Randy,
I am trying to pull the 52 Week High and 52 Week Low from this page.

http://web.tmxmoney.com/quote.php?qm_symbol=XVX
Any idea what formula I should use?
Thanks,

On Friday, February 6, 2015 6:08 AM, "smf_addin@yahoogroups.com" <smf_addin@yahoogroups.com> wrote:


<!--#yiv8911745149 #yiv8911745149ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8911745149 #yiv8911745149ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8911745149 #yiv8911745149ygrp-mkp #yiv8911745149hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8911745149 #yiv8911745149ygrp-mkp #yiv8911745149ads {margin-bottom:10px;}#yiv8911745149 #yiv8911745149ygrp-mkp .yiv8911745149ad {padding:0 0;}#yiv8911745149 #yiv8911745149ygrp-mkp .yiv8911745149ad p {margin:0;}#yiv8911745149 #yiv8911745149ygrp-mkp .yiv8911745149ad a {color:#0000ff;text-decoration:none;}#yiv8911745149 #yiv8911745149ygrp-sponsor #yiv8911745149ygrp-lc {font-family:Arial;}#yiv8911745149 #yiv8911745149ygrp-sponsor #yiv8911745149ygrp-lc #yiv8911745149hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8911745149 #yiv8911745149ygrp-sponsor #yiv8911745149ygrp-lc .yiv8911745149ad {margin-bottom:10px;padding:0 0;}--> EXCEL Stock Market Functions Add-in EXCEL Stock Market Functions Add-in Group
3 Messages
Digest #3314 1a Re: Cell is emapty when pulling data from Gurufocus. by "malli Boggala" malli.boggala 2.1 New file uploaded to smf_addin by 3a Re: Gurufocus Non US Listed Stocks by hamishthedenizen
Messages

1a

Re: Cell is emapty when pulling data from Gurufocus.

Thu Feb 5, 2015 9:07 am (PST) . Posted by:

"malli Boggala" malli.boggala
Thanks a lot, It's working fine.
Regards,Malli B

On Monday, February 2, 2015 4:47 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  That's because you're using a bad search string. The function will key off the first occurrence of that string it finds. In the case of "PFCF", there are nearly a dozen before that table entry, because it's used as part of HTML tag processing. That's why I usually use the ">" trick, but it can ONLY be used if the web page is written that way. It may be necessary to look at the source code of the web page to come up with good search strings. For example, this works:

=RCHGetTableCell("http://www.gurufocus.com/stock/"&B4,1,">PFCF")

Have you looked that the GuruFocus model/template that another add-in user has uploaded to the "Uploads by Forum Members" folder of the FILES area of the Yahoo group? You could save yourself a lot of work...

On Mon, Feb 2, 2015 at 12:42 PM, malli Boggala malli.boggala@...wrote:

I'm trying to access data form Gurufocus using below formula, bust cell is empty, not pulling any data. RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&"",1,"PFCF")
But seems some other data working fine like RCHGetTableCell("http://www.gurufocus.com/stock/"&A5&" ",1, "ROIC" )
would you pls. help me.Thanks in advance.

#yiv9508619048 #yiv9508619048 -- #yiv9508619048ygrp- mkp {border:1px solid #d8d8d8;font- family:Arial; margin:10px 0;padding:0 10px;}#yiv950861904 8 #yiv9508619048ygrp- mkp hr {border:1px solid #d8d8d8;}#yiv950861 9048 #yiv9508619048ygrp- mkp #yiv9508619048hd {color:#628c2a; font-size: 85%;font- weight:700; line-height: 122%;margin: 10px 0;}#yiv9508619048 #yiv9508619048ygrp- mkp #yiv9508619048ads {margin-bottom: 10px;}#yiv950861 9048 #yiv9508619048ygrp- mkp .yiv9508619048ad {padding:0 0;}#yiv9508619048 #yiv9508619048ygrp- mkp .yiv9508619048ad p {margin:0;}# yiv9508619048 #yiv9508619048ygrp- mkp .yiv9508619048ad a {color:#0000ff; text-decoration: none;}#yiv950861 9048 #yiv9508619048ygrp- sponsor #yiv9508619048ygrp- lc {font-family: Arial;}#yiv95086 19048 #yiv9508619048ygrp- sponsor #yiv9508619048ygrp- lc #yiv9508619048hd {margin:10px 0px;font-weight: 700;font- size:78%; line-height: 122%;}#yiv950861 9048 #yiv9508619048ygrp- sponsor #yiv9508619048ygrp- lc .yiv9508619048ad {margin-bottom: 10px;padding: 0 0;}#yiv9508619048 #yiv9508619048actio ns {font-family: Verdana;font- size:11px; padding:10px 0;}#yiv9508619048 #yiv9508619048activ ity {background- color:#e0ecee; float:left; font-family: Verdana;font- size:10px; padding:10px; }#yiv9508619048 #yiv9508619048activ ity span {font-weight: 700;}#yiv9508619 048 #yiv9508619048activ ity span:first-child {text-transform: uppercase; }#yiv9508619048 #yiv9508619048activ ity span a {color:#5085b6; text-decoration: none;}#yiv950861 9048 #yiv9508619048activ ity span span {color:#ff7900; }#yiv9508619048 #yiv9508619048activ ity span .yiv9508619048under line {text-decoration: underline; }#yiv9508619048 .yiv9508619048attac h {clear:both; display:table; font-family: Arial;font- size:12px; padding:10px 0;width:400px; }#yiv9508619048 .yiv9508619048attac h div a {text-decoration: none;}#yiv950861 9048 .yiv9508619048attac h img {border:none; padding-right: 5px;}#yiv9508619 048 .yiv9508619048attac h label {display:block; margin-bottom: 5px;}#yiv9508619 048 .yiv9508619048attac h label a {text-decoration: none;}#yiv950861 9048 blockquote {margin:0 0 0 4px;}#yiv9508619048 .yiv9508619048bold {font-family: Arial;font- size:13px; font-weight: 700;}#yiv9508619 048 .yiv9508619048bold a {text-decoration: none;}#yiv950861 9048 dd.yiv9508619048las t p a {font-family: Verdana;font- weight:700; }#yiv9508619048 dd.yiv9508619048las t p span {margin-right: 10px;font- family:Verdana; font-weight: 700;}#yiv9508619 048 dd.yiv9508619048las t p span.yiv9508619048y shortcuts {margin-right: 0;}#yiv950861904 8 div.yiv9508619048at tach-table div div a {text-decoration: none;}#yiv950861 9048 div.yiv9508619048at tach-table {width:400px; }#yiv9508619048 div.yiv9508619048fi le-title a, #yiv9508619048 div.yiv9508619048fi le-title a:active, #yiv9508619048 div.yiv9508619048fi le-title a:hover, #yiv9508619048 div.yiv9508619048fi le-title a:visited {text-decoration: none;}#yiv950861 9048 div.yiv9508619048ph oto-title a, #yiv9508619048 div.yiv9508619048ph oto-title a:active, #yiv9508619048 div.yiv9508619048ph oto-title a:hover, #yiv9508619048 div.yiv9508619048ph oto-title a:visited {text-decoration: none;}#yiv950861 9048 div#yiv9508619048yg rp-mlmsg #yiv9508619048ygrp- msg p a span.yiv9508619048y shortcuts {font-family: Verdana;font- size:10px; font-weight: normal;}# yiv9508619048 .yiv9508619048green {color:#628c2a; }#yiv9508619048 .yiv9508619048MsoNo rmal {margin:0 0 0 0;}#yiv9508619048 o {font-size:0; }#yiv9508619048 #yiv9508619048photo s div {float:left; width:72px; }#yiv9508619048 #yiv9508619048photo s div div {border:1px solid #666666;height: 62px;overflow: hidden;width: 62px;}#yiv950861 9048 #yiv9508619048photo s div label {color:#666666; font-size: 10px;overflow: hidden;text- align:center; white-space: nowrap;width: 64px;}#yiv950861 9048 #yiv9508619048reco- category {font-size:77% ;}#yiv9508619048 #yiv9508619048reco- desc {font-size:77% ;}#yiv9508619048 .yiv9508619048replb q {margin:4px; }#yiv9508619048 #yiv9508619048ygrp- actbar div a:first-child {margin-right: 2px;padding- right:5px; }#yiv9508619048 #yiv9508619048ygrp- mlmsg {font-size:13px; font-family: Arial, helvetica, clean, sans-serif;} #yiv9508619048 #yiv9508619048ygrp- mlmsg table {font-size:inherit; font:100% ;}#yiv9508619048 #yiv9508619048ygrp- mlmsg select, #yiv9508619048 input, #yiv9508619048 textarea {font:99% Arial, Helvetica, clean, sans-serif;} #yiv9508619048 #yiv9508619048ygrp- mlmsg pre, #yiv9508619048 code {font:115% monospace;}# yiv9508619048 #yiv9508619048ygrp- mlmsg * {line-height: 1.22em;}# yiv9508619048 #yiv9508619048ygrp- mlmsg #yiv9508619048logo {padding-bottom: 10px;}#yiv950861 9048 #yiv9508619048ygrp- msg p a {font-family: Verdana;} #yiv9508619048 #yiv9508619048ygrp- msg p#yiv9508619048atta ch-count span {color:#1E66AE; font-weight: 700;}#yiv9508619 048 #yiv9508619048ygrp- reco #yiv9508619048reco- head {color:#ff7900; font-weight: 700;}#yiv9508619 048 #yiv9508619048ygrp- reco {margin-bottom: 20px;padding: 0px;}#yiv9508619 048 #yiv9508619048ygrp- sponsor #yiv9508619048ov li a {font-size:130% ;text-decoration :none;}#yiv95086 19048 #yiv9508619048ygrp- sponsor #yiv9508619048ov li {font-size:77% ;list-style- type:square; padding:6px 0;}#yiv9508619048 #yiv9508619048ygrp- sponsor #yiv9508619048ov ul {margin:0;padding: 0 0 0 8px;}#yiv9508619048 #yiv9508619048ygrp- text {font-family: Georgia;} #yiv9508619048 #yiv9508619048ygrp- text p {margin:0 0 1em 0;}#yiv9508619048 #yiv9508619048ygrp- text tt {font-size:120% ;}#yiv9508619048 #yiv9508619048ygrp- vital ul li:last-child {border-right: none !important;} #yiv9508619048

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

New file uploaded to smf_addin

Thu Feb 5, 2015 9:13 am (PST) . Posted by:



Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/10 year model - GuruFocus - All Types (2003).xls
Uploaded by : hamishthedenizen <dan-carroll@yahoo.com>
Description : 10 Year financial data from GuruFocus, saved for Excel 2003. Please check for errors

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/10%20year%20model%20-%20GuruFocus%20-%20All%20Types%20%282003%29.xls

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

hamishthedenizen <dan-carroll@yahoo.com>

Reply to sender . Reply to group . Reply via Web Post . All Messages (71) . Top ^
3a

Re: Gurufocus Non US Listed Stocks

Thu Feb 5, 2015 9:18 am (PST) . Posted by:

hamishthedenizen
I included Randy's fix at the bottom of the updated GuruFocus model (2003) Reply to sender . Reply to group . Reply via Web Post . All Messages (11) . Top ^ For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 24
• Privacy • Unsubscribe • Terms of Use

Fri Feb 6, 2015 5:40 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfConvertData(smfStrExtr(smfGetTagContent("
http://web.tmxmoney.com/quote.php?qm_symbol=XVX","div",-1,"52 week
low"),"/strong>","~"))

=smfConvertData(smfStrExtr(smfGetTagContent("
http://web.tmxmoney.com/quote.php?qm_symbol=XVX","div",-1,"52 week
high"),"/strong>","~"))

PS: In the future, please start a new topic on the group rather than
replying to a digest. Thanks.

On Fri, Feb 6, 2015 at 6:04 PM, Christopher Chang Sue cchangsue@... wrote:

>
> I am trying to pull the 52 Week High and 52 Week Low from this page.
>
> http://web.tmxmoney.com/quote.php?qm_symbol=XVX
>
> Any idea what formula I should use?
>

Fri Feb 6, 2015 6:47 pm (PST) . Posted by:

"Christopher Chang Sue" cchangsue

  Hi Randy,
I am trying to pull the 52 Week High and 52 Week Low from this page.

http://web.tmxmoney.com/quote.php?qm_symbol=XVX
Any idea what formula I should use?
Thanks,
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar