15 Messages
Digest #4215
5b
Re: SMF Add-in Announcements - New ZIP File -- Version 2017.11.04 by "Randy Harmelink" rharmelink
Messages
Mon Nov 6, 2017 1:17 pm (PST) . Posted by:
eremon9
Sorry. I should have mentioned that I don't want to run the smfForceFullRecalculation macro because I'm using a number of GetElementNumber calls within the same workbook, and a full recalc takes much longer, aside from being inefficient wrt the server. I can do this by selecting the array to be updated and clicking on your menu item for recalculating the selection, but I'd like to be able to automate it within a macro.
Mon Nov 6, 2017 1:27 pm (PST) . Posted by:
eremon9
I notice that smfGetPortfolioView() doesn't retrieve correct data for WFCPL, and appears to retrieve book value per BRK-A share when BRK-B is specified. At least that's what I'm guessing it's doing.
Mon Nov 6, 2017 1:45 pm (PST) . Posted by:
djsnicholson
FEEDBACK - SMF Version 11.04.17: After installing 11.04.17 version, I deployed the smfGetYahooPortfolioView in a worksheet and successfully retrieved last price (15), short name (3), dividends(33) and prevclose (51) and %chg(52). The last traded date (78) for stocks was correct with today's date and for Mutual Funds was Sat. Nov 4th instead of Fri, Nov 3rd!? The prices retrieved were correct. Field 79 (the Last Traded Time) was consistently around 5:27pm give or take for all stocks until 4:00pm when the retrieved data field #79 changed to 9:00pm +/- 2 mins for all stocks. Could the incorrect decoding of Data item #79 have something to do with GMT time zone? 4pm close vs 9pm retrieved!? 5 hours diff? Randy, thanks again for all of your work. David N.
Mon Nov 6, 2017 2:36 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yes. Right now, they're all in GMT. Field (11), "GMT Offset Milliseconds",
could be used to create the EDT.
Dividing that by (24*60*60*1000) should get the time offset for an EXCEL
serial date.
I'll modify the EXCEL serial date versions to match EDT time.
On Mon, Nov 6, 2017 at 2:45 PM, djsn@
...
wrote:
>
> FEEDBACK - SMF Version 11.04.17: After installing 11.04.17 version, I
> deployed the smfGetYahooPortfolioView in a worksheet and successfully
> retrieved last price (15), short name (3), dividends(33) and prevclose (51)
> and %chg(52). The last traded date (78) for stocks was correct with today's
> date and for Mutual Funds was Sat. Nov 4th instead of Fri, Nov 3rd!? The
> prices retrieved were correct. Field 79 (the Last Traded Time) was
> consistently around 5:27pm give or take for all stocks until 4:00pm when
> the retrieved data field #79 changed to 9:00pm +/- 2 mins for all stocks.
> Could the incorrect decoding of Data item #79 have something to do with GMT
> time zone? 4pm close vs 9pm retrieved!? 5 hours diff? Randy, thanks again
> for all of your work. David N.
>
could be used to create the EDT.
Dividing that by (24*60*60*1000) should get the time offset for an EXCEL
serial date.
I'll modify the EXCEL serial date versions to match EDT time.
On Mon, Nov 6, 2017 at 2:45 PM, djsn@
...
wrote:
>
> FEEDBACK - SMF Version 11.04.17: After installing 11.04.17 version, I
> deployed the smfGetYahooPortfoli
> retrieved last price (15), short name (3), dividends(33) and prevclose (51)
> and %chg(52). The last traded date (78) for stocks was correct with today's
> date and for Mutual Funds was Sat. Nov 4th instead of Fri, Nov 3rd!? The
> prices retrieved were correct. Field 79 (the Last Traded Time) was
> consistently around 5:27pm give or take for all stocks until 4:00pm when
> the retrieved data field #79 changed to 9:00pm +/- 2 mins for all stocks.
> Could the incorrect decoding of Data item #79 have something to do with GMT
> time zone? 4pm close vs 9pm retrieved!? 5 hours diff? Randy, thanks again
> for all of your work. David N.
>
Mon Nov 6, 2017 5:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The only way to "refresh" without using smfForceRecalculation is to have a
new unique set of parameters, either a different ticker symbol or a
different field name.
On Mon, Nov 6, 2017 at 2:10 PM, tamurphy@cableone.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I call smfGetPortfolioView(Tickers, Items) within VBA, the worksheet
> containing my array formula isn't updated, and the underlying webpage
> appears not to be refreshed. Is there a way to do this without having to
> click on your context menu item?
>
new unique set of parameters, either a different ticker symbol or a
different field name.
On Mon, Nov 6, 2017 at 2:10 PM, tamurphy@cableone.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> When I call smfGetPortfolioView
> containing my array formula isn't updated, and the underlying webpage
> appears not to be refreshed. Is there a way to do this without having to
> click on your context menu item?
>
Mon Nov 6, 2017 5:20 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The "recalculate section" option wouldn't refresh with a new web page
retrieval. It would just recalculate the formulas based on the previously
retrieved web page (which should calculate to the exact same values).
smfForceRecalculation is necessary if you want to re-retrieve a web page.
That's why I said you need to change the fields or tickers -- it creates a
new web page address.
On Mon, Nov 6, 2017 at 2:17 PM, tamurphy@
...
wrote:
>
> Sorry. I should have mentioned that I don't want to run the
> smfForceFullRecalculation macro because I'm using a number of
> GetElementNumber calls within the same workbook, and a full recalc takes
> much longer, aside from being inefficient wrt the server. I can do this by
> selecting the array to be updated and clicking on your menu item for
> recalculating the selection, but I'd like to be able to automate it within
> a macro.
>
retrieval. It would just recalculate the formulas based on the previously
retrieved web page (which should calculate to the exact same values).
smfForceRecalculati
That's why I said you need to change the fields or tickers -- it creates a
new web page address.
On Mon, Nov 6, 2017 at 2:17 PM, tamurphy@
...
wrote:
>
> Sorry. I should have mentioned that I don't want to run the
> smfForceFullRecalcu
> GetElementNumber calls within the same workbook, and a full recalc takes
> much longer, aside from being inefficient wrt the server. I can do this by
> selecting the array to be updated and clicking on your menu item for
> recalculating the selection, but I'd like to be able to automate it within
> a macro.
>
Mon Nov 6, 2017 5:27 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'll need more specifics on WFCPL -- it appears to be working here. Are you
using the 2017.11.04 version of the add-in?
*Ticker Symbol* *Symbol* *Last Price* *Book Val*
MMM MMM 230.31 19.423
WFCPL WFCPL 1321 --
BRK-A BRK-A 280170 182766.88
BRK-B BRK-B 186.68 182766.88
That book value for BRK-A and BRK-B is the same as what Yahoo shows on
their Key Statistics web page for each. It's not the add-in mixing them up.
On Mon, Nov 6, 2017 at 2:24 PM, tamurphy@
...
wrote:
>
> I notice that smfGetPortfolioView() doesn't retrieve correct data for
>
> WFCPL, and appears to retrieve book value per BRK-A share when BRK-B is
> specified. At least that's what I'm guessing it's doing.
>
using the 2017.11.04 version of the add-in?
*Ticker Symbol* *Symbol* *Last Price* *Book Val*
MMM MMM 230.31 19.423
WFCPL WFCPL 1321 --
BRK-A BRK-A 280170 182766.88
BRK-B BRK-B 186.68 182766.88
That book value for BRK-A and BRK-B is the same as what Yahoo shows on
their Key Statistics web page for each. It's not the add-in mixing them up.
On Mon, Nov 6, 2017 at 2:24 PM, tamurphy@
...
wrote:
>
> I notice that smfGetPortfolioView
>
> WFCPL, and appears to retrieve book value per BRK-A share when BRK-B is
> specified. At least that's what I'm guessing it's doing.
>
Mon Nov 6, 2017 2:06 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Yes, but now you'd use the smfGetYahooPortfolioView() function, as
indicated by the coded example and the worksheet example on the blog.
Or you could use the Google method described on the blog.
On Mon, Nov 6, 2017 at 2:02 PM, 'Dennis Sesar' dennis@
...
wrote:
>
> Can this add-in be used to get the quotes?
>
indicated by the coded example and the worksheet example on the blog.
Or you could use the Google method described on the blog.
On Mon, Nov 6, 2017 at 2:02 PM, 'Dennis Sesar' dennis@
...
wrote:
>
> Can this add-in be used to get the quotes?
>
Mon Nov 6, 2017 2:13 pm (PST) . Posted by:
john_hoel
A word of thanks. This is a terrific example. I find especially useful the tab that documents all of the field numbers.
Mon Nov 6, 2017 3:14 pm (PST) . Posted by:
bobobfd
Hi Randy,
The ticker for the company, TrueCar Inc, is TRUE. Apparently smfGetYahooPortfolioView() confuses this with the TRUE logic value as no data is returned.
fyi ... smfGetYahooPortfolioView() returned data without problem.
Bruce
ps. I'll also add my thanks for the work you do in maintaining the SMF functions. Invaluable.! Also
smfGetYahooPortfolioView()is much faster for 100 tickers than smfGetYahooPortfolioView() was.
The ticker for the company, TrueCar Inc, is TRUE. Apparently smfGetYahooPortfoli
fyi ... smfGetYahooPortfoli
Bruce
ps. I'll also add my thanks for the work you do in maintaining the SMF functions. Invaluable.! Also
smfGetYahooPortfoli
Mon Nov 6, 2017 5:17 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I'm confused what you're saying about the TRUE ticker symbol. Which version
of the add-in are you running? It's working fine here:
01 15 87 17 18 19 20 21 00 51 52 03
*Ticker Symbol* *Symbol* *Last Price* *Last Traded Date/Time* *Change*
*Open* *High* *Low* *Volume* *--* *Prev Close* *% Chg* *Short Name*
MMM MMM $230.31 2017-11-06 04:01:47 PM -$1.91 $232.22 $232.63 $230.15
1334883 -- $232.22 -0.82% 3M Company
SPY SPY $258.83 2017-11-06 07:45:45 PM $0.00 $258.30 $0.00 $0.00 0 --
$258.45 0.00% SPDR S&P 500
True TRUE $16.34 2017-11-06 04:00:01 PM $0.25 $16.10 $16.42 $15.94 3483385
-- $16.09 1.55% TrueCar, Inc.
A single array-entered smfGetYahooPortfolioView() function with 100 tickers
really shouldn't be any noticeable bit faster than an array-entered
RCHGetYahooQuotes() function was? Both should have taken a split second.
Please don't tell me you're doing 100 individual smfGetYahooPortfolioView()
functions?
On Mon, Nov 6, 2017 at 4:14 PM, bobobfd@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The ticker for the company, TrueCar Inc, is TRUE. Apparently
> smfGetYahooPortfolioView() confuses this with the TRUE logic value as no
> data is returned.
>
> fyi ... smfGetYahooPortfolioView() returned data without problem.
>
> Bruce
>
>
> ps. I'll also add my thanks for the work you do in maintaining the SMF
> functions. Invaluable.! Also
> smfGetYahooPortfolioView()is much faster for 100 tickers than smfGetYahooPortfolioView()
> was.
>
of the add-in are you running? It's working fine here:
01 15 87 17 18 19 20 21 00 51 52 03
*Ticker Symbol* *Symbol* *Last Price* *Last Traded Date/Time* *Change*
*Open* *High* *Low* *Volume* *--* *Prev Close* *% Chg* *Short Name*
MMM MMM $230.31 2017-11-06 04:01:47 PM -$1.91 $232.22 $232.63 $230.15
1334883 -- $232.22 -0.82% 3M Company
SPY SPY $258.83 2017-11-06 07:45:45 PM $0.00 $258.30 $0.00 $0.00 0 --
$258.45 0.00% SPDR S&P 500
True TRUE $16.34 2017-11-06 04:00:01 PM $0.25 $16.10 $16.42 $15.94 3483385
-- $16.09 1.55% TrueCar, Inc.
A single array-entered smfGetYahooPortfolioView() function with 100 tickers
really shouldn't be any noticeable bit faster than an array-entered
RCHGetYahooQuotes() function was? Both should have taken a split second.
Please don't tell me you're doing 100 individual smfGetYahooPortfolioView()
functions?
On Mon, Nov 6, 2017 at 4:14 PM, bobobfd@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> The ticker for the company, TrueCar Inc, is TRUE. Apparently
> smfGetYahooPortfoli
> data is returned.
>
> fyi ... smfGetYahooPortfoli
>
> Bruce
>
>
> ps. I'll also add my thanks for the work you do in maintaining the SMF
> functions. Invaluable.! Also
> smfGetYahooPortfoli
> was.
>
Mon Nov 6, 2017 3:30 pm (PST) . Posted by:
"Yahoo!" lewglenn
What is the time reference (Eastern Standard Time)?
I'm storing the output from fn79 in column H and then doing:Range("H:H").NumberFormat = "h:mm AM/PM"
to get the time in standard format. The output appears to be 6 hours after Pacific Standard Time, i.e., when it's 3PM on the west coast the output in column "H" is 9PM. Am I doing something wrong?
On Monday, November 6, 2017, 12:21:42 PM PST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Not a typo. The "regularMarketTime" is a field on the JSON file that contains the last traded date and time in UNIX format. Field #78 just converts that UNIX value into an EXCEL serial date and takes the integer portion. Field #79 just converts that UNIX value into an EXCEL serial date and take the fractional portion. Field #87 just converts that UNIX value into an EXCEL serial date, keeping the whole result. So all four output fields come from the same input JSON field. In retrospect, I could have just gone with #87, as it can be used in place of #78 and #79, just with a different format applied to the value. Oh well.
The ticker symbol can still be passed twice. Right now, it's only returned once. If returned multiple times, there would need to be additional processing to check all slots every time instead of stopping after the first slot is found.
On Mon, Nov 6, 2017 at 11:53 AM, lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
In the smfGetYahooPortfolioView- Example.xls workbook, on the Field Number tab, field number 78 is described as Last Traded Date but has the Yahoo Field Name regularMarketTime. I'm guessing this is a typo. When I use this field number I get the correct date.
However, field number 79 is described as Last Traded Time and it too has the Yahoo Field Name regularMarketTime. In this case, when I use this field number I get what appears to be an EXCEL serial time. Is that correct?
Also, if you're still contemplating allowing the same ticker symbol to be passed twice I'd like to cast a vote in favor of this change.
#yiv4020021600 #yiv4020021600 -- #yiv4020021600ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4020021600 #yiv4020021600ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4020021600 #yiv4020021600ygrp-mkp #yiv4020021600hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4020021600 #yiv4020021600ygrp-mkp #yiv4020021600ads {margin-bottom:10px;}#yiv4020021600 #yiv4020021600ygrp-mkp .yiv4020021600ad {padding:0 0;}#yiv4020021600 #yiv4020021600ygrp-mkp .yiv4020021600ad p {margin:0;}#yiv4020021600 #yiv4020021600ygrp-mkp .yiv4020021600ad a {color:#0000ff;text-decoration:none;}#yiv4020021600 #yiv4020021600ygrp-sponsor #yiv4020021600ygrp-lc {font-family:Arial;}#yiv4020021600 #yiv4020021600ygrp-sponsor #yiv4020021600ygrp-lc #yiv4020021600hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4020021600 #yiv4020021600ygrp-sponsor #yiv4020021600ygrp-lc .yiv4020021600ad {margin-bottom:10px;padding:0 0;}#yiv4020021600 #yiv4020021600actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4020021600 #yiv4020021600activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4020021600 #yiv4020021600activity span {font-weight:700;}#yiv4020021600 #yiv4020021600activity span:first-child {text-transform:uppercase;}#yiv4020021600 #yiv4020021600activity span a {color:#5085b6;text-decoration:none;}#yiv4020021600 #yiv4020021600activity span span {color:#ff7900;}#yiv4020021600 #yiv4020021600activity span .yiv4020021600underline {text-decoration:underline;}#yiv4020021600 .yiv4020021600attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4020021600 .yiv4020021600attach div a {text-decoration:none;}#yiv4020021600 .yiv4020021600attach img {border:none;padding-right:5px;}#yiv4020021600 .yiv4020021600attach label {display:block;margin-bottom:5px;}#yiv4020021600 .yiv4020021600attach label a {text-decoration:none;}#yiv4020021600 blockquote {margin:0 0 0 4px;}#yiv4020021600 .yiv4020021600bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4020021600 .yiv4020021600bold a {text-decoration:none;}#yiv4020021600 dd.yiv4020021600last p a {font-family:Verdana;font-weight:700;}#yiv4020021600 dd.yiv4020021600last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4020021600 dd.yiv4020021600last p span.yiv4020021600yshortcuts {margin-right:0;}#yiv4020021600 div.yiv4020021600attach-table div div a {text-decoration:none;}#yiv4020021600 div.yiv4020021600attach-table {width:400px;}#yiv4020021600 div.yiv4020021600file-title a, #yiv4020021600 div.yiv4020021600file-title a:active, #yiv4020021600 div.yiv4020021600file-title a:hover, #yiv4020021600 div.yiv4020021600file-title a:visited {text-decoration:none;}#yiv4020021600 div.yiv4020021600photo-title a, #yiv4020021600 div.yiv4020021600photo-title a:active, #yiv4020021600 div.yiv4020021600photo-title a:hover, #yiv4020021600 div.yiv4020021600photo-title a:visited {text-decoration:none;}#yiv4020021600 div#yiv4020021600ygrp-mlmsg #yiv4020021600ygrp-msg p a span.yiv4020021600yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4020021600 .yiv4020021600green {color:#628c2a;}#yiv4020021600 .yiv4020021600MsoNormal {margin:0 0 0 0;}#yiv4020021600 o {font-size:0;}#yiv4020021600 #yiv4020021600photos div {float:left;width:72px;}#yiv4020021600 #yiv4020021600photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4020021600 #yiv4020021600photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4020021600 #yiv4020021600reco-category {font-size:77%;}#yiv4020021600 #yiv4020021600reco-desc {font-size:77%;}#yiv4020021600 .yiv4020021600replbq {margin:4px;}#yiv4020021600 #yiv4020021600ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4020021600 #yiv4020021600ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4020021600 #yiv4020021600ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4020021600 #yiv4020021600ygrp-mlmsg select, #yiv4020021600 input, #yiv4020021600 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4020021600 #yiv4020021600ygrp-mlmsg pre, #yiv4020021600 code {font:115% monospace;}#yiv4020021600 #yiv4020021600ygrp-mlmsg * {line-height:1.22em;}#yiv4020021600 #yiv4020021600ygrp-mlmsg #yiv4020021600logo {padding-bottom:10px;}#yiv4020021600 #yiv4020021600ygrp-msg p a {font-family:Verdana;}#yiv4020021600 #yiv4020021600ygrp-msg p#yiv4020021600attach-count span {color:#1E66AE;font-weight:700;}#yiv4020021600 #yiv4020021600ygrp-reco #yiv4020021600reco-head {color:#ff7900;font-weight:700;}#yiv4020021600 #yiv4020021600ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4020021600 #yiv4020021600ygrp-sponsor #yiv4020021600ov li a {font-size:130%;text-decoration:none;}#yiv4020021600 #yiv4020021600ygrp-sponsor #yiv4020021600ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4020021600 #yiv4020021600ygrp-sponsor #yiv4020021600ov ul {margin:0;padding:0 0 0 8px;}#yiv4020021600 #yiv4020021600ygrp-text {font-family:Georgia;}#yiv4020021600 #yiv4020021600ygrp-text p {margin:0 0 1em 0;}#yiv4020021600 #yiv4020021600ygrp-text tt {font-size:120%;}#yiv4020021600 #yiv4020021600ygrp-vital ul li:last-child {border-right:none !important;}#yiv4020021600
I'm storing the output from fn79 in column H and then doing:Range("H:H").NumberFormat = "h:mm AM/PM"
to get the time in standard format. The output appears to be 6 hours after Pacific Standard Time, i.e., when it's 3PM on the west coast the output in column "H" is 9PM. Am I doing something wrong?
On Monday, November 6, 2017, 12:21:42 PM PST, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Not a typo. The "regularMarketTime" is a field on the JSON file that contains the last traded date and time in UNIX format. Field #78 just converts that UNIX value into an EXCEL serial date and takes the integer portion. Field #79 just converts that UNIX value into an EXCEL serial date and take the fractional portion. Field #87 just converts that UNIX value into an EXCEL serial date, keeping the whole result. So all four output fields come from the same input JSON field. In retrospect, I could have just gone with #87, as it can be used in place of #78 and #79, just with a different format applied to the value. Oh well.
The ticker symbol can still be passed twice. Right now, it's only returned once. If returned multiple times, there would need to be additional processing to check all slots every time instead of stopping after the first slot is found.
On Mon, Nov 6, 2017 at 11:53 AM, lewglenn@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
In the smfGetYahooPortfoli
However, field number 79 is described as Last Traded Time and it too has the Yahoo Field Name regularMarketTime. In this case, when I use this field number I get what appears to be an EXCEL serial time. Is that correct?
Also, if you're still contemplating allowing the same ticker symbol to be passed twice I'd like to cast a vote in favor of this change.
#yiv4020021600 #yiv4020021600 -- #yiv4020021600ygrp-
Mon Nov 6, 2017 4:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
UNIX is a GMT time. I just added the GMT adjustment for the EXCEL serial
dates. So, next release it will be adjusted.
On Mon, Nov 6, 2017 at 4:30 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> What is the time reference (Eastern Standard Time)?
>
> I'm storing the output from fn79 in column H and then doing:
> Range("H:H").NumberFormat = "h:mm AM/PM"
>
> to get the time in standard format. The output appears to be 6 hours after
> Pacific Standard Time, i.e., when it's 3PM on the west coast the output in
> column "H" is 9PM. Am I doing something wrong?
>
>
dates. So, next release it will be adjusted.
On Mon, Nov 6, 2017 at 4:30 PM, Yahoo! lewglenn@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> What is the time reference (Eastern Standard Time)?
>
> I'm storing the output from fn79 in column H and then doing:
> Range("
>
> to get the time in standard format. The output appears to be 6 hours after
> Pacific Standard Time, i.e., when it's 3PM on the west coast the output in
> column "H" is 9PM. Am I doing something wrong?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar