Selasa, 28 November 2017

[smf_addin] Digest Number 4250

13 Messages

Digest #4250
2a
Re: Most Efficient Pull of Barchart Data by "Brad Reel" reeldeal9090

Messages

Tue Nov 28, 2017 2:01 am (PST) . Posted by:

mail_to_subu

Dear Original poster

I couldn't see your full / original post, so this request

Could you please share these sp sheets that you have created ? or re post the link if you have posted it already

thanks in adv
regards
Subu

PS : I receive mail in digest form, so I may have missed a digest. When I click on the subject of the mail, I'm still directed to Randy's reply and when I expand message history I still see only part of the original post

Tue Nov 28, 2017 6:17 am (PST) . Posted by:

"Brad Reel" reeldeal9090

Hey, Randy. I just wanted to let you know that I've been using the
smfGetBarchartPortfolioData() function now for a few weeks and I absolutely
love it. No issues to report. It has made my data pulls massively easier
and faster. Truly appreciate all you do and happy to assist in anyway I
can in the future. Thanks again and take care!

On Mon, Nov 6, 2017 at 6:13 AM, Brad Reel <brad.reel90@gmail.com> wrote:

> 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.
>>>
>>
>>
>

Tue Nov 28, 2017 8:29 am (PST) . Posted by:

richmond0039

Thanks Randy. I will try your suggestion. The other option I plan to try is to completely remove the add-in, then delete the directory where it resides, reboot the PC and try a complete reinstall as the Administrative user.

Tue Nov 28, 2017 10:08 am (PST) . Posted by:

richmond0039

Well, this problem is making me a little crazy. I removed and then reloaded the add-in. The first time I open a spreadsheet and right click a cell, the SMF option in the displayed menu. Every time after that, the SMF option is not displayed. If I use the developer tab, select the modMenu VBA module, set a break point in it near the end of the module and then select "run until cursor", the SMF menu option reappears until I exit Excel. I have to do the same thing the next time I run Excel to get the SMF menu option to appear. So I am concluding that something is preventing the modMenu module from running each time Excel starts on this particular PC. It feels like one of those "run once" issues and I don't understand why it is happening.

I do not believe it is a file permission issue since I tried putting the add-in in a C:\ root directory subdirectory location and then unblocking the .xla file and I also loaded the add-in to the default Excel add-in location, which is in the user's AppData directory under roaming profiles. Nothing makes any difference. Finally, looking at the Auto_Open routine, all it seems to do is use a user defined macro to force the add-in to load and the add-in is already loaded when Excel starts. Any other suggestions?

Tue Nov 28, 2017 10:24 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Your comment on "all it seems to do is use a user defined macro to force
the add-in to load" confuses me. Nothing within the add-in could force it
to load. The add-in is loaded when EXCEL starts up, because it is on the
list of add-ins to load within the add-in manager.

When it is loaded, the Auto_Open routine should run, because that's a
special name EXCEL recognizes as a routine to be run upon a particular
event (i.e. the object being opened).

You could try putting a break point within the Auto_Close routine. It
unloads the SMF menu. Maybe something is causing it to run prematurely?

On Tue, Nov 28, 2017 at 11:08 AM, dcash@
​...
wrote:

>
> Well, this problem is making me a little crazy. I removed and then
> reloaded the add-in. The first time I open a spreadsheet and right click a
> cell, the SMF option in the displayed menu. Every time after that, the SMF
> option is not displayed. If I use the developer tab, select the modMenu
> VBA module, set a break point in it near the end of the module and then
> select "run until cursor", the SMF menu option reappears until I exit
> Excel. I have to do the same thing the next time I run Excel to get the
> SMF menu option to appear. So I am concluding that something is preventing
> the modMenu module from running each time Excel starts on this particular
> PC. It feels like one of those "run once" issues and I don't understand
> why it is happening.
>
> I do not believe it is a file permission issue since I tried putting the
> add-in in a C:\ root directory subdirectory location and then unblocking
> the .xla file and I also loaded the add-in to the default Excel add-in
> location, which is in the user's AppData directory under roaming profiles.
> Nothing makes any difference. Finally, looking at the Auto_Open routine,
> ​​
> all it seems to do is use a user defined macro to force the add-in to load
> and the add-in is already loaded when Excel starts. Any other suggestions?
>

Tue Nov 28, 2017 11:35 am (PST) . Posted by:

richmond0039

Sorry for the confusion on my part. I will add breakpoints to both the Auto_Open and Auto_Close subroutines in modMenu after the calls to smfAddToCellMenu and smfDeleteFromCellMenu so I can see when the cell menu is loaded and unloaded.

Tue Nov 28, 2017 12:04 pm (PST) . Posted by:

