11 New Messages
Digest #2899
3b
Re: SMF-Template-Zacks-Earnings-Announcements.xls from work in progr by "Randy Harmelink" rharmelink
3d
Re: SMF-Template-Zacks-Earnings-Announcements.xls from work in progr by "Randy Harmelink" rharmelink
Messages
Thu Dec 19, 2013 2:37 am (PST) . Posted by:
philip_r_small
Many thanks for the reply. I will try your suggestion. My VBA skills are sadly very limited - particularly next to yours and the knowledge of SMF.
Thu Dec 19, 2013 3:28 am (PST) . Posted by:
markclippitt
After many months of flawless operation my yahoo quotes are no longer working either
Here's an example of the cell that has stopped working
='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A37, "l1")
The cell returns #NAME?
Cell A37 contains symbol VGSNX.The sheet has 50 symbols and all have stopped returning new values.
Any help is much appreciated, If there is something I can do to help debug this I'm interested.
Mark
Here's an example of the cell that has stopped working
='C:\
The cell returns #NAME?
Cell A37 contains symbol VGSNX.The sheet has 50 symbols and all have stopped returning new values.
Any help is much appreciated, If there is something I can do to help debug this I'm interested.
Mark
Thu Dec 19, 2013 3:34 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See the "Location Errors" item in the LINKS area of the group.
You need to manually remove the paths from your function invocations. Or
check the add-in manager, and make sure the add-in is still listed there.
On Thu, Dec 19, 2013 at 3:47 AM, <markclippitt@yahoo.com> wrote:
> After many months of flawless operation my yahoo quotes are no longer
> working either
>
> Here's an example of the cell that has stopped working
>
> ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(A37, "l1")
>
> The cell returns #NAME?
>
> Cell A37 contains symbol VGSNX.The sheet has 50 symbols and all have
> stopped returning new values.
>
> Any help is much appreciated, If there is something I can do to help debug
> this I'm interested.
>
>
You need to manually remove the paths from your function invocations. Or
check the add-in manager, and make sure the add-in is still listed there.
On Thu, Dec 19, 2013 at 3:47 AM, <markclippitt@
> After many months of flawless operation my yahoo quotes are no longer
> working either
>
> Here's an example of the cell that has stopped working
>
> ='C:\
> Add-In\RCH_
>
> The cell returns #NAME?
>
> Cell A37 contains symbol VGSNX.The sheet has 50 symbols and all have
> stopped returning new values.
>
> Any help is much appreciated, If there is something I can do to help debug
> this I'm interested.
>
>
Thu Dec 19, 2013 7:32 am (PST) . Posted by:
petekoch
I reinstalled KB2850022 and KB2817641 and both GetYahooQuotes and GetYahooHistory are performing normally (and fast). I'm convinced it was a Yahoo! issue.
BTW, there was an 'Office Validate Configuration' update which I no longer see which, I think, attempted to install Word and Power Point, two applications in the Office Suite I do not use (I use Excel, One Note and Outlook). After reconfiguring Office through the Control Panel and removing Word and Power Point, everything seems to be working correctly.
BTW, there was an 'Office Validate Configuration&#
Thu Dec 19, 2013 7:24 am (PST) . Posted by:
"Jacob Jose" pepecan47
Hi Randy - when using SMF-Template-Zacks-Earnings-Announcements.xls from work in progress folder,
I am getting "Error" on all cells. I installed SMF Add-In and downloaded all .txt files from that folder.
Regards,
Jose L. Jacob
I am getting "Error" on all cells. I installed SMF Add-In and downloaded all .txt files from that folder.
Regards,
Jose L. Jacob
Thu Dec 19, 2013 7:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
What version of EXCEL do you have? And what do you get for:
=RCHGetElementNumber("MMM";,1290)
=RCHGetElementNumber("Version")
=smfGetAParms(1290)
=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("
http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period
Ending"),"""data"" : [ ","]"),1,"}"),2,","),": ","~"),"""","""")
Are you able to access this web page:
http://www.zacks.com/stock/research/MMM/earnings-announcements
On Thu, Dec 19, 2013 at 8:24 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> Hi Randy - when using SMF-Template-Zacks-Earnings-Announcements.xls
> from work in progress folder,
> I am getting "Error" on all cells. I installed SMF Add-In and downloaded
> all .txt files from that folder.
>
>
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=smfstrExtr(
http://www.zacks.
Ending"
Are you able to access this web page:
http://www.zacks.
On Thu, Dec 19, 2013 at 8:24 AM, Jacob Jose <pepecan47@yahoo.
>
> Hi Randy - when using SMF-Template-
> from work in progress folder,
> I am getting "Error" on all cells. I installed SMF Add-In and downloaded
> all .txt files from that folder.
>
>
Thu Dec 19, 2013 1:38 pm (PST) . Posted by:
"Jacob Jose" pepecan47
Hi Randy, answering your questions,
>> What version of EXCEL do you have?
2003
>> =RCHGetElementNumber("MMM";,1290)
Error
>> =RCHGetElementNumber("Version")
Stock Market Functions add-in, Version 2.1.2013.10.17 (C:\SMF Add-In; ; 1)
>> =smfGetAParms(1290)
ZacksEA;Quarterly Earnings -- Reported Date -- 1;=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/~~~~~/earnings-announcements%22,%22script%22,-1,%22Period Ending"),"""data"" : [ ","]"),1,"}"),2,","),": ","~"),"""","""")
>> =smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period Ending"),"""data"" : [ ","]"),1,"}"),2,","),": ","~"),"""","""")
#VALUE!
>> Are you able to access this web page:
http://www.zacks.com/stock/research/MMM/earnings-announcements
Yes
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, December 19, 2013 10:45:22 AM
Subject: Re: [smf_addin] SMF-Template-Zacks-Earnings-Announcements.xls from work in progress folder
What version of EXCEL do you have? And what do you get for:
=RCHGetElementNumber("MMM";,1290)
=RCHGetElementNumber("Version")
=smfGetAParms(1290)
=smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period Ending"),"""data"" : [ ","]"),1,"}"),2,","),": ","~"),"""","""")
Are you able to access this web page:
http://www.zacks.com/stock/research/MMM/earnings-announcements
On Thu, Dec 19, 2013 at 8:24 AM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
>Hi Randy - when using SMF-Template-Zacks-Earnings-Announcements.xls from work in progress folder,
>I am getting "Error" on all cells. I installed SMF Add-In and downloaded all .txt files from that folder.
>
>> What version of EXCEL do you have?
2003
>> =RCHGetElementNumbe
Error
>> =RCHGetElementNumbe
Stock Market Functions add-in, Version 2.1.2013.10.
>> =smfGetAParms(
ZacksEA;Quarterly Earnings -- Reported Date -- 1;=smfstrExtr(
>> =smfstrExtr(
#VALUE!
>> Are you able to access this web page:
http://www.zacks.
Yes
Regards,
Jose L. Jacob
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Thursday, December 19, 2013 10:45:22 AM
Subject: Re: [smf_addin] SMF-Template-
What version of EXCEL do you have? And what do you get for:
=RCHGetElementNumbe
=RCHGetElementNumbe
=smfGetAParms(
=smfstrExtr(
Are you able to access this web page:
http://www.zacks.
On Thu, Dec 19, 2013 at 8:24 AM, Jacob Jose <pepecan47@yahoo.
>
>Hi Randy - when using SMF-Template-
>I am getting "Error" on all cells. I installed SMF Add-In and downloaded all .txt files from that folder.
>
Thu Dec 19, 2013 5:34 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That's the problem, since that is the definition of element 1290.
The basic extraction part of that formula:
=smfGetTagContent("
http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period
Ending")
...returns a string that is over 5000 characters long. I think that length
is a problem for EXCEL 2003.
Where do you get an error with the following cells (these are the
individual steps of the formula above):
B2: =smfGetTagContent("
http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period
Ending")
B3: =smfstrExtr(B2,"""data"" : [ ","]")
B4: =smfWord(","&B3,1,"}")
B5: =smfWord(B4,2,",")
B6: =smfstrExtr(B5,": ","~")
B7: =smfstrExtr(B6,"""","""")
I'm suspecting the B2 cell, since that is the long string result.
On Thu, Dec 19, 2013 at 2:38 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:
>
> >> =smfstrExtr(smfstrExtr(smfWord(smfWord(","&smfstrExtr(smfGetTagContent("
> http://www.zacks.com/stock/research/MMM/earnings-announcements","script",-1,"Period
> Ending"),"""data"" : [ ","]"),1,"}"),2,","),": ","~"),"""","""")
>
> #VALUE!
>
The basic extraction part of that formula:
=smfGetTagContent(
http://www.zacks.
Ending"
...returns a string that is over 5000 characters long. I think that length
is a problem for EXCEL 2003.
Where do you get an error with the following cells (these are the
individual steps of the formula above):
B2: =smfGetTagContent(
http://www.zacks.
Ending"
B3: =smfstrExtr(
B4: =smfWord("
B5: =smfWord(B4,
B6: =smfstrExtr(
B7: =smfstrExtr(
I'm suspecting the B2 cell, since that is the long string result.
On Thu, Dec 19, 2013 at 2:38 PM, Jacob Jose <pepecan47@yahoo.
>
> >> =smfstrExtr(
> http://www.zacks.
> Ending"
>
> #VALUE!
>
Thu Dec 19, 2013 1:23 pm (PST) . Posted by:
gphillipsuk
Hi, Is there a way to search and return the lowest closing price and date, look back period of -X days. Foe example, look through the last 30 days and return the lowest price in this period and the date it happened.
Thanks
Thu Dec 19, 2013 4:17 pm (PST) . Posted by:
"PC_BABE" cs.holdings
Use the yahoo price history and enter as an array for the number days you want. Here is a table Randy built
http://f1.grp.yahoofs.com/v2/fIyzUokO1faim-8X_nU6oXMdvVuot095ka6R64o5FIy8fGI-EBxJnqlvvxlbdMxYarExL3pV_BeOZL1TRuGYP_vl4CMRUuk5Tvch6hKadKWAGdUBEV7aagAXlxqG-zhyfoq-5fneLT3RXmKVmVYsJKnJX4WsfQtCiyxvBswH-VF2KaAKG07pgPYcosC8cSGH_yVLwpMhyeeEOrcSDe5F-ts/SMF-Template-Yahoo-Historical-Quotes.xls
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of gphillips@ntlworld.com
Sent: Thursday, December 19, 2013 4:24 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Lowest Price
Hi, Is there a way to search and return the lowest closing price and date, look back period of -X days. Foe example, look through the last 30 days and return the lowest price in this period and the date it happened.
Thanks
http://f1.grp.
From: smf_addin@yahoogrou
Sent: Thursday, December 19, 2013 4:24 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Lowest Price
Hi, Is there a way to search and return the lowest closing price and date, look back period of -X days. Foe example, look through the last 30 days and return the lowest price in this period and the date it happened.
Thanks
Thu Dec 19, 2013 5:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the smfPricesBetween() function.
On Thu, Dec 19, 2013 at 2:23 PM, <gphillips@ntlworld.com> wrote:
> Hi, Is there a way to search and return the lowest closing price and
> date, look back period of -X days. Foe example, look through the last 30
> days and return the lowest price in this period and the date it happened.
>
On Thu, Dec 19, 2013 at 2:23 PM, <gphillips@ntlworld.
> Hi, Is there a way to search and return the lowest closing price and
> date, look back period of -X days. Foe example, look through the last 30
> days and return the lowest price in this period and the date it happened.
>
Tidak ada komentar:
Posting Komentar