Senin, 05 September 2016

[smf_addin] Digest Number 3790[2 Attachments]

6 Messages

Digest #3790
1a
Re: Not working: smfGetAdvFNElement-Template-All-Line-Items.xls by dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg
2a
Get Yahoo History Problem by "Al Eaton" aleaton93309
2b
Re: Get Yahoo History Problem [1 Attachment] by "Randy Harmelink" rharmelink
3a
So Close by thomas777crown
3b
Re: So Close by "Randy Harmelink" rharmelink

Messages

Sun Sep 4, 2016 5:46 am (PDT) . Posted by:

dzi6ewzrdnxj7wkxo5f6mlhps7ydjxexnjzqjzdg

Randy,
I've made a screenshot of the Excel:

As you can see the data is missing but the template is showing that there are 23 numbers of periods available.I didn't succeed to change the Access Data Sources Across Domains in Internet Explorer.. I've a Dutch version of Internet Explorer and can't find the option. Do you maybe have a kind of manual?
Many thanks!
Regards,Rico 

Sent from Yahoo Mail. Get the app

On Saturday, September 3, 2016 6:44 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  ​What values do you have in cells C2:C5 of the "All Lines" workbook?

Also, what do you get for:

=RCHGetElementNumber("Version&quot;)

Have you set up IE for the across-domains issue mentioned on the "Tips and FAQs" page for AdvFN?

​​On Sat, Sep 3, 2016 at 8:48 AM, ricoteikotte@​...wrote:

I found the AdvFN templates on the website.The first template (smfGetAdvFNElement-Template- All-Line-Items.xls) doesn't work but the second template does work (smfGetAdvFNElement-Template- Specific-Line-Items.xls)Does anybody has a clue how to solve this?

​On Sat, Sep 3, 2016 at 8:51 AM, ricoteikotte@​...wrote:

I have the following question:
I found the AdvFN templates on the website. The first template isn't working but the second template does work!Has anybody a clue how to solve this? I'm a European user and created a text file called smf-AdvFN-Prefix.txt with uk in it


#yiv2124515002 #yiv2124515002 -- #yiv2124515002ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2124515002 #yiv2124515002ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2124515002 #yiv2124515002ygrp-mkp #yiv2124515002hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2124515002 #yiv2124515002ygrp-mkp #yiv2124515002ads {margin-bottom:10px;}#yiv2124515002 #yiv2124515002ygrp-mkp .yiv2124515002ad {padding:0 0;}#yiv2124515002 #yiv2124515002ygrp-mkp .yiv2124515002ad p {margin:0;}#yiv2124515002 #yiv2124515002ygrp-mkp .yiv2124515002ad a {color:#0000ff;text-decoration:none;}#yiv2124515002 #yiv2124515002ygrp-sponsor #yiv2124515002ygrp-lc {font-family:Arial;}#yiv2124515002 #yiv2124515002ygrp-sponsor #yiv2124515002ygrp-lc #yiv2124515002hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2124515002 #yiv2124515002ygrp-sponsor #yiv2124515002ygrp-lc .yiv2124515002ad {margin-bottom:10px;padding:0 0;}#yiv2124515002 #yiv2124515002actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2124515002 #yiv2124515002activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2124515002 #yiv2124515002activity span {font-weight:700;}#yiv2124515002 #yiv2124515002activity span:first-child {text-transform:uppercase;}#yiv2124515002 #yiv2124515002activity span a {color:#5085b6;text-decoration:none;}#yiv2124515002 #yiv2124515002activity span span {color:#ff7900;}#yiv2124515002 #yiv2124515002activity span .yiv2124515002underline {text-decoration:underline;}#yiv2124515002 .yiv2124515002attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2124515002 .yiv2124515002attach div a {text-decoration:none;}#yiv2124515002 .yiv2124515002attach img {border:none;padding-right:5px;}#yiv2124515002 .yiv2124515002attach label {display:block;margin-bottom:5px;}#yiv2124515002 .yiv2124515002attach label a {text-decoration:none;}#yiv2124515002 blockquote {margin:0 0 0 4px;}#yiv2124515002 .yiv2124515002bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2124515002 .yiv2124515002bold a {text-decoration:none;}#yiv2124515002 dd.yiv2124515002last p a {font-family:Verdana;font-weight:700;}#yiv2124515002 dd.yiv2124515002last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2124515002 dd.yiv2124515002last p span.yiv2124515002yshortcuts {margin-right:0;}#yiv2124515002 div.yiv2124515002attach-table div div a {text-decoration:none;}#yiv2124515002 div.yiv2124515002attach-table {width:400px;}#yiv2124515002 div.yiv2124515002file-title a, #yiv2124515002 div.yiv2124515002file-title a:active, #yiv2124515002 div.yiv2124515002file-title a:hover, #yiv2124515002 div.yiv2124515002file-title a:visited {text-decoration:none;}#yiv2124515002 div.yiv2124515002photo-title a, #yiv2124515002 div.yiv2124515002photo-title a:active, #yiv2124515002 div.yiv2124515002photo-title a:hover, #yiv2124515002 div.yiv2124515002photo-title a:visited {text-decoration:none;}#yiv2124515002 div#yiv2124515002ygrp-mlmsg #yiv2124515002ygrp-msg p a span.yiv2124515002yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2124515002 .yiv2124515002green {color:#628c2a;}#yiv2124515002 .yiv2124515002MsoNormal {margin:0 0 0 0;}#yiv2124515002 o {font-size:0;}#yiv2124515002 #yiv2124515002photos div {float:left;width:72px;}#yiv2124515002 #yiv2124515002photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2124515002 #yiv2124515002photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2124515002 #yiv2124515002reco-category {font-size:77%;}#yiv2124515002 #yiv2124515002reco-desc {font-size:77%;}#yiv2124515002 .yiv2124515002replbq {margin:4px;}#yiv2124515002 #yiv2124515002ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2124515002 #yiv2124515002ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2124515002 #yiv2124515002ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2124515002 #yiv2124515002ygrp-mlmsg select, #yiv2124515002 input, #yiv2124515002 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2124515002 #yiv2124515002ygrp-mlmsg pre, #yiv2124515002 code {font:115% monospace;}#yiv2124515002 #yiv2124515002ygrp-mlmsg * {line-height:1.22em;}#yiv2124515002 #yiv2124515002ygrp-mlmsg #yiv2124515002logo {padding-bottom:10px;}#yiv2124515002 #yiv2124515002ygrp-msg p a {font-family:Verdana;}#yiv2124515002 #yiv2124515002ygrp-msg p#yiv2124515002attach-count span {color:#1E66AE;font-weight:700;}#yiv2124515002 #yiv2124515002ygrp-reco #yiv2124515002reco-head {color:#ff7900;font-weight:700;}#yiv2124515002 #yiv2124515002ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2124515002 #yiv2124515002ygrp-sponsor #yiv2124515002ov li a {font-size:130%;text-decoration:none;}#yiv2124515002 #yiv2124515002ygrp-sponsor #yiv2124515002ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2124515002 #yiv2124515002ygrp-sponsor #yiv2124515002ov ul {margin:0;padding:0 0 0 8px;}#yiv2124515002 #yiv2124515002ygrp-text {font-family:Georgia;}#yiv2124515002 #yiv2124515002ygrp-text p {margin:0 0 1em 0;}#yiv2124515002 #yiv2124515002ygrp-text tt {font-size:120%;}#yiv2124515002 #yiv2124515002ygrp-vital ul li:last-child {border-right:none !important;}#yiv2124515002

Attachment(s) from
1 of 1 Photo(s)

Sun Sep 4, 2016 11:54 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I see two possible issues:

1. According to the "Version" info, you're not using a UK prefix. But if
the "specific"; version is working, you may not need it? Not sure.

2. The formula in cell B5 is what allows all of the line items to be
retrieved in the workbook. If you're getting re-directed to the UK site,
you'll need to changes all of the "www" references in that URL to "uk".

​No manual of the IE stuff. It varies by IE version and I only have one
version of IE.​ The add-in is just sharing something I wrote for my own
use, with my version of IE and EXCEL, and running with a US region. I'm not
a commercial entity that has the ability to test over all platform
permutations.

Plus, I barely use AdvFN any more, because of past issues with their data.
I've switched over to GuruFocus, although I'm using it as a paid subscriber.

On Sun, Sep 4, 2016 at 5:43 AM, ricoteikotte@
​...wrote:

>
> Randy,
>
> I've made a screenshot of the Excel:
>
> [image: Inline image]
>
> As you can see the data is missing but the template is showing that there
> are 23 numbers of periods available.
> I didn't succeed to change the Access Data Sources Across Domains in
> Internet Explorer.. I've a Dutch version of Internet Explorer and can't
> find the option. Do you maybe have a kind of manual?
>
> Many thanks!
>
>

Sun Sep 4, 2016 11:13 pm (PDT) . Posted by:

"Al Eaton" aleaton93309



I am running Excel 2013, Windows 10 - 64bit and have the 2.1 2016.09.02
version of the RCH Stock Market functions. I am trying to create an Array
to download historical prices for multiple Tickers and multiple dates. I
have tried to do this with the GetYahooHistory and smfPricesbyDate. Both
give me an error. Below is the Array I am trying to create along with the
formula I am using. Can anyone tell me what I am doing wrong? I have also
attached a copy of the Excel file I am using.


8/25/2016

8/1/2016

6/1/2016

12/31/2015

9/1/2015

9/1/2014

Ticker

Last Price

1 Week

1 month

3 Months

YTD

1 Year

2 Years

C

$47.51

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

CCI

$96.06

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

CMRE

$8.75

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

CSCO

$31.83

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

CTSH

$58.36

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

DGS

$42.05

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!



{=RCHGetYahooHistory(I22:I27,K5:P5,K4:P4,K3:P3,K5:P5,K4:P4,K3:P3,"d","A",0)}



Al Eaton

aleaton48@gmail.com <mailto:aleaton48@gmail.com>

Attachment(s) from Al Eaton
1 of 1 File(s)

Mon Sep 5, 2016 12:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooHistory() and smfPricesByDates() can only be done on a single
ticker at a time.

On Sun, Sep 4, 2016 at 9:21 PM, 'Al Eaton' aleaton48@
​...wrote:

>
>
> I am running Excel 2013, Windows 10 - 64bit and have the 2.1 2016.09.02
> version of the RCH Stock Market functions. I am trying to create an Array
> to download historical prices for multiple Tickers and multiple dates. I
> have tried to do this with the GetYahooHistory and smfPricesbyDate. Both
> give me an error. Below is the Array I am trying to create along with the
> formula I am using. Can anyone tell me what I am doing wrong? I have also
> attached a copy of the Excel file I am using.
>
>
>
> *8/25/2016*
>
> *8/1/2016*
>
> *6/1/2016*
>
> *12/31/2015*
>
> *9/1/2015*
>
> *9/1/2014*
>
> *Ticker*
>
> *Last Price*
>
> *1 Week*
>
> *1 month*
>
> *3 Months*
>
> *YTD*
>
> *1 Year*
>
> *2 Years*
>
> C
>
> $47.51
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> CCI
>
> $96.06
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
>
>
> CMRE
>
> $8.75
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> CSCO
>
> $31.83
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> CTSH
>
> $58.36
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> DGS
>
> $42.05
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> #VALUE!
>
> {=RCHGetYahooHistory(I22:I27,K5:P5,K4:P4,K3:P3,K5:P5,K4:P4,
> K3:P3,"d","A",0)}
>
>
>
>
>

Mon Sep 5, 2016 1:11 am (PDT) . Posted by:

thomas777crown

Randy,


I type =smfConvertData(smfGetTagContent("http://www.etf.com/AYT,"div",1,">Brand"))to get the Brand name but instead I get <a href="/channels/ipath-etfs" typeof="skos:Concept&quot; property="rdfs:label skos:prefLabel"; datatype="">iPath</a>


what can I type in just to get iPath


Best






Mon Sep 5, 2016 1:42 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You were close. You don't need the smfConvertData(), because it's a string
being returned. No need to try and convert it to a number. And you just
used the wrong HTML tag. The brand name is between the anchor tags (i.e.
"a"). So:

=smfGetTagContent("http://www.etf.com/AYT","a",1,">Brand")

On Mon, Sep 5, 2016 at 1:11 AM, thomas777crown@ wrote:

> I type =smfConvertData(smfGetTagContent("http://www.etf.com/AYT,
> "div",1,">Brand"))to get the Brand name but instead I get <a
> href="/channels/ipath-etfs" typeof="skos:Concept&quot; property="rdfs:label
> skos:prefLabel"; datatype="">iPath</a>
>
> what can I type in just to get iPath
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar