7 Messages
Digest #4371
Messages
Tue Jul 31, 2018 7:20 am (PDT) . Posted by:
friedman_steve
Randy,
Was hoping you could help me with formula to grab table of analyst ratings from marketbeat. Specifically the table that shows broker name and price targets: example website
I think this may be close? (where A1 has my ticker)
=RCHGetHTMLTable("http://www.marketbeat.com/stocks/NASDAQ/"&$A$1&"","Date",2,"",3)
My old formula that doesn't work anymore:
old formula: =RCHGetHTMLTable("http://www.analystratings.net/stocks/"&$A$1&"?MostRecent=1","Date",2,"",3)
Thanks for the help Randy.
Was hoping you could help me with formula to grab table of analyst ratings from marketbeat. Specifically the table that shows broker name and price targets: example website
I think this may be close? (where A1 has my ticker)
=RCHGetHTMLTable("http://www.marketbeat.com/stocks/NASDAQ/"&$A$1&"","Date",2,"",3)
My old formula that doesn't work anymore:
old formula: =RCHGetHTMLTable("http://www.analystratings.net/stocks/"&$A$1&"
Thanks for the help Randy.
Tue Jul 31, 2018 10:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Close, but you need a different URL for that tab. Try:
=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/
"&$A$1&"/price-target/",">Brokerage")
On Tue, Jul 31, 2018 at 7:20 AM, friedman_steve@
....
wrote:
> Was hoping you could help me with formula to grab table of analyst ratings
> from marketbeat. Specifically the table that shows broker name and price
> targets: example website
>
> I think this may be close? (where A1 has my ticker)
>
> =RCHGetHTMLTable("http://www.marketbeat.com/stocks/NASDAQ/"
> &$A$1&"","Date",2,"",3)
>
> My old formula that doesn't work anymore:
>
> old formula: =RCHGetHTMLTable("http://www.analystratings.net/stocks/
> "&$A$1&"?MostRecent=1","Date",2,"",3)
>
>
>
=RCHGetHTMLTable("https://www.marketbeat.com/stocks/NYSE/
"&$A$1&"/price-target/",">Brokerage")
On Tue, Jul 31, 2018 at 7:20 AM, friedman_steve@
....
wrote:
> Was hoping you could help me with formula to grab table of analyst ratings
> from marketbeat. Specifically the table that shows broker name and price
> targets: example website
>
> I think this may be close? (where A1 has my ticker)
>
> =RCHGetHTMLTable("http://www.marketbeat.com/stocks/NASDAQ/"
> &$A$1&"","Date",2,"",3)
>
> My old formula that doesn't work anymore:
>
> old formula: =RCHGetHTMLTable("http://www.analystratings.net/stocks/
> "&$A$1&"
>
>
>
Tue Jul 31, 2018 5:46 pm (PDT) . Posted by:
dan.smith33220@gmail.com
I've read and tried the recommendations on how to fix the problem of worksheets not being able to access the add-in causing cells to display #NAME?. I've tried the recommendation I've found, including deleting the formula references to the add-in location. I apologize in advance if I've missed something, but I've been unable to solve my problem.
The add-in is installed in the standard C:\SMF Add-In folder, so the references should not be the problem. However, every time I open the workbook, the formula values when last saved are displayed, but I get an Excel message "This workbook contains links to one or more external sources that could be unsafe." The message provides the option to "Update" which I select. For the record, the full reference to the add-in location is displayed in the formulas at this point and the reference is correct.
After clicking Update, I get another message "We can't update some of the links in your workbook right now." If I choose "Edit Links" at this point, and then click "Open Source", I get a message "Microsoft has identified a potential security concern". If I then click "Enable Macros", the worksheet displays #NAME? in all cells until the recalculation completes.
It seems like Microsoft believes there could be a problem with the add-in and forces me to explicitly enable macros every time I open a worksheet containing formula references to the add-in. What is the best way to avoid this problem?
The add-in is installed in the standard C:\SMF Add-In folder, so the references should not be the problem. However, every time I open the workbook, the formula values when last saved are displayed, but I get an Excel message "This workbook contains links to one or more external sources that could be unsafe." The message provides the option to "Update" which I select. For the record, the full reference to the add-in location is displayed in the formulas at this point and the reference is correct.
After clicking Update, I get another message "We can't update some of the links in your workbook right now." If I choose "Edit Links" at this point, and then click "Open Source"
It seems like Microsoft believes there could be a problem with the add-in and forces me to explicitly enable macros every time I open a worksheet containing formula references to the add-in. What is the best way to avoid this problem?
Tue Jul 31, 2018 6:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I learned a long time ago that the EXCEL method of handling unresolved
links was unreliable for add-in links.
That's why the add-in has a macro to fix things. Just execute the
smfFixLinks macro of the add-in. I even have it assigned to a button on my
quick access toolbar because I use it so often. Alternatively, it's also on
the context menu (i.e right mouse click on a cell) within EXCEL.
Once smfFixLinks processes and you save the workbook, you shouldn't have
any more unresolved links when you again open THAT WORKBOOK. At least none
that are related to the add-in. Unless you move the add-in...
On Tue, Jul 31, 2018 at 5:46 PM, dan.smith33220@
....
wrote:
> I've read and tried the recommendations on how to fix the problem of
> worksheets not being able to access the add-in causing cells to display
> #NAME?. I've tried the recommendation I've found, including deleting the
> formula references to the add-in location. I apologize in advance if I've
> missed something, but I've been unable to solve my problem.
>
> The add-in is installed in the standard C:\SMF Add-In folder, so the
> references should not be the problem. However, every time I open the
> workbook, the formula values when last saved are displayed, but I get an
> Excel message "This workbook contains links to one or more external sources
> that could be unsafe." The message provides the option to "Update" which I
> select. For the record, the full reference to the add-in location is
> displayed in the formulas at this point and the reference is correct.
>
> After clicking Update, I get another message "We can't update some of the
> links in your workbook right now." If I choose "Edit Links" at this point,
> and then click "Open Source", I get a message "Microsoft has identified a
> potential security concern". If I then click "Enable Macros", the
> worksheet displays #NAME? in all cells until the recalculation completes.
>
> It seems like Microsoft believes there could be a problem with the add-in
> and forces me to explicitly enable macros every time I open a worksheet
> containing formula references to the add-in. What is the best way to avoid
> this problem?
>
>
links was unreliable for add-in links.
That's why the add-in has a macro to fix things. Just execute the
smfFixLinks macro of the add-in. I even have it assigned to a button on my
quick access toolbar because I use it so often. Alternatively, it's also on
the context menu (i.e right mouse click on a cell) within EXCEL.
Once smfFixLinks processes and you save the workbook, you shouldn'
any more unresolved links when you again open THAT WORKBOOK. At least none
that are related to the add-in. Unless you move the add-in...
On Tue, Jul 31, 2018 at 5:46 PM, dan.smith33220@
....
wrote:
> I've read and tried the recommendations on how to fix the problem of
> worksheets not being able to access the add-in causing cells to display
> #NAME?. I've tried the recommendation I've found, including deleting the
> formula references to the add-in location. I apologize in advance if I've
> missed something, but I've been unable to solve my problem.
>
> The add-in is installed in the standard C:\SMF Add-In folder, so the
> references should not be the problem. However, every time I open the
> workbook, the formula values when last saved are displayed, but I get an
> Excel message "This workbook contains links to one or more external sources
> that could be unsafe." The message provides the option to "Update" which I
> select. For the record, the full reference to the add-in location is
> displayed in the formulas at this point and the reference is correct.
>
> After clicking Update, I get another message "We can't update some of the
> links in your workbook right now." If I choose "Edit Links" at this point,
> and then click "Open Source"
> potential security concern"
> worksheet displays #NAME? in all cells until the recalculation completes.
>
> It seems like Microsoft believes there could be a problem with the add-in
> and forces me to explicitly enable macros every time I open a worksheet
> containing formula references to the add-in. What is the best way to avoid
> this problem?
>
>
Tue Jul 31, 2018 7:46 pm (PDT) . Posted by:
"Dan Smith" dan.smith33220@gmail.com
Thanks for the quick response.
Ran the macro, saved the file, closed file and reopened. Same problem.
I'm not sure the problem is unresolved links. I'm able to solve the problem by making the choices on the Excel messages as previously indicated. This ends up simply enabling macros. It seems the links are ok, it's just that Excel doesn't want to execute the macros without them being manually enabled.
Dan
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, July 31, 2018 9:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] The dreaded #NAME?
I learned a long time ago that the EXCEL method of handling unresolved links was unreliable for add-in links.
That's why the add-in has a macro to fix things. Just execute the smfFixLinks macro of the add-in. I even have it assigned to a button on my quick access toolbar because I use it so often. Alternatively, it's also on the context menu (i.e right mouse click on a cell) within EXCEL.
Once smfFixLinks processes and you save the workbook, you shouldn't have any more unresolved links when you again open THAT WORKBOOK. At least none that are related to the add-in. Unless you move the add-in...
On Tue, Jul 31, 2018 at 5:46 PM, dan.smith33220@
....
wrote:
I've read and tried the recommendations on how to fix the problem of worksheets not being able to access the add-in causing cells to display #NAME?. I've tried the recommendation I've found, including deleting the formula references to the add-in location. I apologize in advance if I've missed something, but I've been unable to solve my problem.
The add-in is installed in the standard C:\SMF Add-In folder, so the references should not be the problem. However, every time I open the workbook, the formula values when last saved are displayed, but I get an Excel message "This workbook contains links to one or more external sources that could be unsafe." The message provides the option to "Update" which I select. For the record, the full reference to the add-in location is displayed in the formulas at this point and the reference is correct.
After clicking Update, I get another message "We can't update some of the links in your workbook right now." If I choose "Edit Links" at this point, and then click "Open Source", I get a message "Microsoft has identified a potential security concern". If I then click "Enable Macros", the worksheet displays #NAME? in all cells until the recalculation completes.
It seems like Microsoft believes there could be a problem with the add-in and forces me to explicitly enable macros every time I open a worksheet containing formula references to the add-in. What is the best way to avoid this problem?
Ran the macro, saved the file, closed file and reopened. Same problem.
I'm not sure the problem is unresolved links. I'm able to solve the problem by making the choices on the Excel messages as previously indicated. This ends up simply enabling macros. It seems the links are ok, it's just that Excel doesn't want to execute the macros without them being manually enabled.
Dan
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, July 31, 2018 9:30 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] The dreaded #NAME?
I learned a long time ago that the EXCEL method of handling unresolved links was unreliable for add-in links.
That's why the add-in has a macro to fix things. Just execute the smfFixLinks macro of the add-in. I even have it assigned to a button on my quick access toolbar because I use it so often. Alternatively, it's also on the context menu (i.e right mouse click on a cell) within EXCEL.
Once smfFixLinks processes and you save the workbook, you shouldn'
On Tue, Jul 31, 2018 at 5:46 PM, dan.smith33220@
....
wrote:
I've read and tried the recommendations on how to fix the problem of worksheets not being able to access the add-in causing cells to display #NAME?. I've tried the recommendation I've found, including deleting the formula references to the add-in location. I apologize in advance if I've missed something, but I've been unable to solve my problem.
The add-in is installed in the standard C:\SMF Add-In folder, so the references should not be the problem. However, every time I open the workbook, the formula values when last saved are displayed, but I get an Excel message "This workbook contains links to one or more external sources that could be unsafe." The message provides the option to "Update" which I select. For the record, the full reference to the add-in location is displayed in the formulas at this point and the reference is correct.
After clicking Update, I get another message "We can't update some of the links in your workbook right now." If I choose "Edit Links" at this point, and then click "Open Source"
It seems like Microsoft believes there could be a problem with the add-in and forces me to explicitly enable macros every time I open a worksheet containing formula references to the add-in. What is the best way to avoid this problem?
Tue Jul 31, 2018 11:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It can't be enabling macros. When you install an add-in, you've already
given it permission. It doesn't need any more.
Three things:
1. What do you get with:
=RCHGetElementNumber("Version")
2. Exit EXCEL, open EXCEL with an empty worksheet, and try that function
again. Do you get the same thing?
3. On the worksheet you're having troubles with, what does the formula in
one of the #NAME? cells look like? ,
On Tue, Jul 31, 2018 at 7:46 PM, 'Dan Smith' dan.smith33220@
....
wrote:
>
> Thanks for the quick response.
>
>
>
> Ran the macro, saved the file, closed file and reopened. Same problem..
>
>
>
> I'm not sure the problem is unresolved links. I'm able to solve the
> problem by making the choices on the Excel messages as previously
> indicated. This ends up simply enabling macros. It seems the links are
> ok, it's just that Excel doesn't want to execute the macros without them
> being manually enabled.
>
>
>
>
>
given it permission. It doesn't need any more.
Three things:
1. What do you get with:
=RCHGetElementNumbe
2. Exit EXCEL, open EXCEL with an empty worksheet, and try that function
again. Do you get the same thing?
3. On the worksheet you're having troubles with, what does the formula in
one of the #NAME? cells look like? ,
On Tue, Jul 31, 2018 at 7:46 PM, 'Dan Smith' dan.smith33220@
....
wrote:
>
> Thanks for the quick response.
>
>
>
> Ran the macro, saved the file, closed file and reopened. Same problem..
>
>
>
> I'm not sure the problem is unresolved links. I'm able to solve the
> problem by making the choices on the Excel messages as previously
> indicated. This ends up simply enabling macros. It seems the links are
> ok, it's just that Excel doesn't want to execute the macros without them
> being manually enabled.
>
>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar