15 New Messages
Digest #2929
Messages
Wed Jan 15, 2014 3:24 am (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
>>>Can you just use the smfFixLinks macro?<<<
What is this? I am not familiar with it.
The only work around I have found is to first "Save as" the file to My Documents folder on my computer then "Save" which puts a copy in my Skydrive folder on my computer then uploads a copy to the Skydrive cloud. Not ideal but it stops the links from breaking.
I am familiar with going to the Data tab, then edit links. I then browse to Program Files/SMF Add In and select the RCH_Stock_Market_Function file which restores the link. That's a pain to do every time the file opens without the work around.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think the problem is that EXCEL can't resolve links to a network drive.
>
> Can you just use the smfFixLinks macro?
>
> On Tue, Jan 14, 2014 at 8:04 PM, ridgebacksexcel <tmallen2@...>wrote:
>
> > I have updated my computer to Windows 8.1 and have all my spreadsheets
> > located in my Skydrive folder.
> >
> > Every time I open an Excel spreadsheet that wants to use the SMF add in, I
> > get a location error for the add in as it cannot locate it on Skydrive.
> >
> > I go to edit links and change the source to Program files/SMF Add in
> > folder on my C: drive where I keep the add in. I save the Excel file, it
> > uploads to Skydrive.
> >
> > I then open it again from my skydrive folder and get the same error even
> > though I edited the link location.
> >
> > Has anyone else figured out how to get this to work without editing the
> > link every time you open an Excel file with the Add In?
> >
>
What is this? I am not familiar with it.
The only work around I have found is to first "Save as" the file to My Documents folder on my computer then "Save" which puts a copy in my Skydrive folder on my computer then uploads a copy to the Skydrive cloud. Not ideal but it stops the links from breaking.
I am familiar with going to the Data tab, then edit links. I then browse to Program Files/SMF Add In and select the RCH_Stock_Market_
--- In smf_addin@yahoogrou
>
> I think the problem is that EXCEL can't resolve links to a network drive.
>
> Can you just use the smfFixLinks macro?
>
> On Tue, Jan 14, 2014 at 8:04 PM, ridgebacksexcel <tmallen2@
>
> > I have updated my computer to Windows 8.1 and have all my spreadsheets
> > located in my Skydrive folder.
> >
> > Every time I open an Excel spreadsheet that wants to use the SMF add in, I
> > get a location error for the add in as it cannot locate it on Skydrive.
> >
> > I go to edit links and change the source to Program files/SMF Add in
> > folder on my C: drive where I keep the add in. I save the Excel file, it
> > uploads to Skydrive.
> >
> > I then open it again from my skydrive folder and get the same error even
> > though I edited the link location.
> >
> > Has anyone else figured out how to get this to work without editing the
> > link every time you open an Excel file with the Add In?
> >
>
Wed Jan 15, 2014 6:48 am (PST) . Posted by:
"Randy Harmelink" rharmelink
There is an smfFixLinks macro in the add-in. I have it assigned to a button
on my EXCEL toolbar, so I can run it any time I open a workbook with
location errors.
It just does a "Find and Replace all" on the hard-coded location that EXCEL
leaves on unresolved links.
See the entry in the LINKS area of the group for some information on
location errors and unresolved links.
On Wed, Jan 15, 2014 at 4:24 AM, ridgebacksexcel <tmallen2@bellsouth.net>wrote:
> >>>Can you just use the smfFixLinks macro?<<<
>
> What is this? I am not familiar with it.
>
on my EXCEL toolbar, so I can run it any time I open a workbook with
location errors.
It just does a "Find and Replace all" on the hard-coded location that EXCEL
leaves on unresolved links.
See the entry in the LINKS area of the group for some information on
location errors and unresolved links.
On Wed, Jan 15, 2014 at 4:24 AM, ridgebacksexcel <tmallen2@bellsouth.
> >>>
>
> What is this? I am not familiar with it.
>
Wed Jan 15, 2014 4:41 am (PST) . Posted by:
smortonm
My ability to bring in Yahoo stock quotes is getting worse by the day. My spread sheet has about 100+ quotes and many fail to come in. It appears that MSN last quote is a day old? Is there another source of reliable last price quotes that is available. Any help greatly appreciated.
Sid
Sid
Wed Jan 15, 2014 6:19 am (PST) . Posted by:
cats1017
My spreadsheet is having the same problems - I have tried cutting down on the number of queries it pulls from Yahoo, but even a file with just a few queries takes a very long time and most of the quotes do not populate.
Wed Jan 15, 2014 6:33 am (PST) . Posted by:
hamishthedenizen
You can try to get them from Google using
=smfConvertData(smfGetTagContent("https://www.google.com/finance?q="&A1,"span",-1,"_l"">"))
Where cell A1 contains the ticker
=smfConvertData(
Where cell A1 contains the ticker
Wed Jan 15, 2014 6:48 am (PST) . Posted by:
smortonm
Thank U very much -- this seems to be a lot better
Sid
Sid
Wed Jan 15, 2014 6:50 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Instead of doing the 100+ requests and having a few fail, why not just do
one array-entered formula and get all the data in one request? It should be
faster and more reliable.
On Wed, Jan 15, 2014 at 5:41 AM, <smmarder@yahoo.com> wrote:
>
> My ability to bring in Yahoo stock quotes is getting worse by the day. My
> spread sheet has about 100+ quotes and many fail to come in. It appears
> that MSN last quote is a day old? Is there another source of reliable last
> price quotes that is available. Any help greatly appreciated.
> Sid
>
one array-entered formula and get all the data in one request? It should be
faster and more reliable.
On Wed, Jan 15, 2014 at 5:41 AM, <smmarder@yahoo.
>
> My ability to bring in Yahoo stock quotes is getting worse by the day. My
> spread sheet has about 100+ quotes and many fail to come in. It appears
> that MSN last quote is a day old? Is there another source of reliable last
> price quotes that is available. Any help greatly appreciated.
> Sid
>
Wed Jan 15, 2014 7:11 am (PST) . Posted by:
rogacox
Randy,
Do you have an example Excel file that uses an array to get information from Yahoo that does not return errors. In any spreadsheet tab I am only getting about a dozen rows of data and I have separated the other material after blank rows to separate tabs in the spreadsheet. I am having some of the same trouble reported in other comments, but in addition to quotes I use (from the element tables) 943, 629, 989, 990, and 986 and the quote function with arguments "r" for P/E, , and "t8" for target price. The "Error" returns seem almost random. I would appreciate a way around this. I could get quotes from another source but that does not solve the issue of the other data. Thanks in advance for your help.
Do you have an example Excel file that uses an array to get information from Yahoo that does not return errors. In any spreadsheet tab I am only getting about a dozen rows of data and I have separated the other material after blank rows to separate tabs in the spreadsheet. I am having some of the same trouble reported in other comments, but in addition to quotes I use (from the element tables) 943, 629, 989, 990, and 986 and the quote function with arguments "r" for P/E, , and "t8" for target price. The "Error" returns seem almost random. I would appreciate a way around this. I could get quotes from another source but that does not solve the issue of the other data. Thanks in advance for your help.
Wed Jan 15, 2014 7:13 am (PST) . Posted by:
rogacox
An example for those of us that are not programmers would be appreciated. Thanks.
Wed Jan 15, 2014 7:25 am (PST) . Posted by:
mikemcq802
Go to the Files section of the group and look at the SMF-Template-RCHGetYahooQuotes example xls.
It's in the RCHGetYahooQuotes folder in the Files section, Templates and Examples.
I have also had some problems getting yahoo quotes the past week or so. My experience is my array of returned data is either all-there or all-missing. I use the SMFForceRecalculation to refresh the data when that happens and it almost always returns the full set of data (see the Group's Links section for an explanation). Yahoo is clearly having issues. The best thing to do is minimize the number of requests you make by using array formulas.
It's in the RCHGetYahooQuotes folder in the Files section, Templates and Examples.
I have also had some problems getting yahoo quotes the past week or so. My experience is my array of returned data is either all-there or all-missing. I use the SMFForceRecalculati
Wed Jan 15, 2014 7:29 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The RCHGetElementNumber() function can't be array-entered. I thought you
were talking about getting quotes, with RCHGetYahooQuotes().
Yahoo's not the only service with such issues. MorningStar was down for a
bit yesterday morning as well.
There is a step-by-step example of setting up an RCHGetYahooQuotes() table.
It's pointed to both from the LINKS area of the group *and* the
documentation for RCHGetYahooQuotes().
On Wed, Jan 15, 2014 at 8:11 AM, <rogacox@yahoo.com> wrote:
>
> Do you have an example Excel file that uses an array to get information
> from Yahoo that does not return errors. In any spreadsheet tab I am only
> getting about a dozen rows of data and I have separated the other material
> after blank rows to separate tabs in the spreadsheet. I am having some of
> the same trouble reported in other comments, but in addition to quotes I
> use (from the element tables) 943, 629, 989, 990, and 986 and the quote
> function with arguments "r" for P/E, , and "t8" for target price. The
> "Error" returns seem almost random. I would appreciate a way around this.
> I could get quotes from another source but that does not solve the issue of
> the other data. Thanks in advance for your help.
>
were talking about getting quotes, with RCHGetYahooQuotes(
Yahoo's not the only service with such issues. MorningStar was down for a
bit yesterday morning as well.
There is a step-by-step example of setting up an RCHGetYahooQuotes(
It's pointed to both from the LINKS area of the group *and* the
documentation for RCHGetYahooQuotes(
On Wed, Jan 15, 2014 at 8:11 AM, <rogacox@yahoo.
>
> Do you have an example Excel file that uses an array to get information
> from Yahoo that does not return errors. In any spreadsheet tab I am only
> getting about a dozen rows of data and I have separated the other material
> after blank rows to separate tabs in the spreadsheet. I am having some of
> the same trouble reported in other comments, but in addition to quotes I
> use (from the element tables) 943, 629, 989, 990, and 986 and the quote
> function with arguments "r" for P/E, , and "t8" for target price. The
> "Error" returns seem almost random. I would appreciate a way around this.
> I could get quotes from another source but that does not solve the issue of
> the other data. Thanks in advance for your help.
>
Wed Jan 15, 2014 7:33 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Exactly. Just as an example, suppose there's a 1% chance of having an
error. If you get 100 pieces of data in an array-entered formula, you have
a 1% chance of failure (of everything). If you get those 100 pieces of data
with individual formulas, you have 63% chance of at least one item failing.
And with smfForceRecalculation, it's easy to recover from the 1% error. But
if you recalculate with the 100 pieces of data, you once again have a 63%
chance of at least one item failing.
On Wed, Jan 15, 2014 at 8:25 AM, <mikemcq802@yahoo.com> wrote:
> The best thing to do is minimize the number of requests you make by
> using array formulas.
>
error. If you get 100 pieces of data in an array-entered formula, you have
a 1% chance of failure (of everything). If you get those 100 pieces of data
with individual formulas, you have 63% chance of at least one item failing.
And with smfForceRecalculati
if you recalculate with the 100 pieces of data, you once again have a 63%
chance of at least one item failing.
On Wed, Jan 15, 2014 at 8:25 AM, <mikemcq802@yahoo.
> The best thing to do is minimize the number of requests you make by
> using array formulas.
>
Wed Jan 15, 2014 8:18 am (PST) . Posted by:
mrothaus
Wonderful! I was searching for a way to use some source other than Yahoo.
For users that have preferred stocks that they look up, be forewarned that Yahoo uses a different ticker symbol than Google. The basic difference is that Yahoo has a "P" in it. For example, AHT series D preferred symbol:
Yahoo: AHT-PD
Google: AHT-D
For users that have preferred stocks that they look up, be forewarned that Yahoo uses a different ticker symbol than Google. The basic difference is that Yahoo has a "P" in it. For example, AHT series D preferred symbol:
Yahoo: AHT-PD
Google: AHT-D
Wed Jan 15, 2014 7:47 am (PST) . Posted by:
"Evin Wrighton" ejw9785
Hello,
I have a spreadsheet that is supposed to auto-calculate several things daily after I enter in the date, one of them is the S&P 500. I'm not sure what went wrong, but it calculated (.57%) on both 1/7 and 1/8 - when it should have been .61% on 1/7 and .02% on 1/8/14.
I noticed on one of your past messages that there was an update on the add-in? Could this be why my spreadsheet has stopped calculating correctly?
I have excel 2007 - I'm not sure what other information you need? This is something new I took over and wasn't expecting to have any issues with the calculating from the RCH_Stock_Market_Functions excel add-in.
Thank you for your help!!
E
I have a spreadsheet that is supposed to auto-calculate several things daily after I enter in the date, one of them is the S&P 500. I'm not sure what went wrong, but it calculated (.57%) on both 1/7 and 1/8 - when it should have been .61% on 1/7 and .02% on 1/8/14.
I noticed on one of your past messages that there was an update on the add-in? Could this be why my spreadsheet has stopped calculating correctly?
I have excel 2007 - I'm not sure what other information you need? This is something new I took over and wasn't expecting to have any issues with the calculating from the RCH_Stock_
Thank you for your help!!
E
Wed Jan 15, 2014 7:51 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Without knowing the details, I can only speculate. Two possibilities come
to mind immediately:
1. You may have your Internet Options set to not get a fresh copy of a web
page every time the site is visited.
2. Since you took it over from someone else, you may have location errors
-- EXCEL not resolving all the links properly because the add-in is in a
different location that the person that saved the workbook.
Both of these issues have entries in the LINKS area of the group.
On Wed, Jan 15, 2014 at 8:41 AM, Evin Wrighton <ejw9785@yahoo.com> wrote:
>
> I have a spreadsheet that is supposed to auto-calculate several things
> daily after I enter in the date, one of them is the S&P 500. I'm not sure
> what went wrong, but it calculated (.57%) on both 1/7 and 1/8 - when it
> should have been .61% on 1/7 and .02% on 1/8/14.
>
> I noticed on one of your past messages that there was an update on the
> add-in? Could this be why my spreadsheet has stopped calculating correctly?
>
> I have excel 2007 - I'm not sure what other information you need? This is
> something new I took over and wasn't expecting to have any issues with the
> calculating from the RCH_Stock_Market_Functions excel add-in.
>
> Thank you for your help!!
>
> E
>
to mind immediately:
1. You may have your Internet Options set to not get a fresh copy of a web
page every time the site is visited.
2. Since you took it over from someone else, you may have location errors
-- EXCEL not resolving all the links properly because the add-in is in a
different location that the person that saved the workbook.
Both of these issues have entries in the LINKS area of the group.
On Wed, Jan 15, 2014 at 8:41 AM, Evin Wrighton <ejw9785@yahoo.
>
> I have a spreadsheet that is supposed to auto-calculate several things
> daily after I enter in the date, one of them is the S&P 500. I'm not sure
> what went wrong, but it calculated (.57%) on both 1/7 and 1/8 - when it
> should have been .61% on 1/7 and .02% on 1/8/14.
>
> I noticed on one of your past messages that there was an update on the
> add-in? Could this be why my spreadsheet has stopped calculating correctly?
>
> I have excel 2007 - I'm not sure what other information you need? This is
> something new I took over and wasn't expecting to have any issues with the
> calculating from the RCH_Stock_Market_
>
> Thank you for your help!!
>
> E
>
Tidak ada komentar:
Posting Komentar