Senin, 23 Maret 2015

[smf_addin] Digest Number 3365

6 Messages

Digest #3365

Messages

Sun Mar 22, 2015 5:14 am (PDT) . Posted by:

"Joe" jtassielli2003


Yup, I'm visiting the Great White North.So, I'm assuming when I get back to the Red, White & Blue.  This will not be a problem?
Joe

  From: "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, March 22, 2015 1:00 AM
Subject: Re: [smf_addin] Rchgetelementnumber, ADVFN, retrieving right symbol, wrong company

  Ahhh. You must be in Canada? If so, it defaults to the Canadian exchanges.

I don't have anything in there, yet, to allow exchange prefixes to be used on ticker symbols.

On Sat, Mar 21, 2015 at 6:22 PM, jtassielli2003@... wrote:

Cell A2="GIS"Rchgetelementnumber(a2,5885) I get eps for TSVX:GIS (grey Island system), I want NYSE:GIS (general Mills)I also tried smfgetadvFNElement function, same result.How do I have these functions, select the NYSE or NASDAQ company that shares the same symbol with another company on some other exchange.another example clx, there's TSVX:CLX and NYSE:CLX.

#yiv4582212305 #yiv4582212305 -- #yiv4582212305ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4582212305 #yiv4582212305ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4582212305 #yiv4582212305ygrp-mkp #yiv4582212305hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4582212305 #yiv4582212305ygrp-mkp #yiv4582212305ads {margin-bottom:10px;}#yiv4582212305 #yiv4582212305ygrp-mkp .yiv4582212305ad {padding:0 0;}#yiv4582212305 #yiv4582212305ygrp-mkp .yiv4582212305ad p {margin:0;}#yiv4582212305 #yiv4582212305ygrp-mkp .yiv4582212305ad a {color:#0000ff;text-decoration:none;}#yiv4582212305 #yiv4582212305ygrp-sponsor #yiv4582212305ygrp-lc {font-family:Arial;}#yiv4582212305 #yiv4582212305ygrp-sponsor #yiv4582212305ygrp-lc #yiv4582212305hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4582212305 #yiv4582212305ygrp-sponsor #yiv4582212305ygrp-lc .yiv4582212305ad {margin-bottom:10px;padding:0 0;}#yiv4582212305 #yiv4582212305actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4582212305 #yiv4582212305activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4582212305 #yiv4582212305activity span {font-weight:700;}#yiv4582212305 #yiv4582212305activity span:first-child {text-transform:uppercase;}#yiv4582212305 #yiv4582212305activity span a {color:#5085b6;text-decoration:none;}#yiv4582212305 #yiv4582212305activity span span {color:#ff7900;}#yiv4582212305 #yiv4582212305activity span .yiv4582212305underline {text-decoration:underline;}#yiv4582212305 .yiv4582212305attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4582212305 .yiv4582212305attach div a {text-decoration:none;}#yiv4582212305 .yiv4582212305attach img {border:none;padding-right:5px;}#yiv4582212305 .yiv4582212305attach label {display:block;margin-bottom:5px;}#yiv4582212305 .yiv4582212305attach label a {text-decoration:none;}#yiv4582212305 blockquote {margin:0 0 0 4px;}#yiv4582212305 .yiv4582212305bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4582212305 .yiv4582212305bold a {text-decoration:none;}#yiv4582212305 dd.yiv4582212305last p a {font-family:Verdana;font-weight:700;}#yiv4582212305 dd.yiv4582212305last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4582212305 dd.yiv4582212305last p span.yiv4582212305yshortcuts {margin-right:0;}#yiv4582212305 div.yiv4582212305attach-table div div a {text-decoration:none;}#yiv4582212305 div.yiv4582212305attach-table {width:400px;}#yiv4582212305 div.yiv4582212305file-title a, #yiv4582212305 div.yiv4582212305file-title a:active, #yiv4582212305 div.yiv4582212305file-title a:hover, #yiv4582212305 div.yiv4582212305file-title a:visited {text-decoration:none;}#yiv4582212305 div.yiv4582212305photo-title a, #yiv4582212305 div.yiv4582212305photo-title a:active, #yiv4582212305 div.yiv4582212305photo-title a:hover, #yiv4582212305 div.yiv4582212305photo-title a:visited {text-decoration:none;}#yiv4582212305 div#yiv4582212305ygrp-mlmsg #yiv4582212305ygrp-msg p a span.yiv4582212305yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4582212305 .yiv4582212305green {color:#628c2a;}#yiv4582212305 .yiv4582212305MsoNormal {margin:0 0 0 0;}#yiv4582212305 o {font-size:0;}#yiv4582212305 #yiv4582212305photos div {float:left;width:72px;}#yiv4582212305 #yiv4582212305photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv4582212305 #yiv4582212305photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4582212305 #yiv4582212305reco-category {font-size:77%;}#yiv4582212305 #yiv4582212305reco-desc {font-size:77%;}#yiv4582212305 .yiv4582212305replbq {margin:4px;}#yiv4582212305 #yiv4582212305ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4582212305 #yiv4582212305ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4582212305 #yiv4582212305ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4582212305 #yiv4582212305ygrp-mlmsg select, #yiv4582212305 input, #yiv4582212305 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4582212305 #yiv4582212305ygrp-mlmsg pre, #yiv4582212305 code {font:115% monospace;}#yiv4582212305 #yiv4582212305ygrp-mlmsg * {line-height:1.22em;}#yiv4582212305 #yiv4582212305ygrp-mlmsg #yiv4582212305logo {padding-bottom:10px;}#yiv4582212305 #yiv4582212305ygrp-msg p a {font-family:Verdana;}#yiv4582212305 #yiv4582212305ygrp-msg p#yiv4582212305attach-count span {color:#1E66AE;font-weight:700;}#yiv4582212305 #yiv4582212305ygrp-reco #yiv4582212305reco-head {color:#ff7900;font-weight:700;}#yiv4582212305 #yiv4582212305ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4582212305 #yiv4582212305ygrp-sponsor #yiv4582212305ov li a {font-size:130%;text-decoration:none;}#yiv4582212305 #yiv4582212305ygrp-sponsor #yiv4582212305ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4582212305 #yiv4582212305ygrp-sponsor #yiv4582212305ov ul {margin:0;padding:0 0 0 8px;}#yiv4582212305 #yiv4582212305ygrp-text {font-family:Georgia;}#yiv4582212305 #yiv4582212305ygrp-text p {margin:0 0 1em 0;}#yiv4582212305 #yiv4582212305ygrp-text tt {font-size:120%;}#yiv4582212305 #yiv4582212305ygrp-vital ul li:last-child {border-right:none !important;}#yiv4582212305

Sun Mar 22, 2015 8:07 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hopefully not. I have added some code to the add-in to allow specification
of the exchange in the ticker symbol. That used to work, before they put
exchange in the URL.

On Sun, Mar 22, 2015 at 5:13 AM, Joe jtassielli2003@... wrote:

>
> Yup, I'm visiting the Great White North.
> So, I'm assuming when I get back to the Red, White & Blue. This will not
> be a problem?
>
>
>

Sun Mar 22, 2015 12:39 pm (PDT) . Posted by:

pvdspieg

Hi Randy,

I was trying to get the currency from the yahoo stock data and came across this post.
Unfortunately, the proposed solution is not giving me anything.

=smfstrExtr(smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=N4E.SI http://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency in")," in ",".")

Even when trying the following, I get an error:
=smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=N4E.SI http://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency in")

Can you help me or explain why this might not be working?

Many thanks in advance.

Kind regards,
Peter

Sun Mar 22, 2015 12:49 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo apparently is using a different URL now. It's an "https" protocol,
not "http". That is:

=smfStrExtr(smfGetTagContent("https://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency
in")," in ",".")

On Sun, Mar 22, 2015 at 12:39 PM, pvdspieg@... wrote:

>
> I was trying to get the currency from the yahoo stock data and came across
> this post.
> Unfortunately, the proposed solution is not giving me anything.
>
> =smfstrExtr(smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency
> in")," in ",".")
>
> Even when trying the following, I get an error:
> =smfGetTagContent("http://sg.finance.yahoo.com/q/hp?s=N4E.SI","p",-1,"Currency
> in")
>
> Can you help me or explain why this might not be working?
>

Sun Mar 22, 2015 12:56 pm (PDT) . Posted by:

pvdspieg

Randy,

You are truly amazing. You made this great add-on, you shared it freely with the world and are now still continuously and unconditionally providing support.
What is driving you?

There are no words for such generosity.
My sincere gratitude for your kindness. To be very honest, I would love to meet you and thank you in person.

Kind regards,
Peter

Sun Mar 22, 2015 2:04 pm (PDT) . Posted by:

panda317

Hear, hear!

I too, am amazed at Randy's dedication and genuine care for so many unknown people that come to this group for this absolutely free and quite marvelous add-on and the equally free and marvelous support.

I, too, would love to meet Randy and at the very least break bread with him or buy him a beverage of his choosing.

Respectfully submitted.

Pat
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar