6 New Messages
Digest #2279
Messages
Sat Jul 14, 2012 6:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Shouldn't. The latest 2.1.2012.07.19 is exactly the set of files that I use.
What is your exact function invocation that you are having problems with?
On Sat, Jul 14, 2012 at 4:06 PM, colinmmoors <colinmmoors@yahoo.com > wrote:
> Randy, after overwriting the new smf_addin files, do i need to do anything
> else? thanks
>
What is your exact function invocation that you are having problems with?
On Sat, Jul 14, 2012 at 4:06 PM, colinmmoors <colinmmoors@
> Randy, after overwriting the new smf_addin files, do i need to do anything
> else? thanks
>
Sat Jul 14, 2012 6:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Are you using the beta version of the add-in from the "Works in Progress"
folder? If so, what is your exact function invocation?
On Sat, Jul 14, 2012 at 4:09 PM, scott grant <scott_grant2@yahoo.com > wrote:
>
> I'm having this problem too
> let me know if it works please
>
folder? If so, what is your exact function invocation?
On Sat, Jul 14, 2012 at 4:09 PM, scott grant <scott_grant2@
>
> I'm having this problem too
> let me know if it works please
>
Sat Jul 14, 2012 6:55 pm (PDT) . Posted by:
"scott grant" scott_grant2
I'll have to check that randy
It was working fine for months
And when I checked two days ago
The list has the last day listed twice
and it is in a longer decimal form
weird, it just started that
So I figured something must have changed
I havent downloaded a new version
Of the plug in or anything
Thx
Sent from my iPhone
On Jul 14, 2012, at 8:22 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> Are you using the beta version of the add-in from the "Works in Progress" folder? If so, what is your exact function invocation?
>
>
> On Sat, Jul 14, 2012 at 4:09 PM, scott grant <scott_grant2@yahoo.com > wrote:
>
> I'm having this problem too
> let me know if it works please
>
>
>
>
>
>
>
It was working fine for months
And when I checked two days ago
The list has the last day listed twice
and it is in a longer decimal form
weird, it just started that
So I figured something must have changed
I havent downloaded a new version
Of the plug in or anything
Thx
Sent from my iPhone
On Jul 14, 2012, at 8:22 PM, Randy Harmelink <rharmelink@gmail.
> Are you using the beta version of the add-in from the "Works in Progress" folder? If so, what is your exact function invocation?
>
>
> On Sat, Jul 14, 2012 at 4:09 PM, scott grant <scott_grant2@
>
> I'm having this problem too
> let me know if it works please
>
>
>
>
>
>
>
Sat Jul 14, 2012 7:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The double-date listing is a Yahoo problem. That's why I issued a fix. The
other poster was saying that the fix (i.e. the "beta" version of the
add-in) isn't working as expected on his side...
On Sat, Jul 14, 2012 at 6:55 PM, scott grant <scott_grant2@yahoo.com > wrote:
>
> I'll have to check that randy
> It was working fine for months
> And when I checked two days ago
> The list has the last day listed twice
> and it is in a longer decimal form
> weird, it just started that
> So I figured something must have changed
> I havent downloaded a new version
> Of the plug in or anything
>
>
other poster was saying that the fix (i.e. the "beta" version of the
add-in) isn't working as expected on his side...
On Sat, Jul 14, 2012 at 6:55 PM, scott grant <scott_grant2@
>
> I'll have to check that randy
> It was working fine for months
> And when I checked two days ago
> The list has the last day listed twice
> and it is in a longer decimal form
> weird, it just started that
> So I figured something must have changed
> I havent downloaded a new version
> Of the plug in or anything
>
>
Sat Jul 14, 2012 7:57 pm (PDT) . Posted by:
"scott grant" scott_grant2
Thanks
I'll download the fix and try it
Thanks
Scott
Sent from my iPhone
On Jul 14, 2012, at 9:06 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> The double-date listing is a Yahoo problem. That's why I issued a fix. The other poster was saying that the fix (i.e. the "beta" version of the add-in) isn't working as expected on his side...
>
>
> On Sat, Jul 14, 2012 at 6:55 PM, scott grant <scott_grant2@yahoo.com > wrote:
>
> I'll have to check that randy
> It was working fine for months
> And when I checked two days ago
> The list has the last day listed twice
> and it is in a longer decimal form
> weird, it just started that
> So I figured something must have changed
> I havent downloaded a new version
> Of the plug in or anything
>
>
>
>
>
>
>
>
I'll download the fix and try it
Thanks
Scott
Sent from my iPhone
On Jul 14, 2012, at 9:06 PM, Randy Harmelink <rharmelink@gmail.
> The double-date listing is a Yahoo problem. That's why I issued a fix. The other poster was saying that the fix (i.e. the "beta" version of the add-in) isn't working as expected on his side...
>
>
> On Sat, Jul 14, 2012 at 6:55 PM, scott grant <scott_grant2@
>
> I'll have to check that randy
> It was working fine for months
> And when I checked two days ago
> The list has the last day listed twice
> and it is in a longer decimal form
> weird, it just started that
> So I figured something must have changed
> I havent downloaded a new version
> Of the plug in or anything
>
>
>
>
>
>
>
>
Sat Jul 14, 2012 7:26 pm (PDT) . Posted by:
"rent2474@bellsouth.net" rent2474@bellsouth.net
You have to be sure you use lower case L1 not upcase I1 for
=RCHGetYahooQuotes(Ticker,"l1") to work - I scratched my head for awhile on that one too.
Also - if you are retrieving several quotes at once from Yahoo see this link about using arrays -
http://finance.groups.yahoo.com/group/smf_addin/message/124
it's faster than using a separate formula for each ticker.
--- In smf_addin@yahoogroups.com , "timbabear" <ddoyle3@...> wrote:
>
> 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.
> > >
> >
>
=RCHGetYahooQuotes(
Also - if you are retrieving several quotes at once from Yahoo see this link about using arrays -
http://finance.
it's faster than using a separate formula for each ticker.
--- In smf_addin@yahoogrou
>
> 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@yahoogrou
> >
> > RCHGetYahooQuotes(
> > 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(
> >
> > 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(
> > > 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.
> > >
> >
>
Tidak ada komentar:
Posting Komentar