Sabtu, 14 Juli 2012

[smf_addin] Digest Number 2278

15 New Messages

Digest #2278
1a
1b
Re: Just want to get a single stock quote by "Randy Harmelink" rharmelink
1c
1e
1f
Re: Just want to get a single stock quote by "Randy Harmelink" rharmelink
1h
Re: Just want to get a single stock quote by "Randy Harmelink" rharmelink

Messages

Sat Jul 14, 2012 6:58 am (PDT) . Posted by:

"timbabear" timbabear

I've been using your smf add-in for years and absolutely LOVE it. A couple of months back it stopped giving me the current quote (I was drawing it from Yahoo Finance).

Here is the line command I have in place:
=RCHGetElementNumber(Ticker,25)

I like working with numbers but somehow my eyes glaze over when something new happens with this application. I've been sporadically trying for several months to correct the problem, but I just surrendered and decided I have to ask for help.

Would you be so kind as to provide me with the element number that Yahoo quote has changed to or provide me with a line code for a quote from somewhere else that does the same thing?

Thank You

Sat Jul 14, 2012 7:17 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should use the RCHGetYahooQuotes() function.

However, element #25 stopped working because MSN overhauled their website
and I had to redefine all of the MSN elements. To update, you need:

See: http://finance.groups.yahoo.com/group/smf_addin/message/18529

Best practice:

1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file folder
with the newer downloaded version
4. Restart EXCEL

But note that the price that MSN is now posting for "Last Price" is
actually the previous day's closing price. So although element #25 should
give you a number after you update the element definitions, it probably
won't be the number you're interested in seeing.

On Sat, Jul 14, 2012 at 6:57 AM, timbabear <ddoyle3@tampabay.rr.com> wrote:

> I've been using your smf add-in for years and absolutely LOVE it. A
> couple of months back it stopped giving me the current quote (I was drawing
> it from Yahoo Finance).
>
> Here is the line command I have in place:
> =RCHGetElementNumber(Ticker,25)
>
> I like working with numbers but somehow my eyes glaze over when something
> new happens with this application. I've been sporadically trying for
> several months to correct the problem, but I just surrendered and decided I
> have to ask for help.
>
> Would you be so kind as to provide me with the element number that Yahoo
> quote has changed to or provide me with a line code for a quote from
> somewhere else that does the same thing?
>

Sat Jul 14, 2012 7:33 am (PDT) . Posted by:

"Peter Urbani" purbani1

Hi Randy

Thanks again for your fantastic add-in. It occurs to me that the constant
changes by Yahoo, MSN et al keep you pretty busy. Given that the user has
to be online to use the add-in would it not help speed user updating if the
lists of item numbers were hosted online somewhere and the add-in referred
to them there rather than locally. This way you would not have to answer
multiple requests for fixes you have already undertaken and could
potentially share the workload of maintaining the lists with either the
vendors themselves or some other trusted site experts.

Just my 2 cents worth

Thanks again

Peter

On Sun, Jul 15, 2012 at 2:17 AM, Randy Harmelink <rharmelink@gmail.com>wrote:

> **
>
>
> You should use the RCHGetYahooQuotes() function.
>
> However, element #25 stopped working because MSN overhauled their website
> and I had to redefine all of the MSN elements. To update, you need:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> But note that the price that MSN is now posting for "Last Price" is
> actually the previous day's closing price. So although element #25 should
> give you a number after you update the element definitions, it probably
> won't be the number you're interested in seeing.
>
> On Sat, Jul 14, 2012 at 6:57 AM, timbabear <ddoyle3@tampabay.rr.com>wrote:
>
>> I've been using your smf add-in for years and absolutely LOVE it. A
>> couple of months back it stopped giving me the current quote (I was drawing
>> it from Yahoo Finance).
>>
>> Here is the line command I have in place:
>> =RCHGetElementNumber(Ticker,25)
>>
>> I like working with numbers but somehow my eyes glaze over when something
>> new happens with this application. I've been sporadically trying for
>> several months to correct the problem, but I just surrendered and decided I
>> have to ask for help.
>>
>> Would you be so kind as to provide me with the element number that Yahoo
>> quote has changed to or provide me with a line code for a quote from
>> somewhere else that does the same thing?
>>
>
>
>

--

*Peter Urbani*

+64 21 0255 2816

LinkedIn Profile <http://nz.linkedin.com/in/peterurbani>

Skype peterurbani

Sat Jul 14, 2012 8:55 am (PDT) . Posted by:

"Randy H" rharmelink



I think it's a great idea. But when I've looked into in the past, I never found a good workable place to host the files.

--- In smf_addin@yahoogroups.com, Peter Urbani <peter.urbani@...> wrote:
>
> Thanks again for your fantastic add-in. It occurs to me that the constant
> changes by Yahoo, MSN et al keep you pretty busy. Given that the user has
> to be online to use the add-in would it not help speed user updating if the
> lists of item numbers were hosted online somewhere and the add-in referred
> to them there rather than locally. This way you would not have to answer
> multiple requests for fixes you have already undertaken and could
> potentially share the workload of maintaining the lists with either the
> vendors themselves or some other trusted site experts.
>
> Just my 2 cents worth

Sat Jul 14, 2012 9:11 am (PDT) . Posted by:

"Peter Urbani" purbani1

Pretty sure it can be done with Skydrive now have seen a couple of bloggers
giving direct password free public access that way. Not sure about Dropbox
or Google.

On Sunday, July 15, 2012, Randy H <rharmelink@gmail.com> wrote:
>
>
> I think it's a great idea. But when I've looked into in the past, I never
found a good workable place to host the files.
>
> --- In smf_addin@yahoogroups.com, Peter Urbani <peter.urbani@...> wrote:
>>
>> Thanks again for your fantastic add-in. It occurs to me that the constant
>> changes by Yahoo, MSN et al keep you pretty busy. Given that the user has
>> to be online to use the add-in would it not help speed user updating if
the
>> lists of item numbers were hosted online somewhere and the add-in
referred
>> to them there rather than locally. This way you would not have to answer
>> multiple requests for fixes you have already undertaken and could
>> potentially share the workload of maintaining the lists with either the
>> vendors themselves or some other trusted site experts.
>>
>> Just my 2 cents worth
>
>

--

*Peter Urbani*

+64 21 0255 2816

LinkedIn Profile <http://nz.linkedin.com/in/peterurbani>

Skype peterurbani

Sat Jul 14, 2012 9:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The problem I get is that I don't see a way to READ the file from those
locations. All of the "share" URLs are for enabling DOWNLOADING of the
file, not a direct READ of the file.

On Sat, Jul 14, 2012 at 9:11 AM, Peter Urbani <peter.urbani@gmail.com>wrote:

>
> Pretty sure it can be done with Skydrive now have seen a couple of
> bloggers giving direct password free public access that way. Not sure about
> Dropbox or Google.
>

Sat Jul 14, 2012 9:30 am (PDT) . Posted by:

"timbabear" timbabear

Randy

I believe I have downloaded all of the updated files, several times.

I changed the formula is the cell to the =RCHGetYahooQuotes(ticker,25) and now instead of "error" I get a blank field.

In the original (many years ago now) instructions, I was supposed to create an smf add-in file within my Program folder in Windows Explorer, sometime after that I read where you (or someone here, my memory is poor) recommended some changes and didn't want a conflict so now I have a separate folder called smf=add-in that is outside of the Program folder and the original folder has been removed at some point.

I'm not sure if any of this is pertinent as my workbook that uses this is 10 worksheets long and most of them populate just fine, so I figure Excel must be finding the instruction set just fine.

Just don't know how to resolve the "simple" things. I'll settle for closing price, the difference for how I use the data isn't enough for it to matter that much but I need one of them.

I know this is minor league compared to what you're handling for others, but I don't know where else to turn.

Thanks again,

