Messages In This Digest (15 Messages)
- 1a.
- Re: File upload notification From: Randy Harmelink
- 2a.
- Re: Having trouble adding a new element to smf-elements-20.txt From: MikeM
- 2b.
- Re: Having trouble adding a new element to smf-elements-20.txt From: Randy Harmelink
- 3a.
- ADVFN not working? From: newengwongpeggy
- 3b.
- Re: ADVFN not working? From: MikeM
- 3c.
- Re: ADVFN not working? From: newengwongpeggy
- 3d.
- Re: ADVFN not working? From: Randy Harmelink
- 4a.
- Re: SMFGetAdvfnElement Error Fix From: Lal Echterhoff
- 4b.
- Re: SMFGetAdvfnElement Error Fix From: Randy Harmelink
- 5a.
- Along with the MSN screwiness From: obanduzzy
- 5b.
- Re: Along with the MSN screwiness From: Randy Harmelink
- 5c.
- Re: Along with the MSN screwiness From: obanduzzy
- 5d.
- Re: Along with the MSN screwiness From: B B
- 5e.
- Re: Along with the MSN screwiness From: Randy Harmelink
- 5f.
- Re: Along with the MSN screwiness From: B B
Messages
- 1a.
-
Re: File upload notification
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Apr 30, 2012 1:59 am (PDT)
The person that uploads it can toggle a switch that tells the Yahoo group
to issue an email announcing that it has been uploaded. Otherwise, the only
way is to manually check the files area.
On Mon, Apr 30, 2012 at 12:55 AM, bizmark_ee <dustinsmoak@live.com > wrote:
> How do I get notified when a new file has been uploaded? Thanks.
>
- 2a.
-
Re: Having trouble adding a new element to smf-elements-20.txt
Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802
Mon Apr 30, 2012 5:46 am (PDT)
But, the string for the function I am trying is only 86 characters. In fact, my string is shorter than the ones you use in elements-9.txt for numbers 807 and 808 - which also both work for me.
I tried putting a semi-colon after the string to have a strict delimiter after the string but that didn't help. Any other ideas? I have a bunch I was hoping to do this way.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Unfortunately, one drawback of that way of defining an element is that it
> uses the EVAL() VBA function. That has problems with long strings -- it
> errors out if an internal string is over 255 bytes.
>
> For example, the first formula here works, but the second gives a #VALUE!
> error:
>
> =smfEval("Rept(2,255)")
> =smfEval("Rept(2,256)")
>
- 2b.
-
Re: Having trouble adding a new element to smf-elements-20.txt
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Apr 30, 2012 8:57 am (PDT)
It's not the length of the function itself that is the problem. It's the
length of what is being returned from the function invocation. For ticker
MMM, it's 3855 bytes long.
For example, you could change your element definition to:
19000;WSJ;Company Name;=smfGetTagContent("
http://quotes.wsj.com/~ ~~~~/company- people
","p",1,"cr_company_desc" ,,,,,,,255)
...but it would only return the first 255 bytes of the company
description...
On Mon, Apr 30, 2012 at 5:46 AM, MikeM <mikemcq802@yahoo.com > wrote:
> But, the string for the function I am trying is only 86 characters. In
> fact, my string is shorter than the ones you use in elements-9.txt for
> numbers 807 and 808 - which also both work for me.
>
> I tried putting a semi-colon after the string to have a strict delimiter
> after the string but that didn't help. Any other ideas? I have a bunch I
> was hoping to do this way.
>
>
- 3a.
-
ADVFN not working?
Posted by: "newengwongpeggy" tong82@gmail.com newengwongpeggy
Mon Apr 30, 2012 6:57 am (PDT)
hi, anyone have issue with ADVFN?
it has not been working for few days for me.
- 3b.
-
Re: ADVFN not working?
Posted by: "MikeM" mikemcq802@yahoo.com mikemcq802
Mon Apr 30, 2012 7:18 am (PDT)
Working fine for me today and previous days.
Have you reviewed the Links section:
http://finance.groups.yahoo. com/group/ smf_addin/ links
And, we'll need more details on your situation than just "not working". Give an example function with ticker at least please.
Also, do =RCHGetElementNumber("version" ) and report the version you are using.
--- In smf_addin@yahoogroups.com , "newengwongpeggy" <tong82@...> wrote:
>
> hi, anyone have issue with ADVFN?
> it has not been working for few days for me.
>
- 3c.
-
Re: ADVFN not working?
Posted by: "newengwongpeggy" tong82@gmail.com newengwongpeggy
Mon Apr 30, 2012 8:14 am (PDT)
my version:Stock Market Functions add-in, Version 2.1.2010.08.02
i just found out i use the =RCHGetElementNumber(Sym,3) to get the exchange that the stock is in as it is necessary to have that when loading symbol in advfn. but RCHGetElementNumber (Sym,3) turns to Error now. any fix?
thx
--- In smf_addin@yahoogroups.com , "MikeM" <mikemcq802@...> wrote:
>
> Working fine for me today and previous days.
>
> Have you reviewed the Links section:
> http://finance.groups.yahoo. com/group/ smf_addin/ links
>
> And, we'll need more details on your situation than just "not working". Give an example function with ticker at least please.
>
> Also, do =RCHGetElementNumber("version" ) and report the version you are using.
>
> --- In smf_addin@yahoogroups.com , "newengwongpeggy" <tong82@> wrote:
> >
> > hi, anyone have issue with ADVFN?
> > it has not been working for few days for me.
> >
>
- 3d.
-
Re: ADVFN not working?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Apr 30, 2012 9:08 am (PDT)
You probably need the new smf-elements-1.txt from the "Works in Progress"
folder. MSN recently revamped their web page structure and content, so most
of their elements had to be redefined.
On Mon, Apr 30, 2012 at 8:14 AM, newengwongpeggy <tong82@gmail.com > wrote:
>
> my version:Stock Market Functions add-in, Version 2.1.2010.08.02
> i just found out i use the =RCHGetElementNumber(Sym,3) to get the exchange
> that the stock is in as it is necessary to have that when loading symbol in
> advfn. but RCHGetElementNumber(Sym,3) turns to Error now. any fix?
>
- 4a.
-
Re: SMFGetAdvfnElement Error Fix
Posted by: "Lal Echterhoff" bigzippy@bellsouth.net bigzippy@bellsouth.net
Mon Apr 30, 2012 7:28 am (PDT)
On my laptop this is disabled and the add in still works fine but on my work cpu I(cant accses IE security on this) still get error both use same poer sys Windows 7 and IE 8 and Excel 2010 but my work is on a network PLEASE help i need this to work any idea are very much appreciated
Thanks
Lal
--- In smf_addin@yahoogroups.com , "laveys" <laveys@...> wrote:
>
> Hi Randy
>
> I was having the same problems with the SMFGetAdvfnElement function as others - it used to work and then stopped working.
>
> I have found a fix that works for me and thought I'd post in case it helps others.
>
> Try these steps:
>
> In Internet Explorer : Tools, Internet Options, Security, Custom Level button (for the zone that's currently highlighted); Find the 'Access Data Sources Across Domains' option and set to 'Enable'. Click OK to save the settings change.
>
> I suspect that a windows update from around May 20th caused this issue.
>
> Good Luck & Hope it helps some of you having issues with this function.
>
> And Randy, Thanks so much for your excellent effort with SMF
>
> Regards
>
> Raver
>
- 4b.
-
Re: SMFGetAdvfnElement Error Fix
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Apr 30, 2012 9:06 am (PDT)
If IE security is the problem, I have no way to help.
In your browser, were do you end up if you tell it to go to "advfn.com"?
Do you end up at "http;//www.advfn.com" or do you have a prefix other than
"www"?
What do you get for:
=RCHGetElementNumber("Version" )
=RCHGetTableCell("
http://www.advfn.com/p.php? ",pid=financials& symbol=KO& mode=annual_ reports&start_ date=0
1, "year end date")
=smfGetAdvFNElement("KO","A" ,999)
=smfGetAdvFNElement("KO","A" ,1,">year end date<")
On Mon, Apr 30, 2012 at 7:27 AM, Lal Echterhoff <bigzippy@bellsouth.net >wrote:
> On my laptop this is disabled and the add in still works fine but on my
> work cpu I(cant accses IE security on this) still get error both use same
> poer sys Windows 7 and IE 8 and Excel 2010 but my work is on a network
> PLEASE help i need this to work any idea are very much appreciated
> Thanks
> Lal
>
- 5a.
-
Along with the MSN screwiness
Posted by: "obanduzzy" obanduzzy@gmail.com obanduzzy
Mon Apr 30, 2012 9:50 am (PDT)
Hey Randy,
I've noticed glitches with elements
213-222
223-232
163-172
ROE, ROA, and P/E datapoints.
Though I'm not completely convinced when I 'updated" the -1.txt file that took ok.
thanks for all of your efforts on an outstanding package.
- 5b.
-
Re: Along with the MSN screwiness
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Apr 30, 2012 9:53 am (PDT)
Thanks, I'll take a look at them.
The ones I did fix were ones that were in templates, so I had some way to
specifically check and see if "Error" was coming through or not.
I'm planning to go through them element by element when I get some time.
But I wanted to get the majority fixed quickly, since they were easier to
do.
On Mon, Apr 30, 2012 at 9:46 AM, obanduzzy <obanduzzy@gmail.com > wrote:
>
> I've noticed glitches with elements
>
> 213-222
> 223-232
> 163-172
>
> ROE, ROA, and P/E datapoints.
>
> Though I'm not completely convinced when I 'updated" the -1.txt file that
> took ok.
>
> thanks for all of your efforts on an outstanding package.
>
- 5c.
-
Re: Along with the MSN screwiness
Posted by: "obanduzzy" obanduzzy@gmail.com obanduzzy
Mon Apr 30, 2012 9:58 am (PDT)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Thanks, I'll take a look at them.
>
> The ones I did fix were ones that were in templates, so I had some way to
> specifically check and see if "Error" was coming through or not.
>
> I'm planning to go through them element by element when I get some time.
> But I wanted to get the majority fixed quickly, since they were easier to
> do.
>
> On Mon, Apr 30, 2012 at 9:46 AM, obanduzzy <obanduzzy@...> wrote:
>
> >
> > I've noticed glitches with elements
> >
> > 213-222
> > 223-232
> > 163-172
> >
> > ROE, ROA, and P/E datapoints.
> >
> > Though I'm not completely convinced when I 'updated" the -1.txt file that
> > took ok.
> >
> > thanks for all of your efforts on an outstanding package.
> >
>
well clearly msn just likes to give people grief. well you mostly and us secondarily.
I have to say I'm in awe of this add in. You have done an amazing piece of work with this. :)
- 5d.
-
Re: Along with the MSN screwiness
Posted by: "B B" kokdari82@yahoo.com kokdari82
Mon Apr 30, 2012 3:31 pm (PDT)
It also seems like element 25 is broken because they removed the "last price" text. Element 25 now brings up yesterdays closing price.
On another note, yahoo also changed the way current price is displayed.
Is there a way to get the current price from google finance?
--- In smf_addin@yahoogroups.com , "obanduzzy" <obanduzzy@...> wrote:
>
>
> Hey Randy,
>
>
> I've noticed glitches with elements
>
> 213-222
> 223-232
> 163-172
>
> ROE, ROA, and P/E datapoints.
>
> Though I'm not completely convinced when I 'updated" the -1.txt file that took ok.
>
> thanks for all of your efforts on an outstanding package.
>
- 5e.
-
Re: Along with the MSN screwiness
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Apr 30, 2012 3:45 pm (PDT)
Element 25 is an MSN problem. It's what they are reporting for "Last Price".
You should use RCHGetYahooQuotes() for current quotes.
The SMF-Template-Yahoo-Google- Pre-Market- Quotes.xls template appears to be
working right now for Google, but not for Yahoo.
On Mon, Apr 30, 2012 at 3:31 PM, B B <kokdari82@yahoo.com > wrote:
> It also seems like element 25 is broken because they removed the "last
> price" text. Element 25 now brings up yesterdays closing price.
>
> On another note, yahoo also changed the way current price is displayed.
>
> Is there a way to get the current price from google finance?
>
- 5f.
-
Re: Along with the MSN screwiness
Posted by: "B B" kokdari82@yahoo.com kokdari82
Mon Apr 30, 2012 11:10 pm (PDT)
Thanks for that suggestion but one reason I like to stay away from yahoo to get prices is because pink sheet stock symbols require .pk at the end otherwise nothing shows up.
That's why I much prefer something like Google.
It also seems like Google has a api too which makes the basic information easier to get.
http://www.google.com/ig/api? stock=aapl
So for something like this where I want the last price which is defined by the following tag <last data="583.98"/> , how should I extract that?
I did something like the following, but is there a more efficient way of using the getsmftagcontent function?
Cell A1 has
=smfGetTagContent("http://www.google. com/ig/api? ","",12)stock=msft
Cell A2
=FIND("/",A1)-1
Cell A3
=FIND("=",A1)+2
Cell A4
=MID(A1,A3,A2-A3)
Cell A4 displays the correct last price.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Element 25 is an MSN problem. It's what they are reporting for "Last Price".
>
> You should use RCHGetYahooQuotes() for current quotes.
>
> The SMF-Template-Yahoo-Google- Pre-Market- Quotes.xls template appears to be
> working right now for Google, but not for Yahoo.
>
> On Mon, Apr 30, 2012 at 3:31 PM, B B <kokdari82@...> wrote:
>
> > It also seems like element 25 is broken because they removed the "last
> > price" text. Element 25 now brings up yesterdays closing price.
> >
> > On another note, yahoo also changed the way current price is displayed.
> >
> > Is there a way to get the current price from google finance?
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar