Senin, 06 November 2017

[smf_addin] Digest Number 4213

15 Messages

Digest #4213
1a
Re: Can't download quotes by "V. Shankar" tarakayan
1b
Re: Can't download quotes by "V. Shankar" tarakayan
1c
Re: Can't download quotes by "Randy Harmelink" rharmelink
2.1
Re: smfGetPortfolioView() by nelsonmuntz1000
2.2
Re: smfGetPortfolioView() by "Randy Harmelink" rharmelink
2.3
Re: smfGetPortfolioView() by nelsonmuntz1000
3a
Re: Most Efficient Pull of Barchart Data by "Randy Harmelink" rharmelink
3b
Re: Most Efficient Pull of Barchart Data by "Brad Reel" reeldeal9090
5a
Currencies by ane13sk
5b
Re: Currencies by ane13sk
5c
Re: Currencies by "Randy Harmelink" rharmelink
6b
Re: What's happening with yahoo quotes? by "Randy Harmelink" rharmelink

Messages

Sun Nov 5, 2017 7:01 pm (PST) . Posted by:

"V. Shankar" tarakayan

I slowly getting used to smfyahooportfolioview which is great and working fast...on element 32 ex-dividend date I see it in Unix format..cant format it?thanks
On Sunday, November 5, 2017, 9:54:18 PM GMT+5:30, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

I decided to put announcements about the add-in there, so they don't get lost in all the noise that can happen in the Yahoo group. Easiest way to monitor it would be to use the RSS feed.
On Sun, Nov 5, 2017 at 8:45 AM, 'V. Shankar' tarakayan@​... wrote:

Is blogspot.com good place to visit periodically and review as there are so many messages on recent RCHGetYahooquotes?thanksShankar
On Friday, November 3, 2017, 2:57:46 AM GMT+5:30, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote: ​  

See the announcement for the last few days:
https://smf-add-in.blogspot. com/

Sun Nov 5, 2017 7:06 pm (PST) . Posted by:

"V. Shankar" tarakayan

I am slowly getting used to smfyahooportfolioview which is great and working fast...on element 32 ex-dividend date I see it in Unix format..cant format it?
thanks
On Sunday, November 5, 2017, 9:54:18 PM GMT+5:30, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

I decided to put announcements about the add-in there, so they don't get lost in all the noise that can happen in the Yahoo group. Easiest way to monitor it would be to use the RSS feed.
On Sun, Nov 5, 2017 at 8:45 AM, 'V. Shankar' tarakayan@​... wrote:

Is blogspot.com good place to visit periodically and review as there are so many messages on recent RCHGetYahooquotes?thanksShankar
On Friday, November 3, 2017, 2:57:46 AM GMT+5:30, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote: ​  

See the announcement for the last few days:
https://smf-add-in.blogspot. com/

Sun Nov 5, 2017 8:01 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try using element #80 instead. It should be the ex-dividend date in EXCEL
serial date format.

Otherwise, to convert from UNIX:

=smfUNIX2Date(F3)

On Sun, Nov 5, 2017 at 8:02 PM, 'V. Shankar' tarakayan@
​...
wrote:

>
> I am slowly getting used to smfyahooportfolioview which is great and
> working fast...on element 32 ex-dividend date I see it in Unix format..cant
> format it?
>
>

Sun Nov 5, 2017 7:46 pm (PST) . Posted by:

nelsonmuntz1000

Fantastic work, Randy. This new formula seems to retrieve data much faster than the RCHGetYahooQuotes() formula. One question, is there a row limit for the array? I believe the old limit was 200 rows.

Many thanks for your efforts.

Sun Nov 5, 2017 7:56 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I think I tried the S&P 500 list of tickers without an issue.

On Sun, Nov 5, 2017 at 8:45 PM, ccoupe300@
​...
wrote:

>
> Fantastic work, Randy. This new formula seems to retrieve data much faster
> than the RCHGetYahooQuotes() formula. One question, is there a row limit
> for the array? I believe the old limit was 200 rows.
>
>

Sun Nov 5, 2017 7:54 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Well, that was easy. I still have to do field names. The current
smfGetBarchartPortfolioView() output, after transposing the output to see
all the fields:

*symbol* *MMM* *IBM*
symbolName 3M Company International Business Machines
symbolShortName 3M Company International
contractName N/A N/A
exchange NYSE NYSE
openPrice 231.56 153.42
highPrice 232.58 153.47
lowPrice 230.92 151.49
lastPrice 232.22 151.58
priceChange -0.01 -1.77
percentChange unch -0.0115
volume 1582700 4431600
previousPrice 232.23 153.35
industry Conglomerates - Div Operations Computer - Integrated Systems
contractExpirationDate N/A N/A
tradeTime 43042 43042
hasOptions Yes Yes
standardDeviation 0 -0.56
weightedAlpha 40.4 -3.1
openInterest 0 0
highPrice1y 238.9 182.79
lowPrice1y 165.84 139.13
pivotPoint 231.91 152.18
resistanceLevel1 232.89 152.87
resistanceLevel2 233.57 154.16
supportLevel1 231.23 150.89
supportLevel2 230.25 150.2
marketCap 138312544 140331248
sharesOutstanding 595610 925790
annualSales 30109 79919
annualNetIncome 5050000000 11872000000
beta 1.08 0.94
percentInsider 0.0058 0.0023
percentInstitutional 0.6621 0.5788
growth1y 0.3949 -0.0056
growth3y 0.4916 -0.0633
growth5y 1.5917 -0.2192
revenueGrowth5y 0.0168 -0.2525
earningsGrowth5y 0.3691 0.0157
dividendGrowth5y 1.0182 0.8966
earnings 2.33 3.3
epsDate 43032 43025
nextEarningsDate 43032 43025
epsAnnual 8.95 13.66
epsGrowthQuarter -0.0969 0.1111
epsGrowthYear 0.0837 0.003
dividendRate 4.7 6
dividendYield 0.0202 0.0391
dividend 1.18 1.5
dividendDate 42970 42955
dividendExDate 42970 43048
paymentDate 42990 43078
dividendPayout 50.39 42.18
split 2-1 2-1
splitDate 37894 36307
peRatioTrailing 25.95 11.23
peRatioForward 25.58 10.98
pegRatio 2.52 2.25
returnOnEquity 48.83 64.55
returnOnAssets 16.22 10.82
profitMargin 16.77 14.86
debtEquity 1.03 1.88
priceSales 4.59 1.78
priceCashFlow 21.24 8.37
priceBook 11.36 7.23
bookValue 20.45 21.2
interestCoverage 36.04 19.24
movingAverage1m 223.8 152.03
movingAverage65d 213.18 146.65
movingAverage130d 209.34 149.25
movingAverage9m 202.82 157.06
movingAverage260d 196.11 159.25
movingAverageYtd 200.03 158.59
movingAverage5d 231.17 153.48
movingAverage20d 224.9 152.85
movingAverage50d 215.4 148.05
movingAverage100d 211.71 148.26
movingAverage200d 201.48 157.98
averageVolume1m 2079326 5701652
averageVolume3m 1773438 4387840
averageVolume6m 1792318 4367969
averageVolume9m 1831483 4243319
averageVolume1y 1864248 4128513
averageVolumeYtd 1850540 4242816
averageVolume5d 1842520 3921600
averageVolume20d 2139845 6179200
averageVolume50d 1853340 4642400
averageVolume100d 1786196 4320182
averageVolume200d 1863163 4240443
rawStochastic9d 0.3259 0.011
rawStochastic14d 0.7022 0.3307
rawStochastic20d 0.7244 0.3307
rawStochastic50d 0.826 0.4763
rawStochastic100d 0.8399 0.5325
stochasticK9d 0.5022 0.0703
stochasticK14d 0.672 0.4168
stochasticK20d 0.6965 0.4168
stochasticK50d 0.8084 0.5496
stochasticK100d 0.8237 0.5927
stochasticD9d 0.5629 0.1099
stochasticD14d 0.6495 0.4574
stochasticD20d 0.6772 0.4582
stochasticD50d 0.7931 0.5912
stochasticD100d 0.8097 0.621
averageTrueRange9d 3.27 2.22
averageTrueRange14d 3.11 2.16
averageTrueRange20d 2.94 2.06
averageTrueRange50d 2.53 1.86
averageTrueRange100d 2.32 1.86
relativeStrength9d 0.6672 0.4323
relativeStrength14d 0.6843 0.4968
relativeStrength20d 0.685 0.5228
relativeStrength50d 0.6508 0.5116
relativeStrength100d 0.6276 0.4927
percentR9d 0.6741 0.989
percentR14d 0.2978 0.6693
percentR20d 0.2756 0.6693
percentR50d 0.174 0.5237
percentR100d 0.1601 0.4675
historicVolatility9d 0.3332 0.1282
historicVolatility14d 0.2721 0.3903
historicVolatility20d 0.2297 0.3298
historicVolatility50d 0.168 0.2208
historicVolatility100d 0.1683 0.1907
macdOscillator9d -1.33 -0.8
macdOscillator14d 3.4 -2.2
macdOscillator20d 6.65 0.13
macdOscillator50d 16.14 4.94
macdOscillator100d 19.9 5.45
priceChange1m 17.65 4.8
priceChange3m 24.6 6.64
priceChange6m 34.59 -7.05
priceChange9m 57.18 -24.24
priceChange1y 65.39 -0.79
priceChangeYtd 53.65 -14.41
priceChange5d -2.52 -2.1
priceChange20d 15.7 5.1
priceChange50d 30.1 8.64
priceChange100d 22.21 -2.23
priceChange200d 53.73 -18.97
percentChange1m 0.0823 0.0327
percentChange3m 0.1185 0.0458
percentChange6m 0.175 -0.0444
percentChange9m 0.3267 -0.1379
percentChange1y 0.392 -0.0052
percentChangeYtd 0.3004 -0.0868
percentChange5d -0.0107 -0.0137
percentChange20d 0.0725 0.0348
percentChange50d 0.1489 0.0604
percentChange100d 0.1058 -0.0145
percentChange200d 0.301 -0.1112
highPrice5d 233.66 154.93
highDate5d 43038 43039
lowPrice5d 229.11 151.49
lowDate5d 43040 43042
highHits5d 1 2
highPercent5d -0.0062 -0.0216
lowHits5d 3 2
lowPercent5d 0.0136 0.0006
highPrice1m 238.9 162.51
highDate1m 43032 43031
lowPrice1m 214.5 146.11
lowDate1m 43012 43012
highHits1m 7 7
highPercent1m -0.028 -0.0673
lowHits1m 1 1
lowPercent1m 0.0826 0.0374
highPrice3m 238.9 162.51
highDate3m 43032 43031
lowPrice3m 200.51 139.13
lowDate3m 42983 42968
highHits3m 14 10
highPercent3m -0.028 -0.0673
lowHits3m 11 7
lowPercent3m 0.1581 0.0895
highPrice6m 238.9 162.51
highDate6m 43032 43031
lowPrice6m 193.54 139.13
lowDate6m 42873 42968
highHits6m 22 4
highPercent6m -0.028 -0.0673
lowHits6m 6 17
lowPercent6m 0.1999 0.0895
highDate1y 43032 42782
lowDate1y 42683 42968
highHits1y 51 22
highPercent1y -0.028 -0.1707
lowHits1y 2 14
lowPercent1y 0.4003 0.0895
highPriceYtd 238.9 182.79
highDateYtd 43032 42782
lowPriceYtd 173.55 139.13
lowDateYtd 42768 42968
highHitsYtd 41 11
highPercentYtd -0.028 -0.1707
lowHitsYtd 7 23
lowPercentYtd 0.3381 0.0895
opinion 72% Buy Hold
opinionStrength Strong
opinionDirection Strengthening Falling
opinionPrevious 72% Buy 24% Buy
opinionLastWeek 96% Buy 48% Buy
opinionLastMonth 100% Buy 40% Buy
opinionShortTerm 60% Buy 40% Sell
opinionMediumTerm 50% Buy 25% Buy
opinionLongTerm 100% Buy Hold
averageRecommendation 3.29 3.16
trendSpotterSignal Buy Buy
trendSpotterStrength Average Minimum
trendSpotterDirection Strengthening Weakest
average7dSignal Buy Sell
average7dStrength Weak Minimum
average7dDirection Weakening Strongest
movingAverage10to8dSignal Hold Sell
movingAverage10to8dStrength Minimum
movingAverage10to8dDirection Falling Strongest
movingAverage20dSignal Buy Sell
movingAverage20dStrength Weak Minimum
movingAverage20dDirection Weakening Strongest
macd20to50dSignal Buy Buy
macd20to50dStrength Maximum Strong
macd20to50dDirection Strongest Strongest
bollingerBands20dSignal Hold Hold
bollingerBands20dStrength
bollingerBands20dDirection Falling Bearish
commodityChannel40dSignal Buy Hold
commodityChannel40dStrength Minimum
commodityChannel40dDirection Weakest Bearish
movingAverage50dSignal Buy Buy
movingAverage50dStrength Strong Weak
movingAverage50dDirection Strengthening Weakest
macd20to100dSignal Buy Buy
macd20to100dStrength Maximum Weak
macd20to100dDirection Strongest Strongest
parabolicTimePrice50dSignal Sell Sell
parabolicTimePrice50dStrength Average Strong
parabolicTimePrice50dDirection Weakening Strongest
commodityChannel60dSignal Buy Hold
commodityChannel60dStrength Weak
commodityChannel60dDirection Weakest Bearish
movingAverage100dSignal Buy Buy
movingAverage100dStrength Strong Weak
movingAverage100dDirection Strengthening Weakest
macd50to100dSignal Buy Sell
macd50to100dStrength Average Minimum
macd50to100dDirection Strongest Weakest

On Sun, Nov 5, 2017 at 5:03 PM, Brad Reel brad.reel90@
​...
wrote:

>
> I didn't mean to create work for you... :)
>
> Let me know how it goes.
>

Mon Nov 6, 2017 4:13 am (PST) . Posted by:

"Brad Reel" reeldeal9090

Wow, Randy. That's awesome. This is sort of a boon given all the Yahoo
changes. Nice job. I'll be happy to help test it out as needed. Thanks!

On Nov 5, 2017 9:54 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <
smf_addin@yahoogroups.com> wrote:

>
>
> Well, that was easy. I still have to do field names. The current
> smfGetBarchartPortfolioView() output, after transposing the output to see
> all the fields:
>
> *symbol* *MMM* *IBM*
> symbolName 3M Company International Business Machines
> symbolShortName 3M Company International
> contractName N/A N/A
> exchange NYSE NYSE
> openPrice 231.56 153.42
> highPrice 232.58 153.47
> lowPrice 230.92 151.49
> lastPrice 232.22 151.58
> priceChange -0.01 -1.77
> percentChange unch -0.0115
> volume 1582700 4431600
> previousPrice 232.23 153.35
> industry Conglomerates - Div Operations Computer - Integrated Systems
> contractExpirationDate N/A N/A
> tradeTime 43042 43042
> hasOptions Yes Yes
> standardDeviation 0 -0.56
> weightedAlpha 40.4 -3.1
> openInterest 0 0
> highPrice1y 238.9 182.79
> lowPrice1y 165.84 139.13
> pivotPoint 231.91 152.18
> resistanceLevel1 232.89 152.87
> resistanceLevel2 233.57 154.16
> supportLevel1 231.23 150.89
> supportLevel2 230.25 150.2
> marketCap 138312544 140331248
> sharesOutstanding 595610 925790
> annualSales 30109 79919
> annualNetIncome 5050000000 11872000000
> beta 1.08 0.94
> percentInsider 0.0058 0.0023
> percentInstitutional 0.6621 0.5788
> growth1y 0.3949 -0.0056
> growth3y 0.4916 -0.0633
> growth5y 1.5917 -0.2192
> revenueGrowth5y 0.0168 -0.2525
> earningsGrowth5y 0.3691 0.0157
> dividendGrowth5y 1.0182 0.8966
> earnings 2.33 3.3
> epsDate 43032 43025
> nextEarningsDate 43032 43025
> epsAnnual 8.95 13.66
> epsGrowthQuarter -0.0969 0.1111
> epsGrowthYear 0.0837 0.003
> dividendRate 4.7 6
> dividendYield 0.0202 0.0391
> dividend 1.18 1.5
> dividendDate 42970 42955
> dividendExDate 42970 43048
> paymentDate 42990 43078
> dividendPayout 50.39 42.18
> split 2-1 2-1
> splitDate 37894 36307
> peRatioTrailing 25.95 11.23
> peRatioForward 25.58 10.98
> pegRatio 2.52 2.25
> returnOnEquity 48.83 64.55
> returnOnAssets 16.22 10.82
> profitMargin 16.77 14.86
> debtEquity 1.03 1.88
> priceSales 4.59 1.78
> priceCashFlow 21.24 8.37
> priceBook 11.36 7.23
> bookValue 20.45 21.2
> interestCoverage 36.04 19.24
> movingAverage1m 223.8 152.03
> movingAverage65d 213.18 146.65
> movingAverage130d 209.34 149.25
> movingAverage9m 202.82 157.06
> movingAverage260d 196.11 159.25
> movingAverageYtd 200.03 158.59
> movingAverage5d 231.17 153.48
> movingAverage20d 224.9 152.85
> movingAverage50d 215.4 148.05
> movingAverage100d 211.71 148.26
> movingAverage200d 201.48 157.98
> averageVolume1m 2079326 5701652
> averageVolume3m 1773438 4387840
> averageVolume6m 1792318 4367969
> averageVolume9m 1831483 4243319
> averageVolume1y 1864248 4128513
> averageVolumeYtd 1850540 4242816
> averageVolume5d 1842520 3921600
> averageVolume20d 2139845 6179200
> averageVolume50d 1853340 4642400
> averageVolume100d 1786196 4320182
> averageVolume200d 1863163 4240443
> rawStochastic9d 0.3259 0.011
> rawStochastic14d 0.7022 0.3307
> rawStochastic20d 0.7244 0.3307
> rawStochastic50d 0.826 0.4763
> rawStochastic100d 0.8399 0.5325
> stochasticK9d 0.5022 0.0703
> stochasticK14d 0.672 0.4168
> stochasticK20d 0.6965 0.4168
> stochasticK50d 0.8084 0.5496
> stochasticK100d 0.8237 0.5927
> stochasticD9d 0.5629 0.1099
> stochasticD14d 0.6495 0.4574
> stochasticD20d 0.6772 0.4582
> stochasticD50d 0.7931 0.5912
> stochasticD100d 0.8097 0.621
> averageTrueRange9d 3.27 2.22
> averageTrueRange14d 3.11 2.16
> averageTrueRange20d 2.94 2.06
> averageTrueRange50d 2.53 1.86
> averageTrueRange100d 2.32 1.86
> relativeStrength9d 0.6672 0.4323
> relativeStrength14d 0.6843 0.4968
> relativeStrength20d 0.685 0.5228
> relativeStrength50d 0.6508 0.5116
> relativeStrength100d 0.6276 0.4927
> percentR9d 0.6741 0.989
> percentR14d 0.2978 0.6693
> percentR20d 0.2756 0.6693
> percentR50d 0.174 0.5237
> percentR100d 0.1601 0.4675
> historicVolatility9d 0.3332 0.1282
> historicVolatility14d 0.2721 0.3903
> historicVolatility20d 0.2297 0.3298
> historicVolatility50d 0.168 0.2208
> historicVolatility100d 0.1683 0.1907
> macdOscillator9d -1.33 -0.8
> macdOscillator14d 3.4 -2.2
> macdOscillator20d 6.65 0.13
> macdOscillator50d 16.14 4.94
> macdOscillator100d 19.9 5.45
> priceChange1m 17.65 4.8
> priceChange3m 24.6 6.64
> priceChange6m 34.59 -7.05
> priceChange9m 57.18 -24.24
> priceChange1y 65.39 -0.79
> priceChangeYtd 53.65 -14.41
> priceChange5d -2.52 -2.1
> priceChange20d 15.7 5.1
> priceChange50d 30.1 8.64
> priceChange100d 22.21 -2.23
> priceChange200d 53.73 -18.97
> percentChange1m 0.0823 0.0327
> percentChange3m 0.1185 0.0458
> percentChange6m 0.175 -0.0444
> percentChange9m 0.3267 -0.1379
> percentChange1y 0.392 -0.0052
> percentChangeYtd 0.3004 -0.0868
> percentChange5d -0.0107 -0.0137
> percentChange20d 0.0725 0.0348
> percentChange50d 0.1489 0.0604
> percentChange100d 0.1058 -0.0145
> percentChange200d 0.301 -0.1112
> highPrice5d 233.66 154.93
> highDate5d 43038 43039
> lowPrice5d 229.11 151.49
> lowDate5d 43040 43042
> highHits5d 1 2
> highPercent5d -0.0062 -0.0216
> lowHits5d 3 2
> lowPercent5d 0.0136 0.0006
> highPrice1m 238.9 162.51
> highDate1m 43032 43031
> lowPrice1m 214.5 146.11
> lowDate1m 43012 43012
> highHits1m 7 7
> highPercent1m -0.028 -0.0673
> lowHits1m 1 1
> lowPercent1m 0.0826 0.0374
> highPrice3m 238.9 162.51
> highDate3m 43032 43031
> lowPrice3m 200.51 139.13
> lowDate3m 42983 42968
> highHits3m 14 10
> highPercent3m -0.028 -0.0673
> lowHits3m 11 7
> lowPercent3m 0.1581 0.0895
> highPrice6m 238.9 162.51
> highDate6m 43032 43031
> lowPrice6m 193.54 139.13
> lowDate6m 42873 42968
> highHits6m 22 4
> highPercent6m -0.028 -0.0673
> lowHits6m 6 17
> lowPercent6m 0.1999 0.0895
> highDate1y 43032 42782
> lowDate1y 42683 42968
> highHits1y 51 22
> highPercent1y -0.028 -0.1707
> lowHits1y 2 14
> lowPercent1y 0.4003 0.0895
> highPriceYtd 238.9 182.79
> highDateYtd 43032 42782
> lowPriceYtd 173.55 139.13
> lowDateYtd 42768 42968
> highHitsYtd 41 11
> highPercentYtd -0.028 -0.1707
> lowHitsYtd 7 23
> lowPercentYtd 0.3381 0.0895
> opinion 72% Buy Hold
> opinionStrength Strong
> opinionDirection Strengthening Falling
> opinionPrevious 72% Buy 24% Buy
> opinionLastWeek 96% Buy 48% Buy
> opinionLastMonth 100% Buy 40% Buy
> opinionShortTerm 60% Buy 40% Sell
> opinionMediumTerm 50% Buy 25% Buy
> opinionLongTerm 100% Buy Hold
> averageRecommendation 3.29 3.16
> trendSpotterSignal Buy Buy
> trendSpotterStrength Average Minimum
> trendSpotterDirection Strengthening Weakest
> average7dSignal Buy Sell
> average7dStrength Weak Minimum
> average7dDirection Weakening Strongest
> movingAverage10to8dSignal Hold Sell
> movingAverage10to8dStrength Minimum
> movingAverage10to8dDirection Falling Strongest
> movingAverage20dSignal Buy Sell
> movingAverage20dStrength Weak Minimum
> movingAverage20dDirection Weakening Strongest
> macd20to50dSignal Buy Buy
> macd20to50dStrength Maximum Strong
> macd20to50dDirection Strongest Strongest
> bollingerBands20dSignal Hold Hold
> bollingerBands20dStrength
> bollingerBands20dDirection Falling Bearish
> commodityChannel40dSignal Buy Hold
> commodityChannel40dStrength Minimum
> commodityChannel40dDirection Weakest Bearish
> movingAverage50dSignal Buy Buy
> movingAverage50dStrength Strong Weak
> movingAverage50dDirection Strengthening Weakest
> macd20to100dSignal Buy Buy
> macd20to100dStrength Maximum Weak
> macd20to100dDirection Strongest Strongest
> parabolicTimePrice50dSignal Sell Sell
> parabolicTimePrice50dStrength Average Strong
> parabolicTimePrice50dDirection Weakening Strongest
> commodityChannel60dSignal Buy Hold
> commodityChannel60dStrength Weak
> commodityChannel60dDirection Weakest Bearish
> movingAverage100dSignal Buy Buy
> movingAverage100dStrength Strong Weak
> movingAverage100dDirection Strengthening Weakest
> macd50to100dSignal Buy Sell
> macd50to100dStrength Average Minimum
> macd50to100dDirection Strongest Weakest
>
> On Sun, Nov 5, 2017 at 5:03 PM, Brad Reel brad.reel90@
> ​...
> wrote:
>
>>
>> I didn't mean to create work for you... :)
>>
>> Let me know how it goes.
>>
>
>

Sun Nov 5, 2017 8:06 pm (PST) . Posted by:

dleeper47

I think that cryptic date/time format can be converted via this formula --

=(((A1/60)/60/24) + Date(1970,1,1))


The numerical result of this calculation can be displayed with your choice of Excel "date" or "time" formats.

Sun Nov 5, 2017 8:15 pm (PST) . Posted by:

ane13sk

Hi Randy,


thanks for all your work and sorry if my request is redundant.



I am also transitioning and in my case, ticker retrieves were fine for the most part. I am also trying to use the smfGetYahooPortfolioView in order to retrieve currency exchanges (unfortunately, I need them as well). Before, my solution was to use RCHGetYahooQuotes as Yahoo provides currency exchange "ticker like".
I inputed "EURUSD=X" to get the quote, and that is still working even with the new way, but others, such as "EURCAD=X" are not. Is it just my problem? Any hint on how to get such data?


Thanks


Andrea

Sun Nov 5, 2017 8:19 pm (PST) . Posted by:

ane13sk

Oh well, it seems somebody asked something similar and used exactly the same topic title.
Good, then I know Im not the only one at least

Sun Nov 5, 2017 8:26 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

That should be fixed in the latest release, 2017.11.04:

https://smf-add-in.blogspot.com/2017/11/new-zip-file-version-20171104.html

01 15 87
*Ticker Symbol* *Symbol* *Last Price* *Last Traded Date/Time*
EURUSD=X EURUSD=X $1.16 2017-11-06 04:22:00 AM
EURCAD=X EURCAD=X $1.48 2017-11-06 04:22:15 AM

On Sun, Nov 5, 2017 at 9:15 PM, andrea.giuliani@
​...
wrote:

> thanks for all your work and sorry if my request is redundant.
>
> I am also transitioning and in my case, ticker retrieves were fine for the
> most part. I am also trying to use the smfGetYahooPortfolioView in order to
> retrieve currency exchanges (unfortunately, I need them as well). Before,
> my solution was to use RCHGetYahooQuotes as Yahoo provides currency
> exchange "ticker like".
>
> I inputed "EURUSD=X" to get the quote, and that is still working even with
> the new way, but others, such as "EURCAD=X" are not. Is it just my problem?
> Any hint on how to get such data?
>
>
>

Mon Nov 6, 2017 8:31 am (PST) . Posted by:

trendsekr

Is there an overview message about yahoo pulling their feed and what to do now?


Thanks

Mon Nov 6, 2017 8:52 am (PST) . Posted by:

"Randy Harmelink" rharmelink

​Have you read the announcements blog?

https://smf-add-in.blogspot.com/​

On Mon, Nov 6, 2017 at 9:31 AM, trendsekr@
​...
wrote:

> Is there an overview message about yahoo pulling their feed and what to do
> now?
>
>
>

Mon Nov 6, 2017 10:39 am (PST) . Posted by:

trendsekr

That's what I was looking for, thanks. However, I'm still not sure what to do next. I was looking around for files and instructions but...

BTW, in http://ogres-crypt.com/SMF/Tips-and-FAQs/ http://ogres-crypt.com/SMF/Tips-and-FAQs/ the link for 0.1 Installing under EXCEL 2007 is wrong.


Also, when I clicked on a cell in smfGetYahooPortfolioView-Example,.xls http://ogres-crypt.com/SMF/Templates/smfGetYahooPortfolioView-Example.xls windows 10 crashed.

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar