13 New Messages
Digest #2550
Messages
Sun Mar 17, 2013 5:42 am (PDT) . Posted by:
"Jovica Bozic" jovica.bozic
If someone could help me to isolate smfGetTagContent function so that Excel file could function without addin (standalone smfGetTagContent file). I've copied all necessary functions into VBA, but when I try to use smfGetTagContent I get error in smfConvertData line in smfGetTagContent function even if smfConvertData function is also in VBA.
Sun Mar 17, 2013 8:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Here's what I did:
1. Exported the modCovertData, modUtilities, and modGetTagContent
modules from the add-in.
2. Open a new workbook
3. Imported those three exported modules into the VBA environment for
the new workbook
4. Added references for the Visual Basic for Applications and Microsoft
XML libraries
From there, it appeared to work...
On Sun, Mar 17, 2013 at 5:42 AM, Jovica Bozic <jovica.bozic@yahoo.com >wrote:
> If someone could help me to isolate smfGetTagContent function so that
> Excel file could function without addin (standalone smfGetTagContent file).
> I've copied all necessary functions into VBA, but when I try to use
> smfGetTagContent I get error in smfConvertData line in smfGetTagContent
> function even if smfConvertData function is also in VBA.
>
1. Exported the modCovertData, modUtilities, and modGetTagContent
modules from the add-in.
2. Open a new workbook
3. Imported those three exported modules into the VBA environment for
the new workbook
4. Added references for the Visual Basic for Applications and Microsoft
XML libraries
From there, it appeared to work...
On Sun, Mar 17, 2013 at 5:42 AM, Jovica Bozic <jovica.bozic@
> If someone could help me to isolate smfGetTagContent function so that
> Excel file could function without addin (standalone smfGetTagContent file).
> I've copied all necessary functions into VBA, but when I try to use
> smfGetTagContent I get error in smfConvertData line in smfGetTagContent
> function even if smfConvertData function is also in VBA.
>
Sun Mar 17, 2013 9:06 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I am not able to change the links on several workbooks
__._,_ SMF-Template-Zacks-Data
.___
<http://geo.yahoo.com/serv?s=97476590/grpId=18094620/grpspId=1705632198/msgId=21750/stime=1363534102 > SMF-Template-Earnings.com-Data
Plus others
Some I can change
SMF-Template-Reuters-Ratios-Comparison
Any clue why that is happening?
Kermit
__._,_ SMF-Template-
.___
<http://geo.yahoo.
Plus others
Some I can change
SMF-Template-
Any clue why that is happening?
Kermit
Sun Mar 17, 2013 9:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You probably need to unprotect the worksheets?
On Sun, Mar 17, 2013 at 9:05 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> I am not able to change the links on several workbooks****
>
> ** **
>
> __._,_ SMF-Template-Zacks-Data****
>
> .___****
>
> SMF-Template-Earnings.com-Data****
>
> ** **
>
> Plus others****
>
> ** **
>
> Some I can change ****
>
> ** **
>
> SMF-Template-Reuters-Ratios-Comparison****
>
> ** **
>
> Any clue why that is happening?****
>
>
>
On Sun, Mar 17, 2013 at 9:05 AM, Kermit W. Prather
<kermitp@tampabay.
>
> I am not able to change the links on several workbooks***
>
> ** **
>
> __._,_ SMF-Template-
>
> .___****
>
> SMF-Template-
>
> ** **
>
> Plus others****
>
> ** **
>
> Some I can change ****
>
> ** **
>
> SMF-Template-
>
> ** **
>
> Any clue why that is happening?**
>
>
>
Sun Mar 17, 2013 1:23 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
That was it. It is a mystery how it got protected
Thanks
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Sunday, March 17, 2013 12:07 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Can't change links on several workbooks
You probably need to unprotect the worksheets?
On Sun, Mar 17, 2013 at 9:05 AM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
I am not able to change the links on several workbooks
__._,_ SMF-Template-Zacks-Data
.___
SMF-Template-Earnings.com-Data
Plus others
Some I can change
SMF-Template-Reuters-Ratios-Comparison
Any clue why that is happening?
Thanks
From: smf_addin@yahoogrou
Sent: Sunday, March 17, 2013 12:07 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Can't change links on several workbooks
You probably need to unprotect the worksheets?
On Sun, Mar 17, 2013 at 9:05 AM, Kermit W. Prather <kermitp@tampabay.
I am not able to change the links on several workbooks
__._,_ SMF-Template-
.___
SMF-Template-
Plus others
Some I can change
SMF-Template-
Any clue why that is happening?
Sun Mar 17, 2013 8:54 am (PDT) . Posted by:
"ufdn16" ufdn16
Is there a definition for historical highs and lows for each year going back 5 to 10 years. Didn't see any reference to this in the element file. Thanks , David
Sun Mar 17, 2013 9:04 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't know of any source that carries it.
You'd need to retrieve the historical quotes using RCHGetYahooHistory() and
then derive the values yourself.
On Sun, Mar 17, 2013 at 8:54 AM, ufdn16 <ufdn16@yahoo.com > wrote:
> Is there a definition for historical highs and lows for each year going
> back 5 to 10 years. Didn't see any reference to this in the element file.
> Thanks , David
>
You'd need to retrieve the historical quotes using RCHGetYahooHistory(
then derive the values yourself.
On Sun, Mar 17, 2013 at 8:54 AM, ufdn16 <ufdn16@yahoo.
> Is there a definition for historical highs and lows for each year going
> back 5 to 10 years. Didn't see any reference to this in the element file.
> Thanks , David
>
Sun Mar 17, 2013 10:35 am (PDT) . Posted by:
"jtravisano2002" jtravisano2002
Hello,
Is there a way to download historical S&P sector data(daily or monthly) ? For instance one of the sectors is Radio Broadcasting, can I get the daily(or month end) value for this sector for each month? If yes, how far back does the data go?
Thank you,
Jake
Is there a way to download historical S&P sector data(daily or monthly) ? For instance one of the sectors is Radio Broadcasting, can I get the daily(or month end) value for this sector for each month? If yes, how far back does the data go?
Thank you,
Jake
Sun Mar 17, 2013 10:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You're talking about an industry group, not a sector.
Yahoo doesn't carry historical quotes on industry groups, but they do have
current quotes. For example:
=RCHGetYahooQuotes("^YHOh829","l1")
The list of available industry groups on Yahoo:
http://biz.yahoo.com/ic/ind_index.html
BarChart might be a better source:
http://www.barchart.com/stocks/sectors/
It looks like you could use the
RCHGetWebData-Template-BarChart-Quotes-Extract.xls workbook to get
historical quotes from there...
On Sun, Mar 17, 2013 at 10:35 AM, jtravisano2002
<jacob.travisano@gmail.com >wrote:
>
> Is there a way to download historical S&P sector data(daily or monthly)
> ? For instance one of the sectors is Radio Broadcasting, can I get the
> daily(or month end) value for this sector for each month? If yes, how far
> back does the data go?
>
Yahoo doesn't carry historical quotes on industry groups, but they do have
current quotes. For example:
=RCHGetYahooQuotes(
The list of available industry groups on Yahoo:
http://biz.yahoo.
BarChart might be a better source:
http://www.barchart
It looks like you could use the
RCHGetWebData-
historical quotes from there...
On Sun, Mar 17, 2013 at 10:35 AM, jtravisano2002
<jacob.travisano@
>
> Is there a way to download historical S&P sector data(daily or monthly)
> ? For instance one of the sectors is Radio Broadcasting, can I get the
> daily(or month end) value for this sector for each month? If yes, how far
> back does the data go?
>
Sun Mar 17, 2013 7:17 pm (PDT) . Posted by:
"souloflineage" souloflineage
Hi,
I have been back testing several screens. For the historical period I am testing I consistently come across stocks that either exist at begining of the test period and not at the end or did not exist at the begining but exists at the end of the test period. Is there any way or function that would find initial data and price and final date and price?
Thanks.
I have been back testing several screens. For the historical period I am testing I consistently come across stocks that either exist at begining of the test period and not at the end or did not exist at the begining but exists at the end of the test period. Is there any way or function that would find initial data and price and final date and price?
Thanks.
Sun Mar 17, 2013 7:58 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Something like this should do it, array-entered over 2 columns and 1 row:
=RCHGetYahooHistory("MMM",,,,,,,,"DA",0,,1,32767,2)
=RCHGetYahooHistory("MMM",,,,,,,,"DA",0)
On Sun, Mar 17, 2013 at 7:11 PM, souloflineage <souloflineage@yahoo.com >wrote:
> I have been back testing several screens. For the historical period I am
> testing I consistently come across stocks that either exist at begining of
> the test period and not at the end or did not exist at the begining but
> exists at the end of the test period. Is there any way or function that
> would find initial data and price and final date and price?
>
=RCHGetYahooHistory
=RCHGetYahooHistory
On Sun, Mar 17, 2013 at 7:11 PM, souloflineage <souloflineage@
> I have been back testing several screens. For the historical period I am
> testing I consistently come across stocks that either exist at begining of
> the test period and not at the end or did not exist at the begining but
> exists at the end of the test period. Is there any way or function that
> would find initial data and price and final date and price?
>
Sun Mar 17, 2013 11:07 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hi
what i mean is the element number in the text file in the work in progress folder is the same as the RCHGetElementNumber() Element Definitions as of 2012-02-12 in the latest smf add in download zip file
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm not sure what you're asking?
>
> On Sat, Mar 16, 2013 at 8:12 PM, weekeewawa <weekeewawa@...> wrote:
>
> > hi randy, it seems the text file smf-elements-5 in the work in progress
> > folder shows the element number to be 13774-13777 for effective tax rate 5
> > year average as well even though i think u uploaded it as recent as ytd?
> >
>
what i mean is the element number in the text file in the work in progress folder is the same as the RCHGetElementNumber
--- In smf_addin@yahoogrou
>
> I'm not sure what you're asking?
>
> On Sat, Mar 16, 2013 at 8:12 PM, weekeewawa <weekeewawa@
>
> > hi randy, it seems the text file smf-elements-
> > folder shows the element number to be 13774-13777 for effective tax rate 5
> > year average as well even though i think u uploaded it as recent as ytd?
> >
>
Sun Mar 17, 2013 11:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yeah. I didn't change the element number. Just the definition of it. The
workbook that lists the element numbers and their description doesn't
contain the element definitions. It just lists the elements.
On Sun, Mar 17, 2013 at 11:07 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> what i mean is the element number in the text file in the work in progress
> folder is the same as the RCHGetElementNumber() Element Definitions as of
> 2012-02-12 in the latest smf add in download zip file
>
workbook that lists the element numbers and their description doesn't
contain the element definitions. It just lists the elements.
On Sun, Mar 17, 2013 at 11:07 PM, weekeewawa <weekeewawa@yahoo.
>
> what i mean is the element number in the text file in the work in progress
> folder is the same as the RCHGetElementNumber
> 2012-02-12 in the latest smf add in download zip file
>
Tidak ada komentar:
Posting Komentar