Tim

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You should use the RCHGetYahooQuotes() function.
>
> However, element #25 stopped working because MSN overhauled their website
> and I had to redefine all of the MSN elements. To update, you need:
>
> See: http://finance.groups.yahoo.com/group/smf_addin/message/18529
>
> Best practice:
>
> 1. Exit EXCEL
> 2. Download the new version of the element definition file
> 3. Replace the older version of this file in your add-in's file folder
> with the newer downloaded version
> 4. Restart EXCEL
>
> But note that the price that MSN is now posting for "Last Price" is
> actually the previous day's closing price. So although element #25 should
> give you a number after you update the element definitions, it probably
> won't be the number you're interested in seeing.
>
> On Sat, Jul 14, 2012 at 6:57 AM, timbabear <ddoyle3@...> wrote:
>
> > I've been using your smf add-in for years and absolutely LOVE it. A
> > couple of months back it stopped giving me the current quote (I was drawing
> > it from Yahoo Finance).
> >
> > Here is the line command I have in place:
> > =RCHGetElementNumber(Ticker,25)
> >
> > I like working with numbers but somehow my eyes glaze over when something
> > new happens with this application. I've been sporadically trying for
> > several months to correct the problem, but I just surrendered and decided I
> > have to ask for help.
> >
> > Would you be so kind as to provide me with the element number that Yahoo
> > quote has changed to or provide me with a line code for a quote from
> > somewhere else that does the same thing?
> >
>

Sat Jul 14, 2012 9:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooQuotes() uses Yahoo codes assigned by Yahoo, not my element
numbers. You can check the documentation of the function for the Yahoo
codes I'm aware of. And, the documentation has examples of using the
function. In this case, you want the "l1" Yahoo code, so:

=RCHGetYahooQuotes(Ticker,"l1")

On Sat, Jul 14, 2012 at 9:30 AM, timbabear <ddoyle3@tampabay.rr.com> wrote:

> Randy
>
> I believe I have downloaded all of the updated files, several times.
>
> I changed the formula is the cell to the =RCHGetYahooQuotes(ticker,25) and
> now instead of "error" I get a blank field.
>
> In the original (many years ago now) instructions, I was supposed to
> create an smf add-in file within my Program folder in Windows Explorer,
> sometime after that I read where you (or someone here, my memory is poor)
> recommended some changes and didn't want a conflict so now I have a
> separate folder called smf=add-in that is outside of the Program folder and
> the original folder has been removed at some point.
>
> I'm not sure if any of this is pertinent as my workbook that uses this is
> 10 worksheets long and most of them populate just fine, so I figure Excel
> must be finding the instruction set just fine.
>
> Just don't know how to resolve the "simple" things. I'll settle for
> closing price, the difference for how I use the data isn't enough for it to
> matter that much but I need one of them.
>
> I know this is minor league compared to what you're handling for others,
> but I don't know where else to turn.
>

Sat Jul 14, 2012 10:26 am (PDT) . Posted by:

"timbabear" timbabear

Hi Randy

That didn't work either, so I guess I'll have to take a break for a while and replenish my creative juices.

I appreciate your selfless dedication to this project, I wouldn't have done nearly the research I've been able to do without this program.

Tim

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> RCHGetYahooQuotes() uses Yahoo codes assigned by Yahoo, not my element
> numbers. You can check the documentation of the function for the Yahoo
> codes I'm aware of. And, the documentation has examples of using the
> function. In this case, you want the "l1" Yahoo code, so:
>
> =RCHGetYahooQuotes(Ticker,"l1")
>
> On Sat, Jul 14, 2012 at 9:30 AM, timbabear <ddoyle3@...> wrote:
>
> > Randy
> >
> > I believe I have downloaded all of the updated files, several times.
> >
> > I changed the formula is the cell to the =RCHGetYahooQuotes(ticker,25) and
> > now instead of "error" I get a blank field.
> >
> > In the original (many years ago now) instructions, I was supposed to
> > create an smf add-in file within my Program folder in Windows Explorer,
> > sometime after that I read where you (or someone here, my memory is poor)
> > recommended some changes and didn't want a conflict so now I have a
> > separate folder called smf=add-in that is outside of the Program folder and
> > the original folder has been removed at some point.
> >
> > I'm not sure if any of this is pertinent as my workbook that uses this is
> > 10 worksheets long and most of them populate just fine, so I figure Excel
> > must be finding the instruction set just fine.
> >
> > Just don't know how to resolve the "simple" things. I'll settle for
> > closing price, the difference for how I use the data isn't enough for it to
> > matter that much but I need one of them.
> >
> > I know this is minor league compared to what you're handling for others,
> > but I don't know where else to turn.
> >
>

Sat Jul 14, 2012 1:02 pm (PDT) . Posted by:

"timbabear" timbabear

Hi Randy

When I tried to type in your recommendation, it wouldn't work, I'd just get a blank field.

So, after fuming at myself for a while for being so thick-headed about this stuff, I decided that I would just try to copy and paste your suggestion. [I know, it shouldn't make a difference] but SHEZAM, it worked!!!

I'm not going to look a gift horse in the mouth, just going to tip-toe on down the street and not wonder why it works!

Thanks again for being patient and for giving all that you do.

Tim

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> RCHGetYahooQuotes() uses Yahoo codes assigned by Yahoo, not my element
> numbers. You can check the documentation of the function for the Yahoo
> codes I'm aware of. And, the documentation has examples of using the
> function. In this case, you want the "l1" Yahoo code, so:
>
> =RCHGetYahooQuotes(Ticker,"l1")
>
> On Sat, Jul 14, 2012 at 9:30 AM, timbabear <ddoyle3@...> wrote:
>
> > Randy
> >
> > I believe I have downloaded all of the updated files, several times.
> >
> > I changed the formula is the cell to the =RCHGetYahooQuotes(ticker,25) and
> > now instead of "error" I get a blank field.
> >
> > In the original (many years ago now) instructions, I was supposed to
> > create an smf add-in file within my Program folder in Windows Explorer,
> > sometime after that I read where you (or someone here, my memory is poor)
> > recommended some changes and didn't want a conflict so now I have a
> > separate folder called smf=add-in that is outside of the Program folder and
> > the original folder has been removed at some point.
> >
> > I'm not sure if any of this is pertinent as my workbook that uses this is
> > 10 worksheets long and most of them populate just fine, so I figure Excel
> > must be finding the instruction set just fine.
> >
> > Just don't know how to resolve the "simple" things. I'll settle for
> > closing price, the difference for how I use the data isn't enough for it to
> > matter that much but I need one of them.
> >
> > I know this is minor league compared to what you're handling for others,
> > but I don't know where else to turn.
> >
>

Sat Jul 14, 2012 8:02 am (PDT) . Posted by:

"timbabear" timbabear

I've been using your smf add-in for years and absolutely LOVE it. A couple of months back it stopped giving me the current quote (I was drawing it from Yahoo Finance).

Here is the line command I have in place:
=RCHGetElementNumber(Ticker,25)

I like working with numbers but somehow my eyes glaze over when something new happens with this application. I've been sporadically trying for several months to correct the problem, but I just surrendered and decided I have to ask for help.

Would you be so kind as to provide me with the element number that Yahoo quote has changed to or provide me with a line code for a quote from somewhere else that does the same thing?

Thank You

Sat Jul 14, 2012 11:08 am (PDT) . Posted by:

"ts63033" ts63033

That finally worked. Thanks for your help.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> That release of the add-in doesn't contain the most recent changes to MSN
> element definitions. You would need the newer version of the
> smf-elements-1.txt file from the "Works in Progress" folder for those new
> element definitions.
>
> On Fri, Jul 13, 2012 at 6:40 PM, ts63033 <mdlarson5@...> wrote:
>
> >
> > I replaced all of the files in my C:\Program Files\SMF Add-in folder with
> > files from the "Add-In Files" folder zip file that you have posted on line.
> > I did this on July 6 and that is the date that shows up in the "Date
> > modified" area when I look at the file details. So, I am assuming that I
> > have the most recent version of all files. Is that not the case?
> >
>

Sat Jul 14, 2012 4:06 pm (PDT) . Posted by:

"colinmmoors" colinmmoors

Randy, after overwriting the new smf_addin files, do i need to do anything else? thanks

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> This is what I get in my workbook for SPY:
>
> Date Open High Low Close Volume Adj Close 2012-07-13 $133.86 $135.89
> $133.84 $135.75 129618200 $135.75 2012-07-12 $133.38 $134.23 $132.60
> $133.51 143510900 $133.51 2012-07-11 $134.21 $134.60 $133.38 $134.16
> 141733400 $134.16
> This is what I see posted for SPY:
>
> PricesDateOpenHighLowCloseVolumeAdj Close* Jul 13, 2012133.86135.89133.84
> 135.69107,659,600135.75Jul 13, 2012133.86135.89133.84135.75129,618,200135.75Jul
> 12, 2012133.38134.23132.60133.51143,510,900133.51
> Looks to me like the function is grabbing the second row of what's posted...
>
> On Fri, Jul 13, 2012 at 7:26 PM, colinmmoors <colinmmoors@...> wrote:
>
> >
> > I tried your new version and it is pulling the data from the first row
> > (which is incorrect); it needs to pull data from the second row if there
> > are repeating dates.
> >
>

Sat Jul 14, 2012 4:09 pm (PDT) . Posted by:

"scott grant" scott_grant2

I'm having this problem too
let me know if it works please
Thanks

Sent from my iPhone

On Jul 14, 2012, at 6:06 PM, "colinmmoors" <colinmmoors@yahoo.com> wrote:

> Randy, after overwriting the new smf_addin files, do i need to do anything else? thanks
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > This is what I get in my workbook for SPY:
> >
> > Date Open High Low Close Volume Adj Close 2012-07-13 $133.86 $135.89
> > $133.84 $135.75 129618200 $135.75 2012-07-12 $133.38 $134.23 $132.60
> > $133.51 143510900 $133.51 2012-07-11 $134.21 $134.60 $133.38 $134.16
> > 141733400 $134.16
> > This is what I see posted for SPY:
> >
> > PricesDateOpenHighLowCloseVolumeAdj Close* Jul 13, 2012133.86135.89133.84
> > 135.69107,659,600135.75Jul 13, 2012133.86135.89133.84135.75129,618,200135.75Jul
> > 12, 2012133.38134.23132.60133.51143,510,900133.51
> > Looks to me like the function is grabbing the second row of what's posted...
> >
> > On Fri, Jul 13, 2012 at 7:26 PM, colinmmoors <colinmmoors@...> wrote:
> >
> > >
> > > I tried your new version and it is pulling the data from the first row
> > > (which is incorrect); it needs to pull data from the second row if there
> > > are repeating dates.
> > >
> >
>
>
>
>
>
>
>

Sat Jul 14, 2012 5:41 pm (PDT) . Posted by:

"almondtree" almondtree

THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU, Its fast even for Math formulas, when Randy talked about tables I blew it off. Excel 2010.

--- In smf_addin@yahoogroups.com, "PLA" <optionzz@...> wrote:
>
> Perhaps this will help some others, and maybe Randy can comment.
>
> I have a Table (this is a named structure in 2010) that has summaries of
> strategy performance simulations for the 102 stocks that make up Dividend
> Champions. It had three columns that needed SMF formulas to complete the
> 102 rows of data for each column. As a test, I entered a formula in column
> C to get the company name. I entered it by typing in
> =RCHGetElementNumber(
> Then moused to Col B which has the ticker value (ABM). Then I typed in
> 13862, the code for the company name.
> To my surprise, the formula looked like this: [@Ticker], 13862 )
> To my even greater surprise, the whole column filled out with the company
> names for the 102 tickers in column B. It happened VERY fast, much like I
> had entered a CSE array formula.but I hadn't. I did the same thing for the
> sector and industry columns. They filled out very fast as well.
> =RCHGetElementNumber( [@Ticker], 13865 )
> =RCHGetElementNumber( [@Ticker], 13867 )
> The whole thing completed in a second or two!
> Another surprise was when I added an additional ticker, col B, in the first
> empty row below the table, it instantly got added to the table AND the three
> columns populated in a second or so without me extending the formulas. This
> is quick and easy for some sorts of analysis. I'd always avoided tables
> because in earlier versions of Excel, there had been lots of "problems."
>
> I'm pondering how the "table logic" actually works. I entered exactly one
> formula in the first row of the table, for each column. It was
> automatically extended the length of the table, and the values appeared
> quickly. Might be a useful technique for some of us?
>
> Here's what the results of single entry formula (without CSE) looks like in
> this table (for those who can read imbedded images):
>
>
> And with formulas displayed.
>
>
> Pete A
>
> Amateurs practice until they get it right, experts practice until they can't
> get it wrong
> (Faith Duck)
>

Tidak ada komentar:

Posting Komentar