Rabu, 13 Maret 2013

[smf_addin] Digest Number 2543

15 New Messages

Digest #2543
1a
Re: C:\Program Files\SMF Add-In by "Ron Spruell" hashky
4a
Total Volume History by "iamruf" iamruf
4b
Re: Total Volume History by "Randy Harmelink" rharmelink
5a
Full Company Name by "iamruf" iamruf
5b
Re: Full Company Name by "Randy Harmelink" rharmelink
5c
Re: Full Company Name by "iamruf" iamruf
5d
Re: Full Company Name by "Randy Harmelink" rharmelink
5e
Re: Full Company Name by "Michael Thomas" thomas91112
6b
Re: =RCHGetElementNumber(Ticker, 13873) by "Randy Harmelink" rharmelink
7a
VBA and RCHGetYahooHistory by "kristian_dms" kristian_dms
7b
Re: VBA and RCHGetYahooHistory 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?
>>
>
>
>
>

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?
> >
>

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
>

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

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
>

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

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
>

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
> >
>

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
>

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

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.

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.
>

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

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
>

Tidak ada komentar:

Posting Komentar