15 Messages
Digest #4025
Messages
Mon May 22, 2017 3:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
According to Yahoo, there was a 1-for-5 split on 9/30:
*Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
*Dividend* *Split*
2013-10-01 $44.16 $44.43 $44.06 $44.39 483800 $51.17 0.867593715881983 1
2013-09-30 $43.94 $44.01 $43.69 $43.93 634300 $50.63 0.867593715881983 1 1
for 5
2013-09-27 $43.93 $44.19 $43.80 $44.02 1003100 $10.15 0.867593715881983 5
2013-09-26 $43.98 $44.04 $43.46 $43.55 1302600 $10.04 0.867593715881983 5
https://finance.yahoo.com/quote/SNY/history?period1=1380092400&period2=1380524400&interval=1d&filter=history&frequency=1d
On Mon, May 22, 2017 at 3:40 PM, tamurphy@
...wrote:
>
> Randy—I notice a discontinuity in the unadjusted closing price for SNY
> between 9/27/13 ($10.15 / share) and 9/30/13 ($50.63 / share). I'm unable
> to find any split info that might explain it.
>
>
>
*Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
*Dividend* *Split*
2013-10-01 $44.16 $44.43 $44.06 $44.39 483800 $51.17 0.867593715881983 1
2013-09-30 $43.94 $44.01 $43.69 $43.93 634300 $50.63 0.867593715881983 1 1
for 5
2013-09-27 $43.93 $44.19 $43.80 $44.02 1003100 $10.15 0.867593715881983 5
2013-09-26 $43.98 $44.04 $43.46 $43.55 1302600 $10.04 0.867593715881983 5
https://finance.yahoo.com/quote/SNY/history?period1=1380092400&period2=1380524400&interval=1d&filter=history&frequency=1d
On Mon, May 22, 2017 at 3:40 PM, tamurphy@
...wrote:
>
> Randy—I notice a discontinuity in the unadjusted closing price for SNY
> between 9/27/13 ($10.15 / share) and 9/30/13 ($50.63 / share). I'm unable
> to find any split info that might explain it.
>
>
>
Mon May 22, 2017 5:54 pm (PDT) . Posted by:
"Peter James" pmjzz
Randy:
I use historical prices and historical dividends (preferably
split-adjusted, both) to calculate historical yields. One of my buy/sell
signals is the current yield vs the range of historic yields - EG MCD
generally trades between 2.5% & 3.5%.
It's almost impossible to do this if the prices are dividend-adjusted.
Agreed that special dividends could mess-up this approach - but I've run
into very few such cases.
Peter
On 2017-05-20 18:29, Randy Harmelink rharmelink@gmail.com [smf_addin] wrote:
>
> Why would you want prices adjusted by splits, but not by dividends?
> Historical quotes are out of context with each other without such
> adjustments. Just imagine a stock that pays out a special 10% cash
> dividend. Would you want to see such a change in price on your quotes?
>
I use historical prices and historical dividends (preferably
split-adjusted, both) to calculate historical yields. One of my buy/sell
signals is the current yield vs the range of historic yields - EG MCD
generally trades between 2.5% & 3.5%.
It's almost impossible to do this if the prices are dividend-adjusted.
Agreed that special dividends could mess-up this approach - but I've run
into very few such cases.
Peter
On 2017-05-20 18:29, Randy Harmelink rharmelink@gmail.com [smf_addin] wrote:
>
> Why would you want prices adjusted by splits, but not by dividends?
> Historical quotes are out of context with each other without such
> adjustments. Just imagine a stock that pays out a special 10% cash
> dividend. Would you want to see such a change in price on your quotes?
>
Mon May 22, 2017 5:57 pm (PDT) . Posted by:
eremon9
"According to Yahoo, there was a 1-for-5 split on 9/30"
I've examined my brokerage statements for the 2010-2012 period, and see several SNY transactions with prices in the $30-40 range, whereas the (pre-split) unadjusted closing prices returned by Yahoo during this timeframe range between $6 and $10 / share. On 11/16/10 there appears to be another 1-for-10 split, which puts the pre-split stock price below $1.00 / share. Highly improbable for a company like Sanofi, I'd say.
Tom
I've examined my brokerage statements for the 2010-2012 period, and see several SNY transactions with prices in the $30-40 range, whereas the (pre-split) unadjusted closing prices returned by Yahoo during this timeframe range between $6 and $10 / share. On 11/16/10 there appears to be another 1-for-10 split, which puts the pre-split stock price below $1.00 / share. Highly improbable for a company like Sanofi, I'd say.
Tom
Mon May 22, 2017 6:09 pm (PDT) . Posted by:
eremon9
"I use historical prices and historical dividends (preferably split-adjusted, both) to calculate historical yields."
I too do something like that with WFC-PL, where the dividend is a fixed percentage of the par value, and the meaningful price is unadjusted for dividends. Splits aren't an issue in this case.
Tom
I too do something like that with WFC-PL, where the dividend is a fixed percentage of the par value, and the meaningful price is unadjusted for dividends. Splits aren't an issue in this case.
Tom
Mon May 22, 2017 6:10 pm (PDT) . Posted by:
eremon9
"I use historical prices and historical dividends (preferably split-adjusted, both) to calculate historical yields."
I too do something like that with WFC-PL, where the dividend is a fixed percentage of the par value, and the meaningful price is unadjusted for dividends. Splits aren't an issue in this case.
Tom
I too do something like that with WFC-PL, where the dividend is a fixed percentage of the par value, and the meaningful price is unadjusted for dividends. Splits aren't an issue in this case.
Tom
Mon May 22, 2017 3:52 pm (PDT) . Posted by:
"Brad Reel" reeldeal9090
Ahh...I am probably missing the view. I found those screens, but never
found the right view. Didn't connect the dots. Thanks, I'll look again.
I appreciate it!
On Mon, May 22, 2017 at 5:14 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> T
> he screening I did on barchart.com was not a premium feature. All I have
> is a free account. I did need to logon into the account, using the EXCEL
> Query dialog, before I could use smfGetCSVFile() to grab the screener
> output in EXCEL, but that's independent of using the screener in a browser.
>
> I logged out to see what steps I needed to go through.
>
> 1. I click on the "My Barchart" banner option and choose "Organize
> Screeners".
> 2. It prompts me to log in to my free account, so I do.
>
> Voila, I'm there.
>
> Note that "screens" and "views" are separately defined, so you will have
> to create your own custom view as well as whatever screening you want to
> do. They have so many choices of fields to display. However, I think the
> view is limited to 12 fields? Not sure.
>
> The free account has limits of 10 exports a day and 1000 tickers per
> export.
>
>
> On Mon, May 22, 2017 at 2:26 PM, brad.reel@yahoo.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Randy - I really hate asking this because I know you've been busting your
>> tail for the last couple of weeks dealing with issues, etc. I really like
>> the information in your 50 day screener example and was hoping to recreate
>> and use. I've poked all around BarChart trying to figure out how to
>> recreate with zero luck. I am a free member and maybe that's a premium
>> feature. Can you either point me at a URL or maybe confirm if you use paid
>> service?
>>
>> Thanks again for everything. You are awesome.
>>
>>
>
>
found the right view. Didn't connect the dots. Thanks, I'll look again.
I appreciate it!
On Mon, May 22, 2017 at 5:14 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> T
> he screening I did on barchart.com was not a premium feature. All I have
> is a free account. I did need to logon into the account, using the EXCEL
> Query dialog, before I could use smfGetCSVFile() to grab the screener
> output in EXCEL, but that's independent of using the screener in a browser.
>
> I logged out to see what steps I needed to go through.
>
> 1. I click on the "My Barchart" banner option and choose "Organize
> Screeners".
> 2. It prompts me to log in to my free account, so I do.
>
> Voila, I'm there.
>
> Note that "screens" and "views" are separately defined, so you will have
> to create your own custom view as well as whatever screening you want to
> do. They have so many choices of fields to display. However, I think the
> view is limited to 12 fields? Not sure.
>
> The free account has limits of 10 exports a day and 1000 tickers per
> export.
>
>
> On Mon, May 22, 2017 at 2:26 PM, brad.reel@yahoo.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Randy - I really hate asking this because I know you've been busting your
>> tail for the last couple of weeks dealing with issues, etc. I really like
>> the information in your 50 day screener example and was hoping to recreate
>> and use. I've poked all around BarChart trying to figure out how to
>> recreate with zero luck. I am a free member and maybe that's a premium
>> feature. Can you either point me at a URL or maybe confirm if you use paid
>> service?
>>
>> Thanks again for everything. You are awesome.
>>
>>
>
>
Mon May 22, 2017 4:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yup. I quickly threw together a custom view with a bunch of fields similar
to the 50-day moving average or performance...
Like I said, there are tons of fields.
On Mon, May 22, 2017 at 3:52 PM, Brad Reel brad.reel90@
...wrote:
>
> Ahh...I am probably missing the view. I found those screens, but never
> found the right view. Didn't connect the dots. Thanks, I'll look again.
> I appreciate it!
>
>
to the 50-day moving average or performance.
Like I said, there are tons of fields.
On Mon, May 22, 2017 at 3:52 PM, Brad Reel brad.reel90@
...wrote:
>
> Ahh...I am probably missing the view. I found those screens, but never
> found the right view. Didn't connect the dots. Thanks, I'll look again.
> I appreciate it!
>
>
Mon May 22, 2017 4:42 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
The spreadsheet opens fine, no messages. I clicked on macros on the ribbon and it doesn't show any macros including the smfFixLinks. The XLA is in a directory called SMF Add-in. The Options selection on the FILE tab allows me to check add-ins and it saysthe smfFixLinks XLA is active. IF I redo the add-in, that is using the options/add-in menu then the Get Quotes function loads the data BUT if I save the spreadsheet I'm back to #NAME? unless I do the add-in function again. This process does not help the Version function.
BTW the ADD-IN tab on the ribbon also shows no add-ins. So the strangeness is the options/add-in shows the add-in as active but nothing else shows the add-in ore the macro. I'm sure I'm doing something really wrong here just not sure what it is.
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 5:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
Try this:
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the add-in (or the function) in that location and marked those as unresolved links. You should have gotten an error message when opening the workbook. Those unresolved links need to be resolved before the workbook will function properly -- it will give #NAME? errors for them, BECAUSE they are unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw' lswpubrw@
...wrote:
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumber("Version")
and
=RCHGetYahooQuotes($A$7,"l1")
Still giving me #Name?
The spreadsheet opens fine, no messages. I clicked on macros on the ribbon and it doesn't show any macros including the smfFixLinks. The XLA is in a directory called SMF Add-in. The Options selection on the FILE tab allows me to check add-ins and it saysthe smfFixLinks XLA is active. IF I redo the add-in, that is using the options/add-in menu then the Get Quotes function loads the data BUT if I save the spreadsheet I'm back to #NAME? unless I do the add-in function again. This process does not help the Version function.
BTW the ADD-IN tab on the ribbon also shows no add-ins. So the strangeness is the options/add-in shows the add-in as active but nothing else shows the add-in ore the macro. I'm sure I'm doing something really wrong here just not sure what it is.
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 5:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
Try this:
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the add-in (or the function) in that location and marked those as unresolved links. You should have gotten an error message when opening the workbook. Those unresolved links need to be resolved before the workbook will function properly -- it will give #NAME? errors for them, BECAUSE they are unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw&#
...wrote:
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumbe
and
=RCHGetYahooQuotes(
Still giving me #Name?
Mon May 22, 2017 4:51 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
Just tried to create a new workbook as you suggested. Version function returns #NAME? so apparently add-in is not active even though the add-in under EXCEL Options says it is active. Strange.
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 5:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
Try this:
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the add-in (or the function) in that location and marked those as unresolved links. You should have gotten an error message when opening the workbook. Those unresolved links need to be resolved before the workbook will function properly -- it will give #NAME? errors for them, BECAUSE they are unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw' lswpubrw@
...wrote:
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumber("Version")
and
=RCHGetYahooQuotes($A$7,"l1")
Still giving me #Name?
Just tried to create a new workbook as you suggested. Version function returns #NAME? so apparently add-in is not active even though the add-in under EXCEL Options says it is active. Strange.
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 5:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
Try this:
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the add-in (or the function) in that location and marked those as unresolved links. You should have gotten an error message when opening the workbook. Those unresolved links need to be resolved before the workbook will function properly -- it will give #NAME? errors for them, BECAUSE they are unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw&#
...wrote:
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumbe
and
=RCHGetYahooQuotes(
Still giving me #Name?
Mon May 22, 2017 5:00 pm (PDT) . Posted by:
"Craig Passow" passow
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On 5/22/2017 6:31 PM, 'lswpubrw' lswpubrw@optonline.net [smf_addin] wrote:
>
>
> Randy,
>
> Just tried to create a new workbook as you suggested. Version
> function returns #NAME? so apparently add-in is not active even though
> the add-in under EXCEL Options says it is active. Strange.
>
> Bob
>
> lswpubrw@optonline.net
> warasir@sunysuffolk.edu
> bobwarasila@lswpub.com
>
> *From:* Randy Harmelink rharmelink@gmail.com [smf_addin]
> *Sent:* Monday, May 22, 2017 5:34 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] installation.
>
>
>
> Try this:
>
> 1. Close EXCEL
> 2. Open EXCEL
> 3. Create a new workbook
> 4. Then use the "Version" function
>
> If you get #NAME? back, it means the add-in is not active.
>
> When you mention having to remove links, it mean EXCEL couldn't find
> the add-in (or the function) in that location and marked those as
> unresolved links. You should have gotten an error message when opening
> the workbook. Those unresolved links need to be resolved before the
> workbook will function properly -- it will give #NAME? errors for
> them, BECAUSE they are unresolved links.
>
> The best way to remove such unresolved links is to use the smfFixLinks
> macro in the add-in.
>
>
>
> On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw&#
> ...wrote:
>
>
> I'm continuing to have the same problem. My Add-In manager says
> the SMF XLA is installed and active and my Windows updates are
> all up-to-date. The file in the SMF folder is the one I downloaded
> on 5/21 so I'm assuming it's the new one. I've removed the links
> on the front of the commands, now using only
>
> =RCHGetElementNumbe
> and
> =RCHGetYahooQuotes(
> Still giving me #Name?
>
>
>
>
>
Mon May 22, 2017 5:18 pm (PDT) . Posted by:
"lswpubrw" lswpubrlw
Randy,
I went backwards and reinstalled the XLA that's on the web site. Had to redo the add-in manager and it works fine with the RCHGetYahooQuotes function. However the RCHGetElementNumber("Version") returns #VALUE?. At least I'm back to extracting quotes. For some reason the 5/21/2017 version doesn't work with this spreadsheet:^ ( Do I have to change the =RCHGetYahooQuotes(#,#) somehow?
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 5:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
Try this:
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the add-in (or the function) in that location and marked those as unresolved links. You should have gotten an error message when opening the workbook. Those unresolved links need to be resolved before the workbook will function properly -- it will give #NAME? errors for them, BECAUSE they are unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw' lswpubrw@
...wrote:
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumber("Version")
and
=RCHGetYahooQuotes($A$7,"l1")
Still giving me #Name?
I went backwards and reinstalled the XLA that's on the web site. Had to redo the add-in manager and it works fine with the RCHGetYahooQuotes function. However the RCHGetElementNumber("Version") returns #VALUE?. At least I'm back to extracting quotes. For some reason the 5/21/2017 version doesn't work with this spreadsheet:^ ( Do I have to change the =RCHGetYahooQuotes(#,#) somehow?
Bob
lswpubrw@optonline.net
warasir@sunysuffolk.edu
bobwarasila@lswpub.com
From: Randy Harmelink rharmelink@gmail.com [smf_addin]
Sent: Monday, May 22, 2017 5:34 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] installation.
Try this:
1. Close EXCEL
2. Open EXCEL
3. Create a new workbook
4. Then use the "Version" function
If you get #NAME? back, it means the add-in is not active.
When you mention having to remove links, it mean EXCEL couldn't find the add-in (or the function) in that location and marked those as unresolved links. You should have gotten an error message when opening the workbook. Those unresolved links need to be resolved before the workbook will function properly -- it will give #NAME? errors for them, BECAUSE they are unresolved links.
The best way to remove such unresolved links is to use the smfFixLinks macro in the add-in.
On Mon, May 22, 2017 at 1:48 PM, 'lswpubrw&#
...wrote:
I'm continuing to have the same problem. My Add-In manager says the SMF XLA is installed and active and my Windows updates are all up-to-date. The file in the SMF folder is the one I downloaded on 5/21 so I'm assuming it's the new one. I've removed the links on the front of the commands, now using only
=RCHGetElementNumbe
and
=RCHGetYahooQuotes(
Still giving me #Name?
Mon May 22, 2017 6:12 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
RCHGetYahooQuotes() wasn't changed.
The "Version" formula doesn't even do anything with the Internet. A #VALUE?
error often means the wrong type of parameter is being passed. I notice
your quotation below use a left double quote and a right double quote
instead of the normal double quote. Is that the problem?
On Mon, May 22, 2017 at 4:57 PM, 'lswpubrw' lswpubrw@optonline.net
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> I went backwards and reinstalled the XLA that's on the web site. Had to
> redo the add-in manager and it works fine with the RCHGetYahooQuotes
> function. However the RCHGetElementNumber("Version") returns #VALUE?. At
> least I'm back to extracting quotes. For some reason the 5/21/2017 version
> doesn't work with this spreadsheet:^ ( Do I have to change the
> =RCHGetYahooQuotes(#,#) somehow?
>
The "Version" formula doesn't even do anything with the Internet. A #VALUE?
error often means the wrong type of parameter is being passed. I notice
your quotation below use a left double quote and a right double quote
instead of the normal double quote. Is that the problem?
On Mon, May 22, 2017 at 4:57 PM, 'lswpubrw' lswpubrw@optonline.net
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> I went backwards and reinstalled the XLA that's on the web site. Had to
> redo the add-in manager and it works fine with the RCHGetYahooQuotes
> function. However the RCHGetElementNumber
> least I'm back to extracting quotes. For some reason the 5/21/2017 version
> doesn't work with this spreadsheet:
> =RCHGetYahooQuotes(
>
Mon May 22, 2017 6:14 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As Craig suspects, you may have the Microsoft security issue, and need to
unblock he XLA file? See the link he cited:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
The add-in would not show up on the Add-in Tab on the ribbon.
On Mon, May 22, 2017 at 4:22 PM, 'lswpubrw' lswpubrw@optonline.net
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> The spreadsheet opens fine, no messages. I clicked on macros on the
> ribbon and it doesn't show any macros including the smfFixLinks. The XLA
> is in a directory called SMF Add-in. The Options selection on the FILE tab
> allows me to check add-ins and it saysthe smfFixLinks XLA is active. IF
> I redo the add-in, that is using the options/add-in menu then the Get
> Quotes function loads the data BUT if I save the spreadsheet I'm back to
> #NAME? unless I do the add-in function again. This process does not help
> the Version function.
>
> BTW the ADD-IN tab on the ribbon also shows no add-ins. So the
> strangeness is the options/add-in shows the add-in as active but nothing
> else shows the add-in ore the macro. I'm sure I'm doing something really
> wrong here just not sure what it is.
>
>
>
unblock he XLA file? See the link he cited:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
The add-in would not show up on the Add-in Tab on the ribbon.
On Mon, May 22, 2017 at 4:22 PM, 'lswpubrw' lswpubrw@optonline.net
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> The spreadsheet opens fine, no messages. I clicked on macros on the
> ribbon and it doesn't show any macros including the smfFixLinks. The XLA
> is in a directory called SMF Add-in. The Options selection on the FILE tab
> allows me to check add-ins and it saysthe smfFixLinks XLA is active. IF
> I redo the add-in, that is using the options/add-
> Quotes function loads the data BUT if I save the spreadsheet I'm back to
> #NAME? unless I do the add-in function again. This process does not help
> the Version function.
>
> BTW the ADD-IN tab on the ribbon also shows no add-ins. So the
> strangeness is the options/add-
> else shows the add-in ore the macro. I'm sure I'm doing something really
> wrong here just not sure what it is.
>
>
>
Mon May 22, 2017 6:02 pm (PDT) . Posted by:
"Peter James" pmjzz
Randy:
Is TODAY() also volatile?
Peter
On 2017-05-21 15:29, Randy Harmelink rharmelink@gmail.com [smf_addin] wrote:
>
> P.S. You should not use NOW() in a function like that. It makes the
> cell volatile, which means it will recalculate any time ANYTHING in
> the workbook is changed.
Is TODAY() also volatile?
Peter
On 2017-05-21 15:29, Randy Harmelink rharmelink@gmail.com [smf_addin] wrote:
>
> P.S. You should not use NOW() in a function like that. It makes the
> cell volatile, which means it will recalculate any time ANYTHING in
> the workbook is changed.
Mon May 22, 2017 6:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yes.
http://www.decisionmodels.com/calcsecretsi.htm
On Mon, May 22, 2017 at 5:55 PM, Peter James peter00james@
...
wrote:
> Is TODAY() also volatile?
>
http://www.decisionmodels.com/calcsecretsi.htm
On Mon, May 22, 2017 at 5:55 PM, Peter James peter00james@
...
wrote:
> Is TODAY() also volatile?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar