15 Messages
Digest #4034
Messages
Thu May 25, 2017 7:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
In what context? This is what I get for recent history using
smfGetYahooHistory("MMM"):
*Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
*Dividend* *Split*
2017-05-25 $198.41 $199.61 $197.75 $199.54 1460300 $199.54 1.0000 1.0000
2017-05-24 $198.49 $198.53 $197.28 $197.49 1206400 $197.49 1.0000 1.0000
2017-05-23 $198.73 $198.97 $197.52 $197.73 1514200 $197.73 1.0000 1.0000
2017-05-22 $196.35 $198.67 $196.35 $198.51 1835900 $198.51 1.0000 1.0000
2017-05-19 $196.30 $196.30 $194.45 $195.80 1894700 $195.80 1.0000 1.0000
2017-05-18 $194.50 $195.82 $193.54 $195.24 1929000 $195.24 1.0000 1.0000
2017-05-17 $196.74 $196.74 $194.72 $194.84 1881800 $194.84 1.0000 1.0000
$1.18
2017-05-16 $196.31 $196.76 $195.69 $196.74 1183600 $197.91 0.9941 1.0000
2017-05-15 $195.50 $196.57 $195.07 $196.46 1474500 $197.63 0.9941 1.0000
On Thu, May 25, 2017 at 7:12 PM, paul@
...wrote:
>
> Are you getting a proper "adjusted close"? I seem to only get the "close"
> without any adjustments for dividends.
>
smfGetYahooHistory(
*Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
*Dividend* *Split*
2017-05-25 $198.41 $199.61 $197.75 $199.54 1460300 $199.54 1.0000 1.0000
2017-05-24 $198.49 $198.53 $197.28 $197.49 1206400 $197.49 1.0000 1.0000
2017-05-23 $198.73 $198.97 $197.52 $197.73 1514200 $197.73 1.0000 1.0000
2017-05-22 $196.35 $198.67 $196.35 $198.51 1835900 $198.51 1.0000 1.0000
2017-05-19 $196.30 $196.30 $194.45 $195.80 1894700 $195.80 1.0000 1.0000
2017-05-18 $194.50 $195.82 $193.54 $195.24 1929000 $195.24 1.0000 1.0000
2017-05-17 $196.74 $196.74 $194.72 $194.84 1881800 $194.84 1.0000 1.0000
$1.18
2017-05-16 $196.31 $196.76 $195.69 $196.74 1183600 $197.91 0.9941 1.0000
2017-05-15 $195.50 $196.57 $195.07 $196.46 1474500 $197.63 0.9941 1.0000
On Thu, May 25, 2017 at 7:12 PM, paul@
...wrote:
>
> Are you getting a proper "adjusted close"? I seem to only get the "close"
> without any adjustments for dividends.
>
Thu May 25, 2017 8:39 pm (PDT) . Posted by:
"Paul Austin" jpaulaustin
Randy,
That does seem to work. I was looking at the quote.yahoo.com site and it
isn't making the adjustments any more so I thought the downloads wouldn't
be adjusted either. I also went back through your comments and found the
new backward compatible version and all is well with the world again!
Thank you again so much!
Paul
On Thu, May 25, 2017 at 10:30 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> In what context? This is what I get for recent history using
> smfGetYahooHistory("MMM"):
>
> *Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
> *Dividend* *Split*
> 2017-05-25 $198.41 $199.61 $197.75 $199.54 1460300 $199.54 1.0000 1.0000
>
> 2017-05-24 $198.49 $198.53 $197.28 $197.49 1206400 $197.49 1.0000 1.0000
>
> 2017-05-23 $198.73 $198.97 $197.52 $197.73 1514200 $197.73 1.0000 1.0000
>
> 2017-05-22 $196.35 $198.67 $196.35 $198.51 1835900 $198.51 1.0000 1.0000
>
> 2017-05-19 $196.30 $196.30 $194.45 $195.80 1894700 $195.80 1.0000 1.0000
>
> 2017-05-18 $194.50 $195.82 $193.54 $195.24 1929000 $195.24 1.0000 1.0000
>
> 2017-05-17 $196.74 $196.74 $194.72 $194.84 1881800 $194.84 1.0000 1.0000
> $1.18
> 2017-05-16 $196.31 $196.76 $195.69 $196.74 1183600 $197.91 0.9941 1.0000
>
> 2017-05-15 $195.50 $196.57 $195.07 $196.46 1474500 $197.63 0.9941 1.0000
>
>
> On Thu, May 25, 2017 at 7:12 PM, paul@
> ...wrote:
>
>>
>> Are you getting a proper "adjusted close"? I seem to only get the "close"
>> without any adjustments for dividends.
>>
>
>
>
That does seem to work. I was looking at the quote.yahoo.com site and it
isn't making the adjustments any more so I thought the downloads wouldn't
be adjusted either. I also went back through your comments and found the
new backward compatible version and all is well with the world again!
Thank you again so much!
Paul
On Thu, May 25, 2017 at 10:30 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> In what context? This is what I get for recent history using
> smfGetYahooHistory(
>
> *Date* *Open* *High* *Low* *Close* *Volume* *Unadj* *Div Adj* *Split Adj*
> *Dividend* *Split*
> 2017-05-25 $198.41 $199.61 $197.75 $199.54 1460300 $199.54 1.0000 1.0000
>
> 2017-05-24 $198.49 $198.53 $197.28 $197.49 1206400 $197.49 1.0000 1.0000
>
> 2017-05-23 $198.73 $198.97 $197.52 $197.73 1514200 $197.73 1.0000 1.0000
>
> 2017-05-22 $196.35 $198.67 $196.35 $198.51 1835900 $198.51 1.0000 1.0000
>
> 2017-05-19 $196.30 $196.30 $194.45 $195.80 1894700 $195.80 1.0000 1.0000
>
> 2017-05-18 $194.50 $195.82 $193.54 $195.24 1929000 $195.24 1.0000 1.0000
>
> 2017-05-17 $196.74 $196.74 $194.72 $194.84 1881800 $194.84 1.0000 1.0000
> $1.18
> 2017-05-16 $196.31 $196.76 $195.69 $196.74 1183600 $197.91 0.9941 1.0000
>
> 2017-05-15 $195.50 $196.57 $195.07 $196.46 1474500 $197.63 0.9941 1.0000
>
>
> On Thu, May 25, 2017 at 7:12 PM, paul@
> ...wrote:
>
>>
>> Are you getting a proper "adjusted close"? I seem to only get the "close"
>> without any adjustments for dividends.
>>
>
>
>
Thu May 25, 2017 9:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The smfGetYahooHistory() function is doing the adjustment for dividends. If
Yahoo ever gets around to doing it, I'll need to unplug that processing.
That's why anything other than daily data ending with the current day's
data might not be adjusted correctly for dividends. The function needs the
daily data to apply the adjustments properly. And it needs to have all of
the most recent data to get all of the applicable dividends.
On Thu, May 25, 2017 at 8:39 PM, Paul Austin paul@
...wrote:
>
> That does seem to work. I was looking at the quote.yahoo.com site and it
> isn't making the adjustments any more so I thought the downloads wouldn't
> be adjusted either. I also went back through your comments and found the
> new backward compatible version and all is well with the world again!
>
Yahoo ever gets around to doing it, I'll need to unplug that processing.
That's why anything other than daily data ending with the current day's
data might not be adjusted correctly for dividends. The function needs the
daily data to apply the adjustments properly. And it needs to have all of
the most recent data to get all of the applicable dividends.
On Thu, May 25, 2017 at 8:39 PM, Paul Austin paul@
...wrote:
>
> That does seem to work. I was looking at the quote.yahoo.
> isn't making the adjustments any more so I thought the downloads wouldn't
> be adjusted either. I also went back through your comments and found the
> new backward compatible version and all is well with the world again!
>
Thu May 25, 2017 9:46 pm (PDT) . Posted by:
"Paul Austin" jpaulaustin
Do you happen to have all the parameters for the smfGetYahooHistory? Or are
they the same as from the original download?
I only have the following sample:
'=smfGetYahooHistory("IBM","3/1/2017","3/1/2017","d","c",0)
It seems like I saw some other parameters in one of your examples.
On Thu, May 25, 2017 at 11:55 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The smfGetYahooHistory() function is doing the adjustment for dividends.
> If Yahoo ever gets around to doing it, I'll need to unplug that
> processing.
>
> That's why anything other than daily data ending with the current day's
> data might not be adjusted correctly for dividends. The function needs the
> daily data to apply the adjustments properly. And it needs to have all of
> the most recent data to get all of the applicable dividends.
>
> On Thu, May 25, 2017 at 8:39 PM, Paul Austin paul@
> ...wrote:
>
>>
>> That does seem to work. I was looking at the quote.yahoo.com site and it
>> isn't making the adjustments any more so I thought the downloads wouldn't
>> be adjusted either. I also went back through your comments and found the
>> new backward compatible version and all is well with the world again!
>>
>
>
>
they the same as from the original download?
I only have the following sample:
'=smfGetYahooHistory("IBM","3/1/2017","3/1/2017","d","c",0)
It seems like I saw some other parameters in one of your examples.
On Thu, May 25, 2017 at 11:55 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The smfGetYahooHistory(
> If Yahoo ever gets around to doing it, I'll need to unplug that
> processing.
>
> That's why anything other than daily data ending with the current day's
> data might not be adjusted correctly for dividends. The function needs the
> daily data to apply the adjustments properly. And it needs to have all of
> the most recent data to get all of the applicable dividends.
>
> On Thu, May 25, 2017 at 8:39 PM, Paul Austin paul@
> ...wrote:
>
>>
>> That does seem to work. I was looking at the quote.yahoo.
>> isn't making the adjustments any more so I thought the downloads wouldn't
>> be adjusted either. I also went back through your comments and found the
>> new backward compatible version and all is well with the world again!
>>
>
>
>
Thu May 25, 2017 10:17 pm (PDT) . Posted by:
"Paul Austin" jpaulaustin
I know you're already way overworked, but do you have any plans to make
the monthly data for adjusted close work?
On Thu, May 25, 2017 at 11:55 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The smfGetYahooHistory() function is doing the adjustment for dividends.
> If Yahoo ever gets around to doing it, I'll need to unplug that
> processing.
>
> That's why anything other than daily data ending with the current day's
> data might not be adjusted correctly for dividends. The function needs the
> daily data to apply the adjustments properly. And it needs to have all of
> the most recent data to get all of the applicable dividends.
>
> On Thu, May 25, 2017 at 8:39 PM, Paul Austin paul@
> ...wrote:
>
>>
>> That does seem to work. I was looking at the quote.yahoo.com site and it
>> isn't making the adjustments any more so I thought the downloads wouldn't
>> be adjusted either. I also went back through your comments and found the
>> new backward compatible version and all is well with the world again!
>>
>
>
>
the monthly data for adjusted close work?
On Thu, May 25, 2017 at 11:55 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The smfGetYahooHistory(
> If Yahoo ever gets around to doing it, I'll need to unplug that
> processing.
>
> That's why anything other than daily data ending with the current day's
> data might not be adjusted correctly for dividends. The function needs the
> daily data to apply the adjustments properly. And it needs to have all of
> the most recent data to get all of the applicable dividends.
>
> On Thu, May 25, 2017 at 8:39 PM, Paul Austin paul@
> ...wrote:
>
>>
>> That does seem to work. I was looking at the quote.yahoo.
>> isn't making the adjustments any more so I thought the downloads wouldn't
>> be adjusted either. I also went back through your comments and found the
>> new backward compatible version and all is well with the world again!
>>
>
>
>
Thu May 25, 2017 11:37 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Some documentation of the parameters is here:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Thu, May 25, 2017 at 9:46 PM, Paul Austin paul@
...wrote:
>
> Do you happen to have all the parameters for the smfGetYahooHistory? Or
> are they the same as from the original download?
> I only have the following sample:
> '=smfGetYahooHistory("IBM","3/1/2017","3/1/2017","d","c",0)
> It seems like I saw some other parameters in one of your examples.
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
On Thu, May 25, 2017 at 9:46 PM, Paul Austin paul@
...wrote:
>
> Do you happen to have all the parameters for the smfGetYahooHistory? Or
> are they the same as from the original download?
> I only have the following sample:
> '=smfGetYahooHi
> It seems like I saw some other parameters in one of your examples.
>
>
Fri May 26, 2017 12:35 am (PDT) . Posted by:
halstian1
Hi Randy and other users
FWIW I've tested the daily function on a number of US and European stocks versus the data downloaded with the RCHGetYahooHistory function prior to its shutdown by Yahoo in mid-May. There are some minor discrepancies on the US stocks, which appears to be due to some dividend adjustments not being processed in the same way, but nothing significant that would invalidate the data for what I use it for
On the European stocks, there seems to be a number of date differences (ie missing bank holidays and other random days). Some minor issues with the back-adjustment as well. But again nothing material that would invalidate the use of the data.
On a separate issue, the beta version of the xla from 25 May doesnt load properly for me when Excel opens. I need to shut off the Add in in Excel Add ins, and then go back and tick the add-in again and it works. Not a major issue but would be nice to resolve if anyone else has come across this.
I'd echo sentiments of everyone this forum in thanking Randy for all his hard work on this add-in over the past number of years.
FWIW I've tested the daily function on a number of US and European stocks versus the data downloaded with the RCHGetYahooHistory function prior to its shutdown by Yahoo in mid-May. There are some minor discrepancies on the US stocks, which appears to be due to some dividend adjustments not being processed in the same way, but nothing significant that would invalidate the data for what I use it for
On the European stocks, there seems to be a number of date differences (ie missing bank holidays and other random days). Some minor issues with the back-adjustment as well. But again nothing material that would invalidate the use of the data.
On a separate issue, the beta version of the xla from 25 May doesnt load properly for me when Excel opens. I need to shut off the Add in in Excel Add ins, and then go back and tick the add-in again and it works. Not a major issue but would be nice to resolve if anyone else has come across this.
I'd echo sentiments of everyone this forum in thanking Randy for all his hard work on this add-in over the past number of years.
Fri May 26, 2017 12:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Your loading issue may be the pesky Microsoft security update they applied
last August. Unblocking the XLA file may fix the issue. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Fri, May 26, 2017 at 12:35 AM, halstian1@
...wrote:
>
> Hi Randy and other users
>
> FWIW I've tested the daily function on a number of US and European stocks
> versus the data downloaded with the RCHGetYahooHistory function prior to
> its shutdown by Yahoo in mid-May. There are some minor discrepancies on the
> US stocks, which appears to be due to some dividend adjustments not being
> processed in the same way, but nothing significant that would invalidate
> the data for what I use it for
>
> On the European stocks, there seems to be a number of date differences (ie
> missing bank holidays and other random days). Some minor issues with the
> back-adjustment as well. But again nothing material that would invalidate
> the use of the data.
>
> On a separate issue, the beta version of the xla from 25 May doesnt load
> properly for me when Excel opens. I need to shut off the Add in in Excel
> Add ins, and then go back and tick the add-in again and it works. Not a
> major issue but would be nice to resolve if anyone else has come across
> this.
>
> I'd echo sentiments of everyone this forum in thanking Randy for all his
> hard work on this add-in over the past number of years.
>
>
last August. Unblocking the XLA file may fix the issue. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
On Fri, May 26, 2017 at 12:35 AM, halstian1@
...wrote:
>
> Hi Randy and other users
>
> FWIW I've tested the daily function on a number of US and European stocks
> versus the data downloaded with the RCHGetYahooHistory function prior to
> its shutdown by Yahoo in mid-May. There are some minor discrepancies on the
> US stocks, which appears to be due to some dividend adjustments not being
> processed in the same way, but nothing significant that would invalidate
> the data for what I use it for
>
> On the European stocks, there seems to be a number of date differences (ie
> missing bank holidays and other random days). Some minor issues with the
> back-adjustment as well. But again nothing material that would invalidate
> the use of the data.
>
> On a separate issue, the beta version of the xla from 25 May doesnt load
> properly for me when Excel opens. I need to shut off the Add in in Excel
> Add ins, and then go back and tick the add-in again and it works. Not a
> major issue but would be nice to resolve if anyone else has come across
> this.
>
> I'd echo sentiments of everyone this forum in thanking Randy for all his
> hard work on this add-in over the past number of years.
>
>
Fri May 26, 2017 12:45 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm considering what to do. There are weekly/monthly/quarterly/annual
periods to work out.
I'm thinking it would be easiest as a separate function.
One option I'm considering is to allow another parameter to go to
smfPricesByDates(), and letting it create multi-row output. So, for
example, weekly data would go from the ending to the starting date with the
date range changing by 7 on each row -- if you said you wanted weekly data
from 5/1 to 5/25, you'd get output for each of the following date ranges:
2017-05-19 to 2017-05-25
2017-05-12 to 2017-05-18
2017-05-05 to 2017-05-11
2017-04-28 to 2017-05-04
I'd then want to add columns for cumulative dividends during the period and
notes of splits during the period. Unsure about the dividend and split
adjustment factors, since they can vary during a period. Maybe just state
them for the end of the period?
On Thu, May 25, 2017 at 10:17 PM, Paul Austin paul@
...wrote:
>
> I know you're already way overworked, but do you have any plans to make
> the monthly data for adjusted close work?
>
>
>
periods to work out.
I'm thinking it would be easiest as a separate function.
One option I'm considering is to allow another parameter to go to
smfPricesByDates(
example, weekly data would go from the ending to the starting date with the
date range changing by 7 on each row -- if you said you wanted weekly data
from 5/1 to 5/25, you'd get output for each of the following date ranges:
2017-05-19 to 2017-05-25
2017-05-12 to 2017-05-18
2017-05-05 to 2017-05-11
2017-04-28 to 2017-05-04
I'd then want to add columns for cumulative dividends during the period and
notes of splits during the period. Unsure about the dividend and split
adjustment factors, since they can vary during a period. Maybe just state
them for the end of the period?
On Thu, May 25, 2017 at 10:17 PM, Paul Austin paul@
...wrote:
>
> I know you're already way overworked, but do you have any plans to make
> the monthly data for adjusted close work?
>
>
>
Thu May 25, 2017 7:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
At least as many, but more won't hurt when you're giving a date range. The
function will just fill with the dates and leave anything extra empty.
On Thu, May 25, 2017 at 7:20 PM, tmallen2@
...wrote:
>
> So I need to have as many rows as days in the date range correct?
>
> This formula should work.
>
>
>
function will just fill with the dates and leave anything extra empty.
On Thu, May 25, 2017 at 7:20 PM, tmallen2@
...wrote:
>
> So I need to have as many rows as days in the date range correct?
>
> This formula should work.
>
>
>
Fri May 26, 2017 6:59 am (PDT) . Posted by:
"Joe Williams" joseph_c_williams
As reported and discussed last July, I'm having issues with loading the
add-in file (Excel 2013)
I have made sure that:
a) the add-in file is stored in a 'trusted location'
b) the add-in file is 'unblocked' after downloading to the trusted
location
but I still have to manually reload (re-install) the add-in file every time
I load the spreadsheet or the add-in's functions don't work.
Another clue: spreadsheet cells show full paths:
='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfPricesByDates(C1,A)
instead of just the function call:
=smfPricesByDates(C1,A5)
prior to reloading the add-in.
Can anyone help me with this?
add-in file (Excel 2013)
I have made sure that:
a) the add-in file is stored in a 'trusted location'
b) the add-in file is 'unblocked&#
location
but I still have to manually reload (re-install) the add-in file every time
I load the spreadsheet or the add-in's functions don't work.
Another clue: spreadsheet cells show full paths:
='C:\
instead of just the function call:
=smfPricesByDates(
prior to reloading the add-in.
Can anyone help me with this?
Fri May 26, 2017 8:35 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You get the full path in front of the function BECAUSE the add-in isn't
loaded, so that's something to be expected.
Other than the unblocking or trust location, the only other thing I can
think of is to have you open up the add-in code in the VBA and save it.
Because the security issue said something about files downloaded from the
Internet. Saving it yourself may make it appear to be something locally
sourced?
Hmmm. You aren't on a corporate computer, where they have something to
prevent add-ins from being loaded? Or have startup switches on your
invocation of EXCEL? For example, I think "/s" (for safe mode) might
prevent add-ins from being loaded.
On Fri, May 26, 2017 at 6:59 AM, Joe Williams joe.c.williams@
...wrote:
>
> As reported and discussed last July, I'm having issues with loading the
> add-in file (Excel 2013)
>
> I have made sure that:
> a) the add-in file is stored in a 'trusted location'
> b) the add-in file is 'unblocked' after downloading to the trusted
> location
>
> but I still have to manually reload (re-install) the add-in file every
> time I load the spreadsheet or the add-in's functions don't work.
>
> Another clue: spreadsheet cells show full paths:
> ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfPricesByDates(C1,A)
> instead of just the function call:
> =smfPricesByDates(C1,A5)
> prior to reloading the add-in.
>
> Can anyone help me with this?
>
>
loaded, so that's something to be expected.
Other than the unblocking or trust location, the only other thing I can
think of is to have you open up the add-in code in the VBA and save it.
Because the security issue said something about files downloaded from the
Internet. Saving it yourself may make it appear to be something locally
sourced?
Hmmm. You aren't on a corporate computer, where they have something to
prevent add-ins from being loaded? Or have startup switches on your
invocation of EXCEL? For example, I think "/s" (for safe mode) might
prevent add-ins from being loaded.
On Fri, May 26, 2017 at 6:59 AM, Joe Williams joe.c.williams@
...wrote:
>
> As reported and discussed last July, I'm having issues with loading the
> add-in file (Excel 2013)
>
> I have made sure that:
> a) the add-in file is stored in a 'trusted location'
> b) the add-in file is 'unblocked&#
> location
>
> but I still have to manually reload (re-install) the add-in file every
> time I load the spreadsheet or the add-in's functions don't work.
>
> Another clue: spreadsheet cells show full paths:
> ='C:\
> instead of just the function call:
> =smfPricesByDates(
> prior to reloading the add-in.
>
> Can anyone help me with this?
>
>
Fri May 26, 2017 8:36 am (PDT) . Posted by:
al_castle
I downloaded the latest version of SMF and still can't get the historical quotes from yahoo. I get a blank cell in return, any ideas?
Thank you.
Thank you.
Fri May 26, 2017 8:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Make sure you have the current *beta* version loaded -- what do you get
with:
=RCHGetElementNumber("Version")
You need to have 2017.05.25 loaded. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
On Fri, May 26, 2017 at 8:32 AM, al_castle@
...wrote:
>
> I downloaded the latest version of SMF and still can't get the historical
> quotes from yahoo. I get a blank cell in return, any ideas?
>
>
>
with:
=RCHGetElementNumber("Version")
You need to have 2017.05.25 loaded. See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
On Fri, May 26, 2017 at 8:32 AM, al_castle@
...wrote:
>
> I downloaded the latest version of SMF and still can't get the historical
> quotes from yahoo. I get a blank cell in return, any ideas?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar