15 New Messages
Digest #2543
3a
RCHGetElementNumber 13863 (company name) cutting off first 2 letters by "colinmmoors" colinmmoors
3b
Re: RCHGetElementNumber 13863 (company name) cutting off first 2 let by "Randy Harmelink" rharmelink
Messages
Wed Mar 13, 2013 5:29 am (PDT) . Posted by:
"Ron Spruell" hashky
I am making the transition to Windows 7, so I couldn't put it in the documented place. I will be using the same files in XP as Windows 7 for a while. I didn't want to have to fix links every time I switch OS.
>________________________________
> From: Randy Harmelink <rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Tuesday, March 12, 2013 11:15 AM
>Subject: Re: [smf_addin] C:\Program Files\SMF Add-In
>
>
>
>Ideally, I would say C:\SMF Add-in, since that is where I currently keep it. However, I didn't change the old documentation because the library currently has a mix of sources, and it would have required that everyone that had it in the old location also move it to the new location.
>
>No matter what the location, people eventually run into the location error, so it's best that they know how to fix it. Currently, the smfFixLinks macro should do the trick (other than protected worksheets). I use it all the time, and have it on a toolbar button.
>
>
>On Tue, Mar 12, 2013 at 7:06 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
>
>>
>>If you were updating the documentation for Vista/Windows 7/Windows 8, what would be the recommended place to store the Add-In?
>>
>
>
>
>
>________
> From: Randy Harmelink <rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Tuesday, March 12, 2013 11:15 AM
>Subject: Re: [smf_addin] C:\Program Files\SMF Add-In
>
>
>
>Ideally, I would say C:\SMF Add-in, since that is where I currently keep it. However, I didn't change the old documentation because the library currently has a mix of sources, and it would have required that everyone that had it in the old location also move it to the new location.
>
>No matter what the location, people eventually run into the location error, so it's best that they know how to fix it. Currently, the smfFixLinks macro should do the trick (other than protected worksheets). I use it all the time, and have it on a toolbar button.
>
>
>On Tue, Mar 12, 2013 at 7:06 AM, Ron Spruell <hashky@yahoo.
>
>
>>
>>If you were updating the documentation for Vista/Windows 7/Windows 8, what would be the recommended place to store the Add-In?
>>
>
>
>
>
Wed Mar 13, 2013 5:35 am (PDT) . Posted by:
"weekeewawa" weekeewawa
works perfectly!thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It would have been helpful to see some formula examples. You need to
> specify unique search strings, or use multiple search strings, to get to
> what you need to extract.
>
> I'll assume you're not using the formulas from the template in the files
> area, since they do differentiate between the two data items. The template
> uses these two formulas for the two different items:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/bs?s= "&Ticker,1,"Period
> Ending","Short/Current Long Term Debt",,,,"Add to Portfolio")
>
> =RCHGetTableCell("http://finance.yahoo.com/q/bs?s= "&Ticker,1,"Period
> Ending",">Long Term Debt",,,,"Add to Portfolio")
>
> On Wed, Mar 13, 2013 at 1:36 AM, weekeewawa <weekeewawa@...> wrote:
>
> > i have a problem while extracting 'Long Term Debt' from Yahoo Balance Sheet
> >
> > It shows the same results as 'Short/Current Long Term Debt' whereby the
> > result should defer
> >
> > any solution for it?
> >
>
--- In smf_addin@yahoogrou
>
> It would have been helpful to see some formula examples. You need to
> specify unique search strings, or use multiple search strings, to get to
> what you need to extract.
>
> I'll assume you're not using the formulas from the template in the files
> area, since they do differentiate between the two data items. The template
> uses these two formulas for the two different items:
>
> =RCHGetTableCell(
> Ending"
>
> =RCHGetTableCell(
> Ending"
>
> On Wed, Mar 13, 2013 at 1:36 AM, weekeewawa <weekeewawa@
>
> > i have a problem while extracting 'Long Term Debt' from Yahoo Balance Sheet
> >
> > It shows the same results as 'Short/Current Long Term Debt' whereby the
> > result should defer
> >
> > any solution for it?
> >
>
Wed Mar 13, 2013 8:59 am (PDT) . Posted by:
"colinmmoors" colinmmoors
i know there are other element numbers you can use to get mutual fund name (4811), but thought you should know that just recently element # 13863 is cutting off first 2 letters of fund description. thanks, Colin
Wed Mar 13, 2013 10:19 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's retrieving what Yahoo is displaying. :(
It's the title of a web page like this:
http://finance.yahoo.com/q?s=vfinx
...which currently has:
<title>VFINX: Summary for nguard Index Trust 500 Index Fu- Yahoo!
Finance</title>
On Wed, Mar 13, 2013 at 8:59 AM, colinmmoors <colinmmoors@yahoo.com > wrote:
> i know there are other element numbers you can use to get mutual fund name
> (4811), but thought you should know that just recently element # 13863 is
> cutting off first 2 letters of fund description. thanks, Colin
>
It's the title of a web page like this:
http://finance.
...which currently has:
<title>
Finance</
On Wed, Mar 13, 2013 at 8:59 AM, colinmmoors <colinmmoors@
> i know there are other element numbers you can use to get mutual fund name
> (4811), but thought you should know that just recently element # 13863 is
> cutting off first 2 letters of fund description. thanks, Colin
>
Wed Mar 13, 2013 11:00 am (PDT) . Posted by:
"iamruf" iamruf
Hi Randy,
Is it possible to get the Last 12 Months (Y-T-D) volume as a single number total for stocks - from anywhere reliable?
e.g. without having to Sum 250 days or 12 months data?
Thanks
Is it possible to get the Last 12 Months (Y-T-D) volume as a single number total for stocks - from anywhere reliable?
e.g. without having to Sum 250 days or 12 months data?
Thanks
Wed Mar 13, 2013 11:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not that I'm aware of...
On Wed, Mar 13, 2013 at 11:00 AM, iamruf <iamruf@yahoo.com > wrote:
> Hi Randy,
> Is it possible to get the Last 12 Months (Y-T-D) volume as a single number
> total for stocks - from anywhere reliable?
> e.g. without having to Sum 250 days or 12 months data?
> Thanks
>
On Wed, Mar 13, 2013 at 11:00 AM, iamruf <iamruf@yahoo.
> Hi Randy,
> Is it possible to get the Last 12 Months (Y-T-D) volume as a single number
> total for stocks - from anywhere reliable?
> e.g. without having to Sum 250 days or 12 months data?
> Thanks
>
Wed Mar 13, 2013 11:29 am (PDT) . Posted by:
"iamruf" iamruf
Hi Randy,
A full company name is presented on the Quotes page for Yahoo Finance / MSN Money.
Is it possible to download or grab this name?
Thanks
A full company name is presented on the Quotes page for Yahoo Finance / MSN Money.
Is it possible to download or grab this name?
Thanks
Wed Mar 13, 2013 12:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Something like:
=smfGetTagContent("http://finance.yahoo.com/q?s=GWW ","h2",-1,"(GWW)")
=smfStrExtr(smfGetTagContent("
http://investing.money.msn.com/investments/stock-price?Symbol=GWW ","title",1),"Quote
for ","-")
On Wed, Mar 13, 2013 at 11:29 AM, iamruf <iamruf@yahoo.com > wrote:
> Hi Randy,
> A full company name is presented on the Quotes page for Yahoo Finance /
> MSN Money.
> Is it possible to download or grab this name?
> Thanks
>
=smfGetTagContent(
=smfStrExtr(
http://investing.
for ","
On Wed, Mar 13, 2013 at 11:29 AM, iamruf <iamruf@yahoo.
> Hi Randy,
> A full company name is presented on the Quotes page for Yahoo Finance /
> MSN Money.
> Is it possible to download or grab this name?
> Thanks
>
Wed Mar 13, 2013 2:38 pm (PDT) . Posted by:
"iamruf" iamruf
Great - is there a way of grabbing cell A2 within the formula (containing symbol GWW)?
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Something like:
>
> =smfGetTagContent("http://finance.yahoo.com/q?s=GWW ","h2",-1,"(GWW)")
>
> =smfStrExtr(smfGetTagContent("
> http://investing.money.msn.com/investments/stock-price?Symbol=GWW ","title",1),"Quote
> for ","-")
>
> On Wed, Mar 13, 2013 at 11:29 AM, iamruf <iamruf@...> wrote:
>
> > Hi Randy,
> > A full company name is presented on the Quotes page for Yahoo Finance /
> > MSN Money.
> > Is it possible to download or grab this name?
> > Thanks
> >
>
Thanks
--- In smf_addin@yahoogrou
>
> Something like:
>
> =smfGetTagContent(
>
> =smfStrExtr(
> http://investing.
> for ","
>
> On Wed, Mar 13, 2013 at 11:29 AM, iamruf <iamruf@.
>
> > Hi Randy,
> > A full company name is presented on the Quotes page for Yahoo Finance /
> > MSN Money.
> > Is it possible to download or grab this name?
> > Thanks
> >
>
Wed Mar 13, 2013 6:27 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just the normal EXCEL concatenation process. For example:
="...string1..."&A2
=A2&"...string1..."
="...string1..."&A2&"...string2..."
On Wed, Mar 13, 2013 at 2:38 PM, iamruf <iamruf@yahoo.com > wrote:
> Great - is there a way of grabbing cell A2 within the formula (containing
> symbol GWW)?
> Thanks
>
="...string1.
=A2&"
="...string1.
On Wed, Mar 13, 2013 at 2:38 PM, iamruf <iamruf@yahoo.
> Great - is there a way of grabbing cell A2 within the formula (containing
> symbol GWW)?
> Thanks
>
Wed Mar 13, 2013 7:04 pm (PDT) . Posted by:
"Michael Thomas" thomas91112
What? Please extrapolate for us neophytes...maybe restating the formula would be clearer.Randy, you provide a tremendous service to us all.
ThanksMike
--- On Wed, 3/13/13, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Re: Full Company Name
To: smf_addin@yahoogroups.com
Date: Wednesday, March 13, 2013, 6:27 PM
Just the normal EXCEL concatenation process. For example:
="...string1..."&A2
=A2&"...string1..."
="...string1..."&A2&"...string2..."
On Wed, Mar 13, 2013 at 2:38 PM, iamruf <iamruf@yahoo.com > wrote:
Great - is there a way of grabbing cell A2 within the formula (containing symbol GWW)?
Thanks
ThanksMike
--- On Wed, 3/13/13, Randy Harmelink <rharmelink@gmail.
From: Randy Harmelink <rharmelink@gmail.
Subject: Re: [smf_addin] Re: Full Company Name
To: smf_addin@yahoogrou
Date: Wednesday, March 13, 2013, 6:27 PM
Just the normal EXCEL concatenation process. For example:
="...string1.
=A2&"
="...string1.
On Wed, Mar 13, 2013 at 2:38 PM, iamruf <iamruf@yahoo.
Great - is there a way of grabbing cell A2 within the formula (containing symbol GWW)?
Thanks
Wed Mar 13, 2013 5:51 pm (PDT) . Posted by:
"andyha8" andyha8
Hey Randy, hope you're having a good day.
When I punch in GMCR into the SMF-Template-Zacks-Data.xls, I just get "strong", like not "strong buy" or "strong sell", just the one word "strong".
I guess I can figure out if it's a buy or sell from other info as in if it's a rank 1 then it must be a buy but just thought I would bring it to your attention.
When I punch in GMCR into the SMF-Template-
I guess I can figure out if it's a buy or sell from other info as in if it's a rank 1 then it must be a buy but just thought I would bring it to your attention.
Wed Mar 13, 2013 6:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Thanks. I've fixed the element definition, from:
Zacks;Zacks Recommendation;=smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/~~~~~/detailed-estimates ","p",-1,"Zacks
Rank:"),"-"," ")
....to:
Zacks;Zacks Recommendation;=smfStrExtr(smfGetTagContent("
http://www.zacks.com/stock/quote/~~~~~/detailed-estimates ","p",-1,"Zacks
Rank:"),"-","<")
(Just changing that last string from " " to "<", to mark the end of the
recommendation. When I did my testing, I must have had all single-word
recommendations.
On Wed, Mar 13, 2013 at 5:51 PM, andyha8 <andyha8@gmail.com > wrote:
> Hey Randy, hope you're having a good day.
>
> When I punch in GMCR into the SMF-Template-Zacks-Data.xls, I just get
> "strong", like not "strong buy" or "strong sell", just the one word
> "strong".
>
> I guess I can figure out if it's a buy or sell from other info as in if
> it's a rank 1 then it must be a buy but just thought I would bring it to
> your attention.
>
Zacks;Zacks Recommendation;
http://www.zacks.
Rank:")
....to:
Zacks;Zacks Recommendation;
http://www.zacks.
Rank:")
(Just changing that last string from " " to "<"
recommendation. When I did my testing, I must have had all single-word
recommendations.
On Wed, Mar 13, 2013 at 5:51 PM, andyha8 <andyha8@gmail.
> Hey Randy, hope you're having a good day.
>
> When I punch in GMCR into the SMF-Template-
> "strong"
> "strong"
>
> I guess I can figure out if it's a buy or sell from other info as in if
> it's a rank 1 then it must be a buy but just thought I would bring it to
> your attention.
>
Wed Mar 13, 2013 6:24 pm (PDT) . Posted by:
"kristian_dms" kristian_dms
So i've been setting up a VBA sheet trying to use SMF_addin to fetch
historical data for a quantitive analysis and this bit of code keeps
bugging me
' sorry - coulden't find the "codebox" option.
Sub FetchPrice()
dim Fetch as StringNumAssets = Worksheets("V").Cells(4, 1)
For p = 1 To 50
If Worksheets("V").Cells(5 + p, 1) <= DateSerial(Year(Now), Month(Now),
Day(Now)) ThenFetch = "=RCHGetYahooHistory(R1C[(3*p)-1] , YEAR(R1C(5+p))
, MONTH(R1C(5+p)) , DAY(R1C(5+p)) , YEAR(R1C(5+p)) , MONTH(R1C(5+p)) ,
DAY(R1C(5+p)) , m , O , 0 , 0 , 1) / 100"Worksheets("V").Cells(5 + p,
1).FormulaR1C1 = Fetch
End IfNext p
End Sub
I get a "application-defined or object-defined error" on the line i put
in italics. I cant seem to figure out what i am doing wrong.
Thank you
historical data for a quantitive analysis and this bit of code keeps
bugging me
' sorry - coulden'
Sub FetchPrice()
dim Fetch as StringNumAssets = Worksheets("
For p = 1 To 50
If Worksheets("
Day(Now)) ThenFetch = "=RCHGetYahooH
, MONTH(R1C(5+
DAY(R1C(5+p)
1).FormulaR1C1 = Fetch
End IfNext p
End Sub
I get a "application-
in italics. I cant seem to figure out what i am doing wrong.
Thank you
Wed Mar 13, 2013 6:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I never use R1C processing, so that means nothing to me.
Well, I doubt you will have defined range names of "p", "m", and "O" in
your workbook, The variable Fetch will be undefined (or have the previous
definition) if it the IF statement isn't satisfied. Specifying the same
beginning and ending date to the function will NOT give you any type of
"monthly" data. I'm not sure why you divide by 100?
I'm not thrilled with seeing 50 potential data retrievals from Yahoo, when
you should only be doing one to get the array in the first place.
Can you give me an overview of what you're trying to do?
On Wed, Mar 13, 2013 at 2:54 PM, kristian_dms <thorup.dk@gmail.com > wrote:
>
> So i've been setting up a VBA sheet trying to use SMF_addin to fetch
> historical data for a quantitive analysis and this bit of code keeps
> bugging me
>
> ' sorry - coulden't find the "codebox" option.
>
> Sub FetchPrice()
>
> dim Fetch as String
> NumAssets = Worksheets("V").Cells(4, 1)
>
> For p = 1 To 50
>
> If Worksheets("V").Cells(5 + p, 1) <= DateSerial(Year(Now), Month(Now),
> Day(Now)) Then
> Fetch = "=RCHGetYahooHistory(R1C[(3*p)-1] , YEAR(R1C(5+p)) ,
> MONTH(R1C(5+p)) , DAY(R1C(5+p)) , YEAR(R1C(5+p)) , MONTH(R1C(5+p)) ,
> DAY(R1C(5+p)) , m , O , 0 , 0 , 1) / 100"
> *Worksheets("V").Cells(5 + p, 1).FormulaR1C1 = Fetch*
>
> End If
> Next p
>
> End Sub
>
> I get a "application-defined or object-defined error" on the line i put in
> italics. I cant seem to figure out what i am doing wrong.
>
> Thank you
>
Well, I doubt you will have defined range names of "p"
your workbook, The variable Fetch will be undefined (or have the previous
definition) if it the IF statement isn't satisfied. Specifying the same
beginning and ending date to the function will NOT give you any type of
"monthly" data. I'm not sure why you divide by 100?
I'm not thrilled with seeing 50 potential data retrievals from Yahoo, when
you should only be doing one to get the array in the first place.
Can you give me an overview of what you're trying to do?
On Wed, Mar 13, 2013 at 2:54 PM, kristian_dms <thorup.dk@gmail.
>
> So i've been setting up a VBA sheet trying to use SMF_addin to fetch
> historical data for a quantitive analysis and this bit of code keeps
> bugging me
>
> ' sorry - coulden'
>
> Sub FetchPrice()
>
> dim Fetch as String
> NumAssets = Worksheets("
>
> For p = 1 To 50
>
> If Worksheets("
> Day(Now)) Then
> Fetch = "=RCHGetYahooH
> MONTH(R1C(5+
> DAY(R1C(5+p)
> *Worksheets(
>
> End If
> Next p
>
> End Sub
>
> I get a "application-
> italics. I cant seem to figure out what i am doing wrong.
>
> Thank you
>
Tidak ada komentar:
Posting Komentar