richmond0039

One question and one Ah Ha!

The Ah Ha! is that I found the difference between the two PCs. The one where the SMF context menu choice appears also had an add-in installed from the Microsoft Store called Stock Connector. I tried to use it but dropped it when I found out it could not retrieve Mutual fund prices. As soon as I removed Stock Connector, the SMF context menu choice disappeared, so now the behavior is consistent across both PCs - the SMF context menu choice does not appear unless I open the Developer tab and forcibly execute the modMenu module.


Now for the question. Since your add-in loads when Excel starts and before I can open the VBA Developer tab, how do I set a breakpoint in the Auto_Open and Auto_Close subroutines of modMenu that will persist until the next time I start Excel? I hope this question makes sense. My initial reaction is to save a renamed copy of your .xla file with the breakpoints and then use it temporarily as the add-in to load when Excel starts up.


Thanks for being so patient with me.

Tue Nov 28, 2017 12:57 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't know of any way to save a break point between sessions, since an
entirely new VBA environment would exist.

It's bizarre to me that the add-in is loading, but not running the
Auto_Open routine. Either something is intercepting it, or something is
stopping within it. Hmm. You could add a MsgBox() to the start of the VBA
routine, to do a popup when it starts? That would persist between sessions.

On Tue, Nov 28, 2017 at 1:04 PM, dcash@
​...
wrote:

>
> One question and one Ah Ha!
>
> The Ah Ha! is that I found the difference between the two PCs. The one
> where the SMF context menu choice appears also had an add-in installed from
> the Microsoft Store called Stock Connector. I tried to use it but dropped
> it when I found out it could not retrieve Mutual fund prices. As soon as I
> removed Stock Connector, the SMF context menu choice disappeared, so now
> the behavior is consistent across both PCs - the SMF context menu choice
> does not appear unless I open the Developer tab and forcibly execute the
> modMenu module.
>
> Now for the question. Since your add-in loads when Excel starts and
> before I can open the VBA Developer tab, how do I set a breakpoint in the
> Auto_Open and Auto_Close subroutines of modMenu that will persist until the
> next time I start Excel? I hope this question makes sense. My initial
> reaction is to save a renamed copy of your .xla file with the breakpoints
> and then use it temporarily as the add-in to load when Excel starts up.
>
> Thanks for being so patient with me.
>

Tue Nov 28, 2017 2:26 pm (PST) . Posted by:

"Marc Johnson" marclerjohnson

When I right-click in an Excel "table", the SMF context menu is not shown. Outside of the table, it displays normally. Perhaps an Excel feature, not a bug?

Marc Johnson

May you be Happy, Healthy, Wealthy and Wise!

Pursue those goals in the order shown. :)

From: Randy Harmelink rharmelink@gmail.com [smf_addin]

Sent: Tuesday, November 28, 11:24 AM

Subject: Re: [smf_addin] GetYahooPortfolioView "SMF" Update Choice Not Shown in Context Menu

To: smf_addin@yahoogroups.com

 

Your comment on "all it seems to do is use a user defined macro to force the add-in to load" confuses me. Nothing within the add-in could force it to load. The add-in is loaded when EXCEL starts up, because it is on the list of add-ins to load within the add-in manager.

When it is loaded, the Auto_Open routine should run, because that's a special name EXCEL recognizes as a routine to be run upon a particular event (i.e. the object being opened).

You could try putting a break point within the Auto_Close routine. It unloads the SMF menu. Maybe something is causing it to run prematurely?

On Tue, Nov 28, 2017 at 11:08 AM, dcash@

​...

 wrote:

Well, this problem is making me a little crazy.  I removed and then reloaded the add-in.  The first time I open a spreadsheet and right click a cell, the SMF option in the displayed menu.  Every time after that, the SMF option is not displayed.  If I use the developer tab, select the modMenu VBA module, set a break point in it near the end of the module and then select "run until cursor", the SMF menu option reappears until I exit Excel.  I have to do the same thing the next time I run Excel to get the SMF menu option to appear.  So I am concluding that something is preventing the modMenu module from running each time Excel starts on this particular PC.  It feels like one of those "run once" issues and I don't understand why it is happening.

I do not believe it is a file permission issue since I tried putting the add-in in a C:\ root directory subdirectory location and then unblocking the .xla file and I also loaded the add-in to the default Excel add-in location, which is in the user's AppData directory under roaming profiles.  Nothing makes any difference.  Finally, looking at the Auto_Open routine,

​​

all it seems to do is use a user defined macro to force the add-in to load and the add-in is already loaded when Excel starts.  Any other suggestions?

Your comment on "all it seems to do is use a user defined macro to force
the add-in to load" confuses me. Nothing within the add-in could force it
to load. The add-in is loaded when EXCEL starts up, because it is on the
list of add-ins to load within the add-in manager.

When it is loaded, the Auto_Open routine should run, because that's a
special name EXCEL recognizes as a routine to be run upon a particular
event (i.e. the object being opened).

You could try putting a break point within the Auto_Close routine. It
unloads the SMF menu. Maybe something is causing it to run prematurely?

On Tue, Nov 28, 2017 at 11:08 AM, dcash@
​...
wrote:

>
> Well, this problem is making me a little crazy. I removed and then
> reloaded the add-in. The first time I open a spreadsheet and right click a
> cell, the SMF option in the displayed menu. Every time after that, the SMF
> option is not displayed. If I use the developer tab, select the modMenu
> VBA module, set a break point in it near the end of the module and then
> select "run until cursor", the SMF menu option reappears until I exit
> Excel. I have to do the same thing the next time I run Excel to get the
> SMF menu option to appear. So I am concluding that something is preventing
> the modMenu module from running each time Excel starts on this particular
> PC. It feels like one of those "run once" issues and I don't understand
> why it is happening.
>
> I do not believe it is a file permission issue since I tried putting the
> add-in in a C:\ root directory subdirectory location and then unblocking
> the .xla file and I also loaded the add-in to the default Excel add-in
> location, which is in the user's AppData directory under roaming profiles.
> Nothing makes any difference. Finally, looking at the Auto_Open routine,
> ​​
> all it seems to do is use a user defined macro to force the add-in to load
> and the add-in is already loaded when Excel starts. Any other suggestions?
>

Tue Nov 28, 2017 2:36 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What type of "table" are you referring to? It certainly could be that
certain EXCEL features use their own special context menu and ignore any
customizations made to the regular context menu.

On Tue, Nov 28, 2017 at 3:26 PM, Marc Johnson marc.johnson@
​...
wrote:

>
> When I right-click in an Excel "table", the SMF context menu is not shown.
> Outside of the table, it displays normally. Perhaps an Excel feature, not a
> bug?
>
>
>

Tue Nov 28, 2017 2:47 pm (PST) . Posted by:

"Marc Johnson" marclerjohnson

https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c

Marc Johnson

May you be Happy, Healthy, Wealthy and Wise!

Pursue those goals in the order shown. :)

From: Randy Harmelink rharmelink@gmail.com [smf_addin]

Sent: Tuesday, November 28, 3:36 PM

Subject: Re: [smf_addin] GetYahooPortfolioView "SMF" Update Choice Not Shown in Context Menu

To: smf_addin@yahoogroups.com

 

What type of "table" are you referring to? It certainly could be that certain EXCEL features use their own special context menu and ignore any customizations made to the regular context menu.

On Tue, Nov 28, 2017 at 3:26 PM, Marc Johnson marc.johnson@

​...

 wrote:

When I right-click in an Excel "table", the SMF context menu is not shown. Outside of the table, it displays normally. Perhaps an Excel feature, not a bug?

What type of "table" are you referring to? It certainly could be that
certain EXCEL features use their own special context menu and ignore any
customizations made to the regular context menu.

On Tue, Nov 28, 2017 at 3:26 PM, Marc Johnson marc.johnson@
​...
wrote:

>
> When I right-click in an Excel "table", the SMF context menu is not shown.
> Outside of the table, it displays normally. Perhaps an Excel feature, not a
> bug?
>
>
>

Tue Nov 28, 2017 3:36 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Yeah. Formatting the range as a table means several items are changed in
the context menu. So they must add those options to the "default" context
menu instead of the current one.

On Tue, Nov 28, 2017 at 3:47 PM, Marc Johnson marc.johnson@
​...
wrote:

>
> https://support.office.com/en-us/article/Overview-of-Excel-
> tables-7ab0bb7d-3a9e-4b56-
> <https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c>
> a3c9
> <https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c>
> -6c94334e492c
> <https://support.office.com/en-us/article/Overview-of-Excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c>
>
>

Tue Nov 28, 2017 3:36 pm (PST) . Posted by:

sabasu

Hi Randy and Gurus,


I am trying to get the M* Fair Value, Consider Buying and Consider Selling (RCHElementNumber 886,887 and 88) respectively, but getting an 'Error&#39; value. I also tested with smfTagContent also, but get the same result.


I have a premium account with Morninstar and I have ensured that I am logged-in to Morningstar before using the functions. I have also tried to Log-in to Morningstar by EXCEL Web Query dialog (alt+d+d+w).


I have IE11 and I do not know how to set the Security cookie.


Can you please let me know if there is a mistake I am making? This used work fine previously.


As always, thanks in advance to you.






For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.14

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)