5 Messages
Digest #4573
Messages
Thu Jul 11, 2019 6:20 am (PDT) . Posted by:
"Brad Reel" reeldeal9090
I run Office 365 64 bit version without issue. Not sure how that compares
to Excel 2019, but I'd be shocked if it were a problem and I've heard
nothing about Microsoft dropping VBA.
On Wed, Jul 10, 2019 at 10:23 AM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> No idea, sorry. But I doubt they would dump VBA and add-in capabilities
> without some kind of backward compatibility?
>
> On Wed, Jul 10, 2019 at 6:12 AM a.bereziuk@... wrote:
>
>>
>> will the addin work correctly with Excel 2019 x64?
>>
>>
>>
>
to Excel 2019, but I'd be shocked if it were a problem and I've heard
nothing about Microsoft dropping VBA.
On Wed, Jul 10, 2019 at 10:23 AM Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> No idea, sorry. But I doubt they would dump VBA and add-in capabilities
> without some kind of backward compatibility?
>
> On Wed, Jul 10, 2019 at 6:12 AM a.bereziuk@.
>
>>
>> will the addin work correctly with Excel 2019 x64?
>>
>>
>>
>
Thu Jul 11, 2019 9:42 am (PDT) . Posted by:
a.bereziuk
Randy,
if I want to calculate an SMA50 for the date that lies 90 trading days ago:
=AVERAGE(smfGetYahooHistory("MMM",Today-90-50,Today-90,,"c",0,,50,1))
I get 206.93 but the correct value for it from stockcharts.com is about 205.00 (visually).
The value of SMA50 for today:
=AVERAGE(smfGetYahooHistory("MMM",,,,"c",0,,50,1)) is 170.25 and this corresponds approximately to the value from stockcharts.com.
What am I doing wrong?
(I know about the volatility of Today() function, it is just for better understanding there.)
if I want to calculate an SMA50 for the date that lies 90 trading days ago:
=AVERAGE(smfGetYaho
I get 206.93 but the correct value for it from stockcharts.
The value of SMA50 for today:
=AVERAGE(smfGetYaho
What am I doing wrong?
(I know about the volatility of Today() function, it is just for better understanding there.)
Thu Jul 11, 2019 11:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
TODAY()-90 won't get you 90 *trading *days ago. It will get you 90 *calendar
*days ago. Similar issue with the 50.
On Thu, Jul 11, 2019 at 9:42 AM a.bereziuk@... wrote:
>
> if I want to calculate an SMA50 for the date that lies 90 trading days ago:
>
> =AVERAGE(smfGetYahooHistory("MMM",Today-90-50,Today-90,,"c",0,,50,1))
>
> I get 206.93 but the correct value for it from stockcharts.com is about
> 205.00 (visually).
> The value of SMA50 for today:
>
> =AVERAGE(smfGetYahooHistory("MMM",,,,"c",0,,50,1)) is 170.25 and this
> corresponds approximately to the value from stockcharts.com.
>
> What am I doing wrong?
> (I know about the volatility of Today() function, it is just for better
> understanding there.)
>
>
*days ago. Similar issue with the 50.
On Thu, Jul 11, 2019 at 9:42 AM a.bereziuk@.
>
> if I want to calculate an SMA50 for the date that lies 90 trading days ago:
>
> =AVERAGE(smfGetYaho
>
> I get 206.93 but the correct value for it from stockcharts.
> 205.00 (visually).
> The value of SMA50 for today:
>
> =AVERAGE(smfGetYaho
> corresponds approximately to the value from stockcharts.
>
> What am I doing wrong?
> (I know about the volatility of Today() function, it is just for better
> understanding there.)
>
>
Thu Jul 11, 2019 10:45 am (PDT) . Posted by:
pietertvl
VERIZON LOOKED FOR YAHOO FINANCE BUYERS EARLIER THIS YEAR: RTRS (Reuters via Zerohedge twitter feed)
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar