11 Messages
Digest #4183
Messages
Thu Oct 26, 2017 10:06 pm (PDT) . Posted by:
mff2805
hi.
back again.
i cannot login to ibd any more. something changed relative to two weeks ago?
i also used the method in prior chain, which was cumbersome but would eventually work.
i've tried several times this past week, but no avail. i'm using windows 10, and office 2010. Is anyone else having trouble getting to IBD via the excel get web data option and login in?
i'd hate to update to office 2016 or 365 just to find out that doesn;t work either.
help, anyone?
thanks much,
Mike
back again.
i cannot login to ibd any more. something changed relative to two weeks ago?
i also used the method in prior chain, which was cumbersome but would eventually work.
i've tried several times this past week, but no avail. i'm using windows 10, and office 2010. Is anyone else having trouble getting to IBD via the excel get web data option and login in?
i'd hate to update to office 2016 or 365 just to find out that doesn;t work either.
help, anyone?
thanks much,
Mike
Thu Oct 26, 2017 11:22 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I use Office 365 and IBD is working for me. But I haven't tried logging in
recently...
On Thu, Oct 26, 2017 at 10:06 PM, mff3429@
...
wrote:
>
> back again.
> i cannot login to ibd any more. something changed relative to two weeks
> ago?
> i also used the method in prior chain, which was cumbersome but would
> eventually work.
> i've tried several times this past week, but no avail. i'm using windows
> 10, and office 2010. Is anyone else having trouble getting to IBD via the
> excel get web data option and login in?
> i'd hate to update to office 2016 or 365 just to find out that doesn;t
> work either.
> help, anyone?
>
recently...
On Thu, Oct 26, 2017 at 10:06 PM, mff3429@
...
wrote:
>
> back again.
> i cannot login to ibd any more. something changed relative to two weeks
> ago?
> i also used the method in prior chain, which was cumbersome but would
> eventually work.
> i've tried several times this past week, but no avail. i'm using windows
> 10, and office 2010. Is anyone else having trouble getting to IBD via the
> excel get web data option and login in?
> i'd hate to update to office 2016 or 365 just to find out that doesn;t
> work either.
> help, anyone?
>
Thu Oct 26, 2017 11:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
No, sorry. I wouldn't even know where to find it.
On Thu, Oct 26, 2017 at 6:38 PM, timdbui@
...
wrote:
> Do you have an Element Number to get the CIK code of a company?
>
>
>
On Thu, Oct 26, 2017 at 6:38 PM, timdbui@
...
wrote:
> Do you have an Element Number to get the CIK code of a company?
>
>
>
Fri Oct 27, 2017 5:13 am (PDT) . Posted by:
timdbui
Thank you, Randy. I get that number from the SEC Edgar website manually. I thought if you had that code, that would save time.
Thank you again!
Tim
https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000014930&type=10-K&dateb=&owner=exclude&count=40 https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000014930&type=10-K&dateb=&owner=exclude&count=40
Thank you again!
Tim
https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000014930&type=10-K&dateb=&owner=exclude&count=40 https://www.sec.gov/cgi-bin/browse-edgar?action=getcompany&CIK=0000014930&type=10-K&dateb=&owner=exclude&count=40
Fri Oct 27, 2017 7:30 am (PDT) . Posted by:
john_hoel
Once again the SMF options were absent from the context menu when I started Excel today. I decided to do some sleuthing in the VBA code and found sub smfAddToCellMenu. This looks like what should execute automatically to add SMF to the context menu. I put the curse on the ending statement of the sub and selected Debug->Run to Cursor. Success, SMF is now in the context menu.
Not everyone is going to have the experience to debug a situation like this, so we need some direction on how to automate this process. Ordinarily it just 'happens', but if it does not, is there some reliable way to make it happen without trying to read VBA?
Not everyone is going to have the experience to debug a situation like this, so we need some direction on how to automate this process. Ordinarily it just 'happens&#
Fri Oct 27, 2017 6:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If it's not there, all you should need to do:
1. Alt+F8 to open the macro dialog
2. For "Macro name", type in "smfAddToCellMenu"
3. Click "Run" when the button activates
The big question is why the "Auto_Load" routine isn't automatically running
when you load the add-in?
On Fri, Oct 27, 2017 at 7:30 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Once again the SMF options were absent from the context menu when I
> started Excel today. I decided to do some sleuthing in the VBA code and
> found sub smfAddToCellMenu. This looks like what should execute
> automatically to add SMF to the context menu. I put the curse on the ending
> statement of the sub and selected Debug->Run to Cursor. Success, SMF is now
> in the context menu.
>
> Not everyone is going to have the experience to debug a situation like
> this, so we need some direction on how to automate this process. Ordinarily
> it just 'happens', but if it does not, is there some reliable way to make
> it happen without trying to read VBA?
>
1. Alt+F8 to open the macro dialog
2. For "Macro name", type in "smfAddToCellMenu"
3. Click "Run" when the button activates
The big question is why the "Auto_Load" routine isn't automatically running
when you load the add-in?
On Fri, Oct 27, 2017 at 7:30 AM, john@nerva.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> Once again the SMF options were absent from the context menu when I
> started Excel today. I decided to do some sleuthing in the VBA code and
> found sub smfAddToCellMenu. This looks like what should execute
> automatically to add SMF to the context menu. I put the curse on the ending
> statement of the sub and selected Debug->Run to Cursor. Success, SMF is now
> in the context menu.
>
> Not everyone is going to have the experience to debug a situation like
> this, so we need some direction on how to automate this process. Ordinarily
> it just 'happens&#
> it happen without trying to read VBA?
>
Fri Oct 27, 2017 6:13 pm (PDT) . Posted by:
"Joe Mo" joe_mo37
Randy,I've had the same problem with the context menu not loading (Windows 7, Excel 2010). My fix was to put a button to run Auto_Load on the QAT. I do this whenever I start Excel.
On Friday, October 27, 2017, 8:04:15 PM CDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
If it's not there, all you should need to do:
1. Alt+F8 to open the macro dialog2. For "Macro name", type in "smfAddToCellMenu"3. Click "Run" when the button activates
The big question is why the "Auto_Load" routine isn't automatically running when you load the add-in?
On Fri, Oct 27, 2017 at 7:30 AM, john@nerva.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Once again the SMF options were absent from the context menu when I started Excel today. I decided to do some sleuthing in the VBA code and found sub smfAddToCellMenu. This looks like what should execute automatically to add SMF to the context menu. I put the curse on the ending statement of the sub and selected Debug->Run to Cursor. Success, SMF is now in the context menu.
Not everyone is going to have the experience to debug a situation like this, so we need some direction on how to automate this process. Ordinarily it just 'happens', but if it does not, is there some reliable way to make it happen without trying to read VBA?
#yiv4641811307 #yiv4641811307 -- #yiv4641811307ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4641811307 #yiv4641811307ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4641811307 #yiv4641811307ygrp-mkp #yiv4641811307hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4641811307 #yiv4641811307ygrp-mkp #yiv4641811307ads {margin-bottom:10px;}#yiv4641811307 #yiv4641811307ygrp-mkp .yiv4641811307ad {padding:0 0;}#yiv4641811307 #yiv4641811307ygrp-mkp .yiv4641811307ad p {margin:0;}#yiv4641811307 #yiv4641811307ygrp-mkp .yiv4641811307ad a {color:#0000ff;text-decoration:none;}#yiv4641811307 #yiv4641811307ygrp-sponsor #yiv4641811307ygrp-lc {font-family:Arial;}#yiv4641811307 #yiv4641811307ygrp-sponsor #yiv4641811307ygrp-lc #yiv4641811307hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4641811307 #yiv4641811307ygrp-sponsor #yiv4641811307ygrp-lc .yiv4641811307ad {margin-bottom:10px;padding:0 0;}#yiv4641811307 #yiv4641811307actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4641811307 #yiv4641811307activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4641811307 #yiv4641811307activity span {font-weight:700;}#yiv4641811307 #yiv4641811307activity span:first-child {text-transform:uppercase;}#yiv4641811307 #yiv4641811307activity span a {color:#5085b6;text-decoration:none;}#yiv4641811307 #yiv4641811307activity span span {color:#ff7900;}#yiv4641811307 #yiv4641811307activity span .yiv4641811307underline {text-decoration:underline;}#yiv4641811307 .yiv4641811307attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4641811307 .yiv4641811307attach div a {text-decoration:none;}#yiv4641811307 .yiv4641811307attach img {border:none;padding-right:5px;}#yiv4641811307 .yiv4641811307attach label {display:block;margin-bottom:5px;}#yiv4641811307 .yiv4641811307attach label a {text-decoration:none;}#yiv4641811307 blockquote {margin:0 0 0 4px;}#yiv4641811307 .yiv4641811307bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4641811307 .yiv4641811307bold a {text-decoration:none;}#yiv4641811307 dd.yiv4641811307last p a {font-family:Verdana;font-weight:700;}#yiv4641811307 dd.yiv4641811307last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4641811307 dd.yiv4641811307last p span.yiv4641811307yshortcuts {margin-right:0;}#yiv4641811307 div.yiv4641811307attach-table div div a {text-decoration:none;}#yiv4641811307 div.yiv4641811307attach-table {width:400px;}#yiv4641811307 div.yiv4641811307file-title a, #yiv4641811307 div.yiv4641811307file-title a:active, #yiv4641811307 div.yiv4641811307file-title a:hover, #yiv4641811307 div.yiv4641811307file-title a:visited {text-decoration:none;}#yiv4641811307 div.yiv4641811307photo-title a, #yiv4641811307 div.yiv4641811307photo-title a:active, #yiv4641811307 div.yiv4641811307photo-title a:hover, #yiv4641811307 div.yiv4641811307photo-title a:visited {text-decoration:none;}#yiv4641811307 div#yiv4641811307ygrp-mlmsg #yiv4641811307ygrp-msg p a span.yiv4641811307yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4641811307 .yiv4641811307green {color:#628c2a;}#yiv4641811307 .yiv4641811307MsoNormal {margin:0 0 0 0;}#yiv4641811307 o {font-size:0;}#yiv4641811307 #yiv4641811307photos div {float:left;width:72px;}#yiv4641811307 #yiv4641811307photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4641811307 #yiv4641811307photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4641811307 #yiv4641811307reco-category {font-size:77%;}#yiv4641811307 #yiv4641811307reco-desc {font-size:77%;}#yiv4641811307 .yiv4641811307replbq {margin:4px;}#yiv4641811307 #yiv4641811307ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4641811307 #yiv4641811307ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4641811307 #yiv4641811307ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4641811307 #yiv4641811307ygrp-mlmsg select, #yiv4641811307 input, #yiv4641811307 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4641811307 #yiv4641811307ygrp-mlmsg pre, #yiv4641811307 code {font:115% monospace;}#yiv4641811307 #yiv4641811307ygrp-mlmsg * {line-height:1.22em;}#yiv4641811307 #yiv4641811307ygrp-mlmsg #yiv4641811307logo {padding-bottom:10px;}#yiv4641811307 #yiv4641811307ygrp-msg p a {font-family:Verdana;}#yiv4641811307 #yiv4641811307ygrp-msg p#yiv4641811307attach-count span {color:#1E66AE;font-weight:700;}#yiv4641811307 #yiv4641811307ygrp-reco #yiv4641811307reco-head {color:#ff7900;font-weight:700;}#yiv4641811307 #yiv4641811307ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4641811307 #yiv4641811307ygrp-sponsor #yiv4641811307ov li a {font-size:130%;text-decoration:none;}#yiv4641811307 #yiv4641811307ygrp-sponsor #yiv4641811307ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4641811307 #yiv4641811307ygrp-sponsor #yiv4641811307ov ul {margin:0;padding:0 0 0 8px;}#yiv4641811307 #yiv4641811307ygrp-text {font-family:Georgia;}#yiv4641811307 #yiv4641811307ygrp-text p {margin:0 0 1em 0;}#yiv4641811307 #yiv4641811307ygrp-text tt {font-size:120%;}#yiv4641811307 #yiv4641811307ygrp-vital ul li:last-child {border-right:none !important;}#yiv4641811307
On Friday, October 27, 2017, 8:04:15 PM CDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
If it's not there, all you should need to do:
1. Alt+F8 to open the macro dialog2. For "Macro name", type in "smfAddToCellMenu"3. Click "Run" when the button activates
The big question is why the "Auto_Load" routine isn't automatically running when you load the add-in?
On Fri, Oct 27, 2017 at 7:30 AM, john@nerva.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Once again the SMF options were absent from the context menu when I started Excel today. I decided to do some sleuthing in the VBA code and found sub smfAddToCellMenu. This looks like what should execute automatically to add SMF to the context menu. I put the curse on the ending statement of the sub and selected Debug->Run to Cursor. Success, SMF is now in the context menu.
Not everyone is going to have the experience to debug a situation like this, so we need some direction on how to automate this process. Ordinarily it just 'happens&#
#yiv4641811307 #yiv4641811307 -- #yiv4641811307ygrp-
Fri Oct 27, 2017 6:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Any pattern you guys have noticed? For example:
1. Start EXCEL first, then open a workbook?
2. Open a workbook from a link, that opens EXCEL?
3. Open a workbook from a link (with macros), that opens EXCEL?
4. Open a workbook from a link (with its own Auto_Load macro), that opens
EXCEL?
5. Other add-ins being loaded when EXCEL opens (and do they have an
Auto_Load macro)?
I'm sure there are other situations that might occur.
On Fri, Oct 27, 2017 at 6:13 PM, Joe Mo joe_mo37@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I've had the same problem with the context menu not loading (Windows 7,
> Excel 2010). My fix was to put a button to run Auto_Load on the QAT. I do
> this whenever I start Excel.
>
>
1. Start EXCEL first, then open a workbook?
2. Open a workbook from a link, that opens EXCEL?
3. Open a workbook from a link (with macros), that opens EXCEL?
4. Open a workbook from a link (with its own Auto_Load macro), that opens
EXCEL?
5. Other add-ins being loaded when EXCEL opens (and do they have an
Auto_Load macro)?
I'm sure there are other situations that might occur.
On Fri, Oct 27, 2017 at 6:13 PM, Joe Mo joe_mo37@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I've had the same problem with the context menu not loading (Windows 7,
> Excel 2010). My fix was to put a button to run Auto_Load on the QAT. I do
> this whenever I start Excel.
>
>
Fri Oct 27, 2017 9:26 am (PDT) . Posted by:
cere0003
I never would have figured that out so much much appreciated. One last follow up. How would I replace the hard keyed ticker "TSS" with a reference to an excel cell? Thanks!
Kevin
Kevin
Fri Oct 27, 2017 9:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just replace it with the cell reference.
=smfGetYahooJSONField(A1,"financialData","quoteSummary.
result.0.financialData.targetMeanPrice.raw")
On Fri, Oct 27, 2017 at 9:26 AM, cere0003@
...
wrote:
>
> I never would have figured that out so much much appreciated. One last
> follow up. How would I replace the hard keyed ticker "TSS" with a
> reference to an excel cell? Thanks!
>
>
>
=smfGetYahooJSONFie
result.0.financialD
On Fri, Oct 27, 2017 at 9:26 AM, cere0003@
...
wrote:
>
> I never would have figured that out so much much appreciated. One last
> follow up. How would I replace the hard keyed ticker "TSS" with a
> reference to an excel cell? Thanks!
>
>
>
Fri Oct 27, 2017 11:55 am (PDT) . Posted by:
cere0003
It never dawned on me to just use the cell reference. I was trying to use quotes and the ampersand like the old formula had. Working great. Thanks for all your work!
Kevin
Kevin
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar