4 Messages
Digest #4052
Messages
Wed Jun 7, 2017 7:18 am (PDT) . Posted by:
nanastasakis
Hey Randy - hope you're doing well.
I'm looking to see if we can add a data element from Morningstar. There are several elements (13931,13933,13935,13946,13948,13950) that pull various valuation ratios from a stock's page with the Current value and a 5 year average value for P/E, P/S & Dividend Yield. On that page on Morningstar there's an additional valuation ratio we like to monitor, but it's not on the elements page for Payout Ratio. I'd love to be able to pull the same metrics - current & 5 year average like those others. Is that a do-able request?
Much appreciative of all you do.
I'm looking to see if we can add a data element from Morningstar. There are several elements (13931,13933,
Much appreciative of all you do.
Wed Jun 7, 2017 11:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Do you have a source for the data?
On Wed, Jun 7, 2017 at 7:18 AM, nanastasakis@
...
wrote:
> I'm looking to see if we can add a data element from Morningstar. There
> are several elements (13931,13933,13935,13946,13948,13950) that pull
> various valuation ratios from a stock's page with the Current value and a 5
> year average value for P/E, P/S & Dividend Yield. On that page on
> Morningstar there's an additional valuation ratio we like to monitor, but
> it's not on the elements page for Payout Ratio. I'd love to be able to
> pull the same metrics - current & 5 year average like those others. Is
> that a do-able request?
>
>
>
On Wed, Jun 7, 2017 at 7:18 AM, nanastasakis@
...
wrote:
> I'm looking to see if we can add a data element from Morningstar. There
> are several elements (13931,13933,
> various valuation ratios from a stock's page with the Current value and a 5
> year average value for P/E, P/S & Dividend Yield. On that page on
> Morningstar there's an additional valuation ratio we like to monitor, but
> it's not on the elements page for Payout Ratio. I'd love to be able to
> pull the same metrics - current & 5 year average like those others. Is
> that a do-able request?
>
>
>
Wed Jun 7, 2017 7:35 am (PDT) . Posted by:
"steve thompson" stevet99uk
I have found a way to ensure the xla is loaded at startup in Excel 2013. It
used to do it itself before but maybe a update or change to latest windows
10 stopped it.
I added the routine
Private Sub Workbook_Open()
Dim success As Boolean
Dim myAddIn As AddIn
MsgBox ("loading XLA at startup")
' Load XLL
success = Application.RegisterXLL("C:\SMF
Add-in\RCH_Stock_Market_Functions.xla")
' Load RCH XLAM
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_Market_Functions.xla" Then
myAddIn.Installed = False
myAddIn.Installed = True
End If
Next
End Sub
If anyone tries this and adds some embelishements to it let me know as I am
tied up at present as wife passed last week and kids need me
steve
used to do it itself before but maybe a update or change to latest windows
10 stopped it.
I added the routine
Private Sub Workbook_Open(
Dim success As Boolean
Dim myAddIn As AddIn
MsgBox ("loading XLA at startup"
' Load XLL
success = Application.
Add-in\RCH_
' Load RCH XLAM
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_
myAddIn.Installed = False
myAddIn.Installed = True
End If
Next
End Sub
If anyone tries this and adds some embelishements to it let me know as I am
tied up at present as wife passed last week and kids need me
steve
Wed Jun 7, 2017 9:00 am (PDT) . Posted by:
"Joe Mo" joe_mo37
Thanks for that Steve. I was having a similar problem with Excel 2010 since I installed Randy's beta version. I modified your code somewhat and placed it in a standard module in my PERSONAL.XLSB workbook. I then call the module from a workbook_open event since PERSONAL.XLSB is automatically opened whenever the Excel App is started. This ensures that the add-in is opened whenever Excel starts. Here's the code:
Standard Module in PERSONAL.XLSB:
Sub LoadSMFaddIn() Dim myAddIn As AddIn
MsgBox "loading RCH_Stock_Market_Functions.xla at startup"
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_Market_Functions.xla" Then
myAddIn.Installed = False
myAddIn.Installed = True
End If
Next
End Sub
ThisWorkbook module in PERSONAL.XLSB:
Private Sub Workbook_Open()Call LoadSMFaddIn
End Sub
Joe
On Wednesday, June 7, 2017, 9:35:16 AM CDT, 'steve thompson' stevethompson486@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I have found a way to ensure the xla is loaded at startup in Excel 2013. It used to do it itself before but maybe a update or change to latest windows 10 stopped it.
I added the routine
Private Sub Workbook_Open()
Dim success As Boolean
Dim myAddIn As AddIn
MsgBox ("loading XLA at startup")
' Load XLL
success = Application.RegisterXLL("C:\SMF Add-in\RCH_Stock_Market_Functions.xla")
' Load RCH XLAM
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_Market_Functions.xla" Then
myAddIn.Installed = False
myAddIn.Installed = True
End If
Next
End Sub
If anyone tries this and adds some embelishements to it let me know as I am tied up at present as wife passed last week and kids need me
steve
#yiv8508207259 #yiv8508207259 -- #yiv8508207259ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8508207259 #yiv8508207259ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8508207259 #yiv8508207259ygrp-mkp #yiv8508207259hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8508207259 #yiv8508207259ygrp-mkp #yiv8508207259ads {margin-bottom:10px;}#yiv8508207259 #yiv8508207259ygrp-mkp .yiv8508207259ad {padding:0 0;}#yiv8508207259 #yiv8508207259ygrp-mkp .yiv8508207259ad p {margin:0;}#yiv8508207259 #yiv8508207259ygrp-mkp .yiv8508207259ad a {color:#0000ff;text-decoration:none;}#yiv8508207259 #yiv8508207259ygrp-sponsor #yiv8508207259ygrp-lc {font-family:Arial;}#yiv8508207259 #yiv8508207259ygrp-sponsor #yiv8508207259ygrp-lc #yiv8508207259hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8508207259 #yiv8508207259ygrp-sponsor #yiv8508207259ygrp-lc .yiv8508207259ad {margin-bottom:10px;padding:0 0;}#yiv8508207259 #yiv8508207259actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8508207259 #yiv8508207259activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8508207259 #yiv8508207259activity span {font-weight:700;}#yiv8508207259 #yiv8508207259activity span:first-child {text-transform:uppercase;}#yiv8508207259 #yiv8508207259activity span a {color:#5085b6;text-decoration:none;}#yiv8508207259 #yiv8508207259activity span span {color:#ff7900;}#yiv8508207259 #yiv8508207259activity span .yiv8508207259underline {text-decoration:underline;}#yiv8508207259 .yiv8508207259attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8508207259 .yiv8508207259attach div a {text-decoration:none;}#yiv8508207259 .yiv8508207259attach img {border:none;padding-right:5px;}#yiv8508207259 .yiv8508207259attach label {display:block;margin-bottom:5px;}#yiv8508207259 .yiv8508207259attach label a {text-decoration:none;}#yiv8508207259 blockquote {margin:0 0 0 4px;}#yiv8508207259 .yiv8508207259bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8508207259 .yiv8508207259bold a {text-decoration:none;}#yiv8508207259 dd.yiv8508207259last p a {font-family:Verdana;font-weight:700;}#yiv8508207259 dd.yiv8508207259last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8508207259 dd.yiv8508207259last p span.yiv8508207259yshortcuts {margin-right:0;}#yiv8508207259 div.yiv8508207259attach-table div div a {text-decoration:none;}#yiv8508207259 div.yiv8508207259attach-table {width:400px;}#yiv8508207259 div.yiv8508207259file-title a, #yiv8508207259 div.yiv8508207259file-title a:active, #yiv8508207259 div.yiv8508207259file-title a:hover, #yiv8508207259 div.yiv8508207259file-title a:visited {text-decoration:none;}#yiv8508207259 div.yiv8508207259photo-title a, #yiv8508207259 div.yiv8508207259photo-title a:active, #yiv8508207259 div.yiv8508207259photo-title a:hover, #yiv8508207259 div.yiv8508207259photo-title a:visited {text-decoration:none;}#yiv8508207259 div#yiv8508207259ygrp-mlmsg #yiv8508207259ygrp-msg p a span.yiv8508207259yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8508207259 .yiv8508207259green {color:#628c2a;}#yiv8508207259 .yiv8508207259MsoNormal {margin:0 0 0 0;}#yiv8508207259 o {font-size:0;}#yiv8508207259 #yiv8508207259photos div {float:left;width:72px;}#yiv8508207259 #yiv8508207259photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8508207259 #yiv8508207259photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8508207259 #yiv8508207259reco-category {font-size:77%;}#yiv8508207259 #yiv8508207259reco-desc {font-size:77%;}#yiv8508207259 .yiv8508207259replbq {margin:4px;}#yiv8508207259 #yiv8508207259ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8508207259 #yiv8508207259ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8508207259 #yiv8508207259ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8508207259 #yiv8508207259ygrp-mlmsg select, #yiv8508207259 input, #yiv8508207259 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8508207259 #yiv8508207259ygrp-mlmsg pre, #yiv8508207259 code {font:115% monospace;}#yiv8508207259 #yiv8508207259ygrp-mlmsg * {line-height:1.22em;}#yiv8508207259 #yiv8508207259ygrp-mlmsg #yiv8508207259logo {padding-bottom:10px;}#yiv8508207259 #yiv8508207259ygrp-msg p a {font-family:Verdana;}#yiv8508207259 #yiv8508207259ygrp-msg p#yiv8508207259attach-count span {color:#1E66AE;font-weight:700;}#yiv8508207259 #yiv8508207259ygrp-reco #yiv8508207259reco-head {color:#ff7900;font-weight:700;}#yiv8508207259 #yiv8508207259ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8508207259 #yiv8508207259ygrp-sponsor #yiv8508207259ov li a {font-size:130%;text-decoration:none;}#yiv8508207259 #yiv8508207259ygrp-sponsor #yiv8508207259ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8508207259 #yiv8508207259ygrp-sponsor #yiv8508207259ov ul {margin:0;padding:0 0 0 8px;}#yiv8508207259 #yiv8508207259ygrp-text {font-family:Georgia;}#yiv8508207259 #yiv8508207259ygrp-text p {margin:0 0 1em 0;}#yiv8508207259 #yiv8508207259ygrp-text tt {font-size:120%;}#yiv8508207259 #yiv8508207259ygrp-vital ul li:last-child {border-right:none !important;}#yiv8508207259
Standard Module in PERSONAL.XLSB:
Sub LoadSMFaddIn() Dim myAddIn As AddIn
MsgBox "loading RCH_Stock_Market_Functions.xla at startup"
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_Market_Functions.xla" Then
myAddIn.Installed = False
myAddIn.Installed = True
End If
Next
End Sub
ThisWorkbook module in PERSONAL.XLSB:
Private Sub Workbook_Open()Call LoadSMFaddIn
End Sub
Joe
On Wednesday, June 7, 2017, 9:35:16 AM CDT, 'steve thompson' stevethompson486@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I have found a way to ensure the xla is loaded at startup in Excel 2013. It used to do it itself before but maybe a update or change to latest windows 10 stopped it.
I added the routine
Private Sub Workbook_Open(
Dim success As Boolean
Dim myAddIn As AddIn
MsgBox ("loading XLA at startup"
' Load XLL
success = Application.
' Load RCH XLAM
For Each myAddIn In AddIns
If myAddIn.Name = "RCH_Stock_
myAddIn.Installed = False
myAddIn.Installed = True
End If
Next
End Sub
If anyone tries this and adds some embelishements to it let me know as I am tied up at present as wife passed last week and kids need me
steve
#yiv8508207259 #yiv8508207259 -- #yiv8508207259ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar