15 New Messages
Digest #2839
Messages
Mon Nov 4, 2013 5:15 am (PST) . Posted by:
"flangeneral" flangeneral
You can also change the setting from within Excel:
Office Button ==> Excel Options ==> Formulas ==> Workbook Calculation (Manual)
--- In smf_addin@yahoogrou
>
> Is there a way to stop excel from retrieving the data every time I move out of a cell? It makes working on a spreadsheet impossible because it takes 30 seconds to re-pull all the data every time I press Enter. In other words, is there a way to make Excel NOT update unless we press F9. (like with the NOW() function). Right now I have to release my IP address while I work on the spreadsheet and then renew my IP address when I am ready to pull the data...
>
Mon Nov 4, 2013 10:52 am (PST) . Posted by:
lewglenn
I'm trying to compute the 50-day SMA of a list of equities with:
Range("Y2:Y60") = Application.WorksheetFunction.Average(RCHGetYahooHistory(SelStr, , , , , , , , "a", 0, , , 50, 1))
Here SelStr is dimensioned as a string. I'm getting the error message: Unable to get the Average property of the WorksheetFunction class. Any suggestion as to how to fix this would be appreciated.
Thanks.
Range("
Here SelStr is dimensioned as a string. I'm getting the error message: Unable to get the Average property of the WorksheetFunction class. Any suggestion as to how to fix this would be appreciated.
Thanks.
Mon Nov 4, 2013 11:02 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I just ran this code and it worked fine:
Sub Test()
Dim SelStr As String
SelStr = "MMM"
Range("B2:B60") =
Application.WorksheetFunction.Average(RCHGetYahooHistory(SelStr, , , , , ,
, , "a", 0, , , 50, 1))
End Sub
However, why you would want to assign a single value to an entire range of
data is beyond me.
On Mon, Nov 4, 2013 at 11:52 AM, <lewglenn@yahoo.com> wrote:
>
> I'm trying to compute the 50-day SMA of a list of equities with:
>
> Range("Y2:Y60") =
> Application.WorksheetFunction.Average(RCHGetYahooHistory(SelStr, , , , , ,
> , , "a", 0, , , 50, 1))
>
> Here SelStr is dimensioned as a string. I'm getting the error message:
> Unable to get the Average property of the WorksheetFunction class. Any
> suggestion as to how to fix this would be appreciated.
>
Sub Test()
Dim SelStr As String
SelStr = "MMM"
Range("
Application.
, , "a"
End Sub
However, why you would want to assign a single value to an entire range of
data is beyond me.
On Mon, Nov 4, 2013 at 11:52 AM, <lewglenn@yahoo.
>
> I'm trying to compute the 50-day SMA of a list of equities with:
>
> Range("
> Application.
> , , "a"
>
> Here SelStr is dimensioned as a string. I'm getting the error message:
> Unable to get the Average property of the WorksheetFunction class. Any
> suggestion as to how to fix this would be appreciated.
>
Mon Nov 4, 2013 11:14 am (PST) . Posted by:
lewglenn
SelStr is an array of equities, i.e.,
Portfolio = "BMY,DFE,FBIOX,FCG,GEX,GURU,PGJ,NAVB,IWC"
SelStr = Portfolio
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
I just ran this code and it worked fine:
Sub Test()
Dim SelStr As String
SelStr = "MMM"
Range("B2:B60") = Application.WorksheetFunction.Average(RCHGetYahooHistory(SelStr, , , , , , , , "a", 0, , , 50, 1))
End Sub
However, why you would want to assign a single value to an entire range of data is beyond me.
On Mon, Nov 4, 2013 at 11:52 AM, <lewglenn@... mailto:lewglenn@...> wrote:
I'm trying to compute the 50-day SMA of a list of equities with:
Range("Y2:Y60") = Application.WorksheetFunction.Average(RCHGetYahooHistory(SelStr, , , , , , , , "a", 0, , , 50, 1))
Here SelStr is dimensioned as a string. I'm getting the error message: Unable to get the Average property of the WorksheetFunction class. Any suggestion as to how to fix this would be appreciated.
Portfolio = "BMY,DFE,
SelStr = Portfolio
---In smf_addin@yahoogrou
I just ran this code and it worked fine:
Sub Test()
Dim SelStr As String
SelStr = "MMM"
Range("
End Sub
However, why you would want to assign a single value to an entire range of data is beyond me.
On Mon, Nov 4, 2013 at 11:52 AM, <lewglenn@
I'm trying to compute the 50-day SMA of a list of equities with:
Range("
Here SelStr is dimensioned as a string. I'm getting the error message: Unable to get the Average property of the WorksheetFunction class. Any suggestion as to how to fix this would be appreciated.
Mon Nov 4, 2013 11:22 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The function only accepts a single ticker symbol.
On Mon, Nov 4, 2013 at 12:14 PM, <lewglenn@yahoo.com> wrote:
> SelStr is an array of equities, i.e.,
>
> Portfolio = "BMY,DFE,FBIOX,FCG,GEX,GURU,PGJ,NAVB,IWC"
>
> SelStr = Portfolio
>
On Mon, Nov 4, 2013 at 12:14 PM, <lewglenn@yahoo.
> SelStr is an array of equities, i.e.,
>
> Portfolio = "BMY,DFE,
>
> SelStr = Portfolio
>
Mon Nov 4, 2013 11:48 am (PST) . Posted by:
analyst101010
OK, sorry in advance for 2 pretty questions...
1) I don't get how in the template files "Ticker" works to link the formulae (e.g." =RCHGetElementNumber(Ticker,849)" ) to the actual cell (in most cases, B2). Is there any simple documentation on how this works that i can't currently find? Point me at it if so. Or is it some 'Table' function in Excel i'm ignorant of?
2) I've noticed a number of the Element Numbers are not piping through the data.... particularly Zacks stuff. e.g. in the SMF-Template-Zacks Data.xls file, only 850, 13869, 13870 are coming through. Has this been mentioned in previous comment? Again, if so = point me to it. Thanks a bunch, and as always, thanks Randy for such a cool project.
John
1) I don't get how in the template files "Ticker" works to link the formulae (e.g." =RCHGetElementNumbe
2) I've noticed a number of the Element Numbers are not piping through the data.... particularly Zacks stuff. e.g. in the SMF-Template-
John
Mon Nov 4, 2013 12:47 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
"Ticker" is just a named range in EXCEL. It can be replaced by any cell
reference. If you want to see the definition of the named range, use
EXCEL's name manager (keyboard shortcut alt+i+n+d). For more info, see:
http://office.microsoft.com/en-us/excel-help/define-and-use-names-in-formulas-HA010147120.aspx
Thanks for the heads up on the Zacks issue. It looks like they changed the
contents of the web page (e.g. the header of one of the sections used to be
"Detailed Earnings Estimates" and is now "Earnings Estimate"). I'll have to
redefine the elements to account for their changes.
On Mon, Nov 4, 2013 at 12:48 PM, <jfgilmore@gmail.com> wrote:
>
>
> OK, sorry in advance for 2 pretty questions...
>
> 1) I don't get how in the template files "Ticker" works to link the
> formulae (e.g." =RCHGetElementNumber(Ticker,849)" ) to the actual cell (in
> most cases, B2). Is there any simple documentation on how this works that
> i can't currently find? Point me at it if so. Or is it some 'Table'
> function in Excel i'm ignorant of?
>
> 2) I've noticed a number of the Element Numbers are not piping through the
> data.... particularly Zacks stuff. e.g. in the SMF-Template-Zacks
> Data.xls file, only 850, 13869, 13870 are coming through. Has this been
> mentioned in previous comment? Again, if so = point me to it. Thanks a
> bunch, and as always, thanks Randy for such a cool project.
>
> John
>
>
>
reference. If you want to see the definition of the named range, use
EXCEL's name manager (keyboard shortcut alt+i+n+d). For more info, see:
http://office.
Thanks for the heads up on the Zacks issue. It looks like they changed the
contents of the web page (e.g. the header of one of the sections used to be
"Detailed Earnings Estimates" and is now "Earnings Estimate"
redefine the elements to account for their changes.
On Mon, Nov 4, 2013 at 12:48 PM, <jfgilmore@gmail.
>
>
> OK, sorry in advance for 2 pretty questions...
>
> 1) I don't get how in the template files "Ticker" works to link the
> formulae (e.g." =RCHGetElementNumbe
> most cases, B2). Is there any simple documentation on how this works that
> i can't currently find? Point me at it if so. Or is it some 'Table&#
> function in Excel i'm ignorant of?
>
> 2) I've noticed a number of the Element Numbers are not piping through the
> data.... particularly Zacks stuff. e.g. in the SMF-Template-
> Data.xls file, only 850, 13869, 13870 are coming through. Has this been
> mentioned in previous comment? Again, if so = point me to it. Thanks a
> bunch, and as always, thanks Randy for such a cool project.
>
> John
>
>
>
Mon Nov 4, 2013 11:50 am (PST) . Posted by:
marco.deen
Randy, did Zacks change something to their website again?
=RCHGetTableCell("http://www.zacks.com/stock/quote/"&B2,1,"Next Earnings Report Date") returns "ERROR"
The webadress http://www.zacks.com/research/report.php?type=report&t=BA http://www.zacks.com/research/report.php?type=report&t=BA returns an empty page..
Thanks, Marco
=RCHGetTableCell(
The webadress http://www.zacks.
Thanks, Marco
Mon Nov 4, 2013 12:30 pm (PST) . Posted by:
"Marco Deen" marco.deen
Never mind, just change "Next Earnings Report Date" to "Exp Earnings Date"
and it returns the date once again.
On Mon, Nov 4, 2013 at 2:50 PM, <marco.deen@gmail.com> wrote:
>
>
> Randy, did Zacks change something to their website again?
>
> =RCHGetTableCell("http://www.zacks.com/stock/quote/"&B2,1,"Next Earnings
> Report Date") returns "ERROR"
>
>
>
> The webadress http://www.zacks.com/research/report.php?type=report&t=BA returns
> an empty page..
>
>
>
> Thanks, Marco
>
>
>
and it returns the date once again.
On Mon, Nov 4, 2013 at 2:50 PM, <marco.deen@gmail.
>
>
> Randy, did Zacks change something to their website again?
>
> =RCHGetTableCell(
> Report Date") returns "ERROR"
>
>
>
> The webadress http://www.zacks.
> an empty page..
>
>
>
> Thanks, Marco
>
>
>
Mon Nov 4, 2013 12:54 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The answer is "Yes, they have changed their website again". A lot of the
defined elements no longer work either.
On Mon, Nov 4, 2013 at 12:50 PM, <marco.deen@gmail.com> wrote:
> Randy, did Zacks change something to their website again?
>
> =RCHGetTableCell("http://www.zacks.com/stock/quote/"&B2,1,"Next Earnings
> Report Date") returns "ERROR"
>
> The webadress http://www.zacks.com/research/report.php?type=report&t=BA returns
> an empty page..
>
defined elements no longer work either.
On Mon, Nov 4, 2013 at 12:50 PM, <marco.deen@gmail.
> Randy, did Zacks change something to their website again?
>
> =RCHGetTableCell(
> Report Date") returns "ERROR"
>
> The webadress http://www.zacks.
> an empty page..
>
Mon Nov 4, 2013 11:50 am (PST) . Posted by:
"gfoster07k@sbcglobal.net" gfoster07k@sbcglobal.net
I'm trying to transition RCHGetYahooQuotes to Excel 2013 in my new Windows 8 PC. I have the Stock Market functions file in the SMF Add-In folder in the Program Files. I can't tell if it is zipped or not. It is about 462kb. If it is still zipped, the File Manager only gives me the option to zip it which is where I am now. The Add In does not show up in the list when I go to "Add-Ins" in the "Options" selection in Excel. Any help will be greatly appreciated. I am far from expert on the computer. I have used the Add in in my old Excel almost daily for a long time.
Mon Nov 4, 2013 12:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't see anything near 462KB.
I'd suggest downloading a new copy of the ZIP file. And you do have to add
it to the add-in manager to use it. You may want to revisit the "overview";
document in the "Documentation" folder in the FILES area of the group. The
installation instructions are there.
On Mon, Nov 4, 2013 at 12:50 PM, gfoster07k@sbcglobal.net <
gfoster07k@sbcglobal.net> wrote:
> I'm trying to transition RCHGetYahooQuotes to Excel 2013 in my new Windows
> 8 PC. I have the Stock Market functions file in the SMF Add-In folder in
> the Program Files. I can't tell if it is zipped or not. It is about
> 462kb. If it is still zipped, the File Manager only gives me the option to
> zip it which is where I am now. The Add In does not show up in the list
> when I go to "Add-Ins" in the "Options" selection in Excel. Any help will
> be greatly appreciated. I am far from expert on the computer. I have used
> the Add in in my old Excel almost daily for a long time.
>
I'd suggest downloading a new copy of the ZIP file. And you do have to add
it to the add-in manager to use it. You may want to revisit the "overview"
document in the "Documentation
installation instructions are there.
On Mon, Nov 4, 2013 at 12:50 PM, gfoster07k@sbcgloba
gfoster07k@sbcgloba
> I'm trying to transition RCHGetYahooQuotes to Excel 2013 in my new Windows
> 8 PC. I have the Stock Market functions file in the SMF Add-In folder in
> the Program Files. I can't tell if it is zipped or not. It is about
> 462kb. If it is still zipped, the File Manager only gives me the option to
> zip it which is where I am now. The Add In does not show up in the list
> when I go to "Add-Ins" in the "Options" selection in Excel. Any help will
> be greatly appreciated. I am far from expert on the computer. I have used
> the Add in in my old Excel almost daily for a long time.
>
Mon Nov 4, 2013 2:00 pm (PST) . Posted by:
ssztaba
I've been using the smfForceRecalculation to get Options quotes for months, and it's worked without fail.
Now, beginning sometime last week it seems not to work.
Has anything changed with Yahoo, or do I need to do anything to get it to retrieve option prices again ??
Thanks
Stan Sztaba
Now, beginning sometime last week it seems not to work.
Has anything changed with Yahoo, or do I need to do anything to get it to retrieve option prices again ??
Thanks
Stan Sztaba
Mon Nov 4, 2013 2:05 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You may want to double-check your Internet Options, and make sure you have
it set to always get new content when visiting a web page.
Otherwise, I need more details on "seems not to work".
On Mon, Nov 4, 2013 at 3:00 PM, <ssjurik@optonline.net> wrote:
>
> I've been using the smfForceRecalculation to get Options quotes for
> months, and it's worked without fail.
>
> Now, beginning sometime last week it seems not to work.
>
> Has anything changed with Yahoo, or do I need to do anything to get it to
> retrieve option prices again ??
>
it set to always get new content when visiting a web page.
Otherwise, I need more details on "seems not to work".
On Mon, Nov 4, 2013 at 3:00 PM, <ssjurik@optonline.
>
> I've been using the smfForceRecalculati
> months, and it's worked without fail.
>
> Now, beginning sometime last week it seems not to work.
>
> Has anything changed with Yahoo, or do I need to do anything to get it to
> retrieve option prices again ??
>
Mon Nov 4, 2013 2:35 pm (PST) . Posted by:
"Fred Wright" fredwwright
I regularly use Randy's great add- in to extract a few elements from Zacks (rank - 848; avg broker rating - 13885, # analysts - 13887; Industry Rank and Rank in Industry - 851 and 852; eps date - 877; and Average estimate for current quarter - 856). They all worked fine over the weekend but today are all returning Error - anyone else having this problem. Any advice?
Fred
Fred
Tidak ada komentar:
Posting Komentar