15 Messages
Digest #4236
Messages
Mon Nov 13, 2017 7:56 pm (PST) . Posted by:
"Thomas J Strouse" thomas.strouse@nielsen.com
I unblocked all the files in the Add-In dir and fixed a link error, and it
works perfectly! Thanks for your unending help!!
On Mon, Nov 13, 2017 at 7:33 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> As I indicated with the link I sent, EXCEL is probably not allowing the
> add-in to be loaded automatically, because of the Microsoft security
> update. Their work-around is to unblock the XLA file.
>
> Unless I am misunderstanding your reference to "existing link"? If you are
> referring to unresolved links in the worksheet (i.e. disk locations in
> front of function invocations), you may simply need to run the smfFixLinks
> macro.
>
> On Mon, Nov 13, 2017 at 4:03 PM, Thomas J Strouse thomas.strouse@
> ...
> wrote:
>
>>
>> Thanks so much! I now have the M* 10-year data!
>>
>> Not catching the wrong directory structure is embarrassing!!! However, I
>> still have to select ALT+T+I to get the Add-Ins window, browse to the
>> correct Add-In directory location (C\SMF Add-In) and overwrite the existing
>> link to get rid of the #NAME? error. Below is the Excel Options Add-in
>> screen:
>>
>> [image: Inline image 1]
>>
>> Does it have anything to do with my dir structure?
>>
>> [image: Inline image 2]
>>
>> [image: Inline image 3]
>>
>>
>>
>
--
*Thomas J. Strouse*
VP and Senior Intellectual Property Counsel
The Nielsen Company
10 Waterview Blvd., Parsippany, NJ
Office (973) 299-2202
Mobile (973) 216-4631
Fax (973) 860-1637
www.nielsen.com
*The material in this transmission contains confidential information
intended only for the addressee. If you are not the addressee, any
disclosure or use of this information by you is strictly prohibited. If
you have received this transmission in error, please delete it, destroy all
copies, and notify The Nielsen Company by telephone at 973.299.2202. Thank
you*
works perfectly! Thanks for your unending help!!
On Mon, Nov 13, 2017 at 7:33 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> As I indicated with the link I sent, EXCEL is probably not allowing the
> add-in to be loaded automatically, because of the Microsoft security
> update. Their work-around is to unblock the XLA file.
>
> Unless I am misunderstanding your reference to "existing link"? If you are
> referring to unresolved links in the worksheet (i.e. disk locations in
> front of function invocations)
> macro.
>
> On Mon, Nov 13, 2017 at 4:03 PM, Thomas J Strouse thomas.strouse@
> ...
> wrote:
>
>>
>> Thanks so much! I now have the M* 10-year data!
>>
>> Not catching the wrong directory structure is embarrassing!
>> still have to select ALT+T+I to get the Add-Ins window, browse to the
>> correct Add-In directory location (C\SMF Add-In) and overwrite the existing
>> link to get rid of the #NAME? error. Below is the Excel Options Add-in
>> screen:
>>
>> [image: Inline image 1]
>>
>> Does it have anything to do with my dir structure?
>>
>> [image: Inline image 2]
>>
>> [image: Inline image 3]
>>
>>
>>
>
--
*Thomas J. Strouse*
VP and Senior Intellectual Property Counsel
The Nielsen Company
10 Waterview Blvd., Parsippany, NJ
Office (973) 299-2202
Mobile (973) 216-4631
Fax (973) 860-1637
www.nielsen.
*The material in this transmission contains confidential information
intended only for the addressee. If you are not the addressee, any
disclosure or use of this information by you is strictly prohibited. If
you have received this transmission in error, please delete it, destroy all
copies, and notify The Nielsen Company by telephone at 973.299.2202. Thank
you*
Tue Nov 14, 2017 5:11 am (PST) . Posted by:
timdbui
Hello Thomas,
Could you please elaborate as how to "unblock all of the files in the Add-in" ? I have the same issue, but I can't find the "unblock" option on Properties, and General Tab. Thank you!
Tim
Could you please elaborate as how to "unblock all of the files in the Add-in" ? I have the same issue, but I can't find the "unblock" option on Properties, and General Tab. Thank you!
Tim
Tue Nov 14, 2017 7:18 am (PST) . Posted by:
"Randy Harmelink" rharmelink
He had picture of it. But it may depend on your operating system. My old
machine had Vista, and I don't think it existed there.
On Tue, Nov 14, 2017 at 6:11 AM, timdbui@
...
wrote:
>
> Hello Thomas,
>
> Could you please elaborate as how to "unblock all of the files in the
> Add-in" ? I have the same issue, but I can't find the "unblock" option on
> Properties, and General Tab. Thank you!
>
>
>
machine had Vista, and I don't think it existed there.
On Tue, Nov 14, 2017 at 6:11 AM, timdbui@
...
wrote:
>
> Hello Thomas,
>
> Could you please elaborate as how to "unblock all of the files in the
> Add-in" ? I have the same issue, but I can't find the "unblock" option on
> Properties, and General Tab. Thank you!
>
>
>
Tue Nov 14, 2017 8:09 am (PST) . Posted by:
"Thomas J Strouse" thomas.strouse@nielsen.com
I'm on a Dell Laptop using Windows 10
1) Go to the Add-In dir (C:\SMF Add-In)
2) Right click on RCH_Stock_Market_Functions.xla
3) Select Properties
4) If the doc is blocked, then in the lower right hand corner of the
properties box, you will see a small check next to "Unblock" (similar to
Hidden or Read-only). Check the box.
5) Once you check the box and select Apply or OK, it will disappear and the
file should be unblocked.
Below is an image of the properties pop-up for the file and it is now
Unblocked. The checkbox and word "Unblocked" has disappeared.
[image: Inline image 1]
On Tue, Nov 14, 2017 at 10:18 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> He had picture of it. But it may depend on your operating system. My old
> machine had Vista, and I don't think it existed there.
>
> On Tue, Nov 14, 2017 at 6:11 AM, timdbui@
> ...
> wrote:
>
>>
>> Hello Thomas,
>>
>> Could you please elaborate as how to "unblock all of the files in the
>> Add-in" ? I have the same issue, but I can't find the "unblock" option on
>> Properties, and General Tab. Thank you!
>>
>>
>>
>
--
*Thomas J. Strouse*
VP and Senior Intellectual Property Counsel
The Nielsen Company
10 Waterview Blvd., Parsippany, NJ
Office (973) 299-2202
Mobile (973) 216-4631
Fax (973) 860-1637
www.nielsen.com
*The material in this transmission contains confidential information
intended only for the addressee. If you are not the addressee, any
disclosure or use of this information by you is strictly prohibited. If
you have received this transmission in error, please delete it, destroy all
copies, and notify The Nielsen Company by telephone at 973.299.2202. Thank
you*
1) Go to the Add-In dir (C:\SMF Add-In)
2) Right click on RCH_Stock_Market_Functions.xla
3) Select Properties
4) If the doc is blocked, then in the lower right hand corner of the
properties box, you will see a small check next to "Unblock" (similar to
Hidden or Read-only). Check the box.
5) Once you check the box and select Apply or OK, it will disappear and the
file should be unblocked.
Below is an image of the properties pop-up for the file and it is now
Unblocked. The checkbox and word "Unblocked" has disappeared.
[image: Inline image 1]
On Tue, Nov 14, 2017 at 10:18 AM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> He had picture of it. But it may depend on your operating system. My old
> machine had Vista, and I don't think it existed there.
>
> On Tue, Nov 14, 2017 at 6:11 AM, timdbui@
> ...
> wrote:
>
>>
>> Hello Thomas,
>>
>> Could you please elaborate as how to "unblock all of the files in the
>> Add-in" ? I have the same issue, but I can't find the "unblock" option on
>> Properties, and General Tab. Thank you!
>>
>>
>>
>
--
*Thomas J. Strouse*
VP and Senior Intellectual Property Counsel
The Nielsen Company
10 Waterview Blvd., Parsippany, NJ
Office (973) 299-2202
Mobile (973) 216-4631
Fax (973) 860-1637
www.nielsen.
*The material in this transmission contains confidential information
intended only for the addressee. If you are not the addressee, any
disclosure or use of this information by you is strictly prohibited. If
you have received this transmission in error, please delete it, destroy all
copies, and notify The Nielsen Company by telephone at 973.299.2202. Thank
you*
Mon Nov 13, 2017 11:47 pm (PST) . Posted by:
chinathunder
Is there a list of number codes for smfGetYahooPortfolioView? Looking specifically for Symbol Name; i.e Home Depot for symbol HD. I am able to create an array of 24 stocks that I track, so I can pick name off the array if that's the only way. (Are the columns headings in the array given anywhere?)
thanks
thanks
Tue Nov 14, 2017 12:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
See the second worksheet in the example workbook.
On Tue, Nov 14, 2017 at 12:47 AM, rlarryfoley@
...
wrote:
> Is there a list of number codes for smfGetYahooPortfolioView? Looking
> specifically for Symbol Name; i.e Home Depot for symbol HD. I am able to
> create an array of 24 stocks that I track, so I can pick name off the array
> if that's the only way. (Are the columns headings in the array given
> anywhere?)
>
On Tue, Nov 14, 2017 at 12:47 AM, rlarryfoley@
...
wrote:
> Is there a list of number codes for smfGetYahooPortfoli
> specifically for Symbol Name; i.e Home Depot for symbol HD. I am able to
> create an array of 24 stocks that I track, so I can pick name off the array
> if that's the only way. (Are the columns headings in the array given
> anywhere?)
>
Tue Nov 14, 2017 5:16 am (PST) . Posted by:
timdbui
Hi Randy,
Sorry if this topic had been address, but for some reasons, these 2 codes no longer work on my spreadsheet:
RCHGetYahooQuotes(TICKER,"L1")
RCHGetYahooQuotes(TICKER,"d1")
Could you please advise as what I need to do to get the last quote and date?
Much appreciated!
Tim
Sorry if this topic had been address, but for some reasons, these 2 codes no longer work on my spreadsheet:
RCHGetYahooQuotes(
RCHGetYahooQuotes(
Could you please advise as what I need to do to get the last quote and date?
Much appreciated!
Tim
Tue Nov 14, 2017 7:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check recent entries on the announcements blog:
https://smf-add-in.blogspot.com/
On 10/31, Yahoo dropped the API that fed that function, so it's dead.
You'll need to use smfGetYahooPortfolioView() now. That function should be
array-entered over a range, to gather all of your necessary quotes data in
one shot.
On Tue, Nov 14, 2017 at 6:16 AM, timdbui@
...
wrote:
> Sorry if this topic had been address, but for some reasons, these 2 codes
> no longer work on my spreadsheet:
>
> RCHGetYahooQuotes(TICKER,"L1")
>
> RCHGetYahooQuotes(TICKER,"d1")
>
> Could you please advise as what I need to do to get the last quote and
> date?
>
>
>
https://smf-add-in.blogspot.com/
On 10/31, Yahoo dropped the API that fed that function, so it's dead.
You'll need to use smfGetYahooPortfoli
array-entered over a range, to gather all of your necessary quotes data in
one shot.
On Tue, Nov 14, 2017 at 6:16 AM, timdbui@
...
wrote:
> Sorry if this topic had been address, but for some reasons, these 2 codes
> no longer work on my spreadsheet:
>
> RCHGetYahooQuotes(
>
> RCHGetYahooQuotes(
>
> Could you please advise as what I need to do to get the last quote and
> date?
>
>
>
Tue Nov 14, 2017 5:47 am (PST) . Posted by:
lexstar
Does smfGetYahooPortfolioView() give LastTradeDate and/or LastTradeTime? I have the Version dated 11.11.2017, but gives only blank dates & time.
Thx
Thx
Tue Nov 14, 2017 7:22 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check the list of fields on the second tab of the example worksheet. There
are a number of choices available. I've been using #87.
On Tue, Nov 14, 2017 at 6:47 AM, lexstar@
...
wrote:
>
> Does smfGetYahooPortfolioView() give LastTradeDate and/or LastTradeTime? I
> have the Version dated 11.11.2017, but gives only blank dates & time.
>
>
>
are a number of choices available. I've been using #87.
On Tue, Nov 14, 2017 at 6:47 AM, lexstar@
...
wrote:
>
> Does smfGetYahooPortfoli
> have the Version dated 11.11.2017, but gives only blank dates & time.
>
>
>
Tue Nov 14, 2017 7:43 am (PST) . Posted by:
lexstar
I've tried them all, still only gives "--" only.
Also, if I have a list of stocks and if 1 or more of them are no longer traded, why doesn't smfGetYahooPortfolioView put a placeholder of 0 there instead of skipping rows, which then screws up everything else after?
Also, if I have a list of stocks and if 1 or more of them are no longer traded, why doesn't smfGetYahooPortfoli
Tue Nov 14, 2017 8:01 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It should match up output line to input ticker symbol with 2017.11.11.
What do you get with:
=RCHGetElementNumber("Version")
=smfGetYahooPortfolioView("MMM","15")
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
","regularMarketPrice")
On Tue, Nov 14, 2017 at 8:43 AM, lexstar@
...
wrote:
>
> I've tried them all, still only gives "--" only.
>
> Also, if I have a list of stocks and if 1 or more of them are no longer
> traded, why doesn't smfGetYahooPortfolioView put a placeholder of 0 there
> instead of skipping rows, which then screws up everything else after?
>
>
What do you get with:
=RCHGetElementNumber("Version")
=smfGetYahooPortfolioView("MMM","15")
=RCHGetWebData("
https://query1.finance.yahoo.com/v7/finance/quote?fields=regularMarketPrice&formatted=false&symbols=MMM
","
On Tue, Nov 14, 2017 at 8:43 AM, lexstar@
...
wrote:
>
> I've tried them all, still only gives "--" only.
>
> Also, if I have a list of stocks and if 1 or more of them are no longer
> traded, why doesn't smfGetYahooPortfoli
> instead of skipping rows, which then screws up everything else after?
>
>
Tue Nov 14, 2017 7:25 am (PST) . Posted by:
codyklein
Looking for a formula to grab option prices. Any help would be appreciated.
Tue Nov 14, 2017 7:32 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I use smfGetYahooPortfolioView(), using Yahoo option ticker symbols.
On Tue, Nov 14, 2017 at 8:25 AM, codyklein@
...
wrote:
> Looking for a formula to grab option prices. Any help would be appreciated.
>
>
On Tue, Nov 14, 2017 at 8:25 AM, codyklein@
...
wrote:
> Looking for a formula to grab option prices. Any help would be appreciated.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar