8 Messages
Digest #4470
Messages
Fri Jan 25, 2019 9:24 am (PST) . Posted by:
"The Kuffels" kuffel
After several years of using SMF with no problems, it has been a struggle using the new version.
Most recent problem is at random times the right-click no longer shows the SMF option at the bottom of the pop-up window. Usually I can get back the SMF option but I have no idea how. I'm trying to get to the "Recalculate Worksheet" to update prices.
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Most recent problem is at random times the right-click no longer shows the SMF option at the bottom of the pop-up window. Usually I can get back the SMF option but I have no idea how. I'm trying to get to the "Recalculate Worksheet" to update prices.
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Fri Jan 25, 2019 9:37 am (PST) . Posted by:
"Randy Harmelink" rharmelink
When it happens here, it's usually when I've been doing something within
the VBA environment. Some people have had it happen when another add-in is
involved (which may get i the way of the startup routines).
I think you can just run the Auto_Open routine via the macro dialog
(alt+F8) to restore the menu.
I rarely use the context menu as I have the smfForceRecalculation macro
assigned to a button my Quick Access toolbar.
On Fri, Jan 25, 2019 at 10:25 AM 'The Kuffels' kuffel@... wrote:
>
> After several years of using SMF with no problems, it has been a struggle
> using the new version.
>
> Most recent problem is at random times the right-click no longer shows the
> SMF option at the bottom of the pop-up window. Usually I can get back the
> SMF option but I have no idea how. I'm trying to get to the "Recalculate
> Worksheet" to update prices.
>
>
the VBA environment. Some people have had it happen when another add-in is
involved (which may get i the way of the startup routines).
I think you can just run the Auto_Open routine via the macro dialog
(alt+F8) to restore the menu.
I rarely use the context menu as I have the smfForceRecalculati
assigned to a button my Quick Access toolbar.
On Fri, Jan 25, 2019 at 10:25 AM 'The Kuffels' kuffel@... wrote:
>
> After several years of using SMF with no problems, it has been a struggle
> using the new version.
>
> Most recent problem is at random times the right-click no longer shows the
> SMF option at the bottom of the pop-up window. Usually I can get back the
> SMF option but I have no idea how. I'm trying to get to the "Recalculate
> Worksheet" to update prices.
>
>
Fri Jan 25, 2019 12:22 pm (PST) . Posted by:
"The Kuffels" kuffel
Randy,
No Jelly.
<< run the Auto_Open routine via the macro dialog (alt+F8) smfForceRecalculation macro >>
alt+F8 opens a blank Macro Dialog box. Posting either name in the upper box produces nothing but a highlight of the "Create" option.
<< doing something within the VBA environment. when another add-in is involved >>
I have never done anything in VBA. There is no other add-in loaded into the CPU.
It is the intermittent nature of the problem which has me most frustrated. Also one other symptom. Sometimes when the SMF menu goes away, a box using SMF changes to "VALUE". I think it is where the cursor is located when I do whatever I do to trigger the problem. Doing a Copy-formulaPaste from a nearby cell doesn't change this problem today although I has in the past.
CPU is a Dell laptop running Windows 10 with all the auto-updates.
Any other ideas? Reload SMF? All I need is current price. Any other software available for this job?
Thanks,
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
No Jelly.
<< run the Auto_Open routine via the macro dialog (alt+F8) smfForceRecalculation macro >>
alt+F8 opens a blank Macro Dialog box. Posting either name in the upper box produces nothing but a highlight of the "Create" option.
<< doing something within the VBA environment. when another add-in is involved >>
I have never done anything in VBA. There is no other add-in loaded into the CPU.
It is the intermittent nature of the problem which has me most frustrated. Also one other symptom. Sometimes when the SMF menu goes away, a box using SMF changes to "VALUE". I think it is where the cursor is located when I do whatever I do to trigger the problem. Doing a Copy-formulaPaste from a nearby cell doesn't change this problem today although I has in the past.
CPU is a Dell laptop running Windows 10 with all the auto-updates.
Any other ideas? Reload SMF? All I need is current price. Any other software available for this job?
Thanks,
Tom
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Fri Jan 25, 2019 3:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The macros would never be listed in the macro dialog, as it only lists
macros from open *workbooks*. But entering in the name should activate the
"Run" checkbox.
Sounds like something is unloading the add-in. The would cause the menu
items to be removed, cause any add-in functions to be lost (i.e. the
#VALUE! error), and mean the macros can't be run from the macro dialog.
Next time it happens, see if this function will work:
=RCHGetElementNumber("Version")
If that won't work, the add-in is no long active. The easiest fix is to
just go back into the add-in manager (alt+t+i) and reactive it by toggling
it back on.
On Fri, Jan 25, 2019 at 1:29 PM 'The Kuffels' kuffel@... wrote:
>
> No Jelly.
>
> << run the Auto_Open routine via the macro dialog (alt+F8)
> smfForceRecalculation macro >>
>
> alt+F8 opens a blank Macro Dialog box. Posting either name in the upper
> box produces nothing but a highlight of the "Create" option.
>
> << doing something within the VBA environment. when another add-in
> is involved >>
>
> I have never done anything in VBA. There is no other add-in loaded into
> the CPU.
>
> It is the intermittent nature of the problem which has me most
> frustrated. Also one other symptom. Sometimes when the SMF menu goes
> away, a box using SMF changes to "VALUE". I think it is where the cursor
> is located when I do whatever I do to trigger the problem. Doing a
> Copy-formulaPaste from a nearby cell doesn't change this problem today
> although I has in the past.
>
> CPU is a Dell laptop running Windows 10 with all the auto-updates.
>
> Any other ideas? Reload SMF? All I need is current price. Any other
> software available for this job?
>
>
>
macros from open *workbooks*. But entering in the name should activate the
"Run" checkbox.
Sounds like something is unloading the add-in. The would cause the menu
items to be removed, cause any add-in functions to be lost (i.e. the
#VALUE! error), and mean the macros can't be run from the macro dialog.
Next time it happens, see if this function will work:
=RCHGetElementNumbe
If that won't work, the add-in is no long active. The easiest fix is to
just go back into the add-in manager (alt+t+i) and reactive it by toggling
it back on.
On Fri, Jan 25, 2019 at 1:29 PM 'The Kuffels' kuffel@... wrote:
>
> No Jelly.
>
> << run the Auto_Open routine via the macro dialog (alt+F8)
> smfForceRecalculati
>
> alt+F8 opens a blank Macro Dialog box. Posting either name in the upper
> box produces nothing but a highlight of the "Create" option.
>
> << doing something within the VBA environment. when another add-in
> is involved >>
>
> I have never done anything in VBA. There is no other add-in loaded into
> the CPU.
>
> It is the intermittent nature of the problem which has me most
> frustrated. Also one other symptom. Sometimes when the SMF menu goes
> away, a box using SMF changes to "VALUE"
> is located when I do whatever I do to trigger the problem. Doing a
> Copy-formulaPaste from a nearby cell doesn't change this problem today
> although I has in the past.
>
> CPU is a Dell laptop running Windows 10 with all the auto-updates.
>
> Any other ideas? Reload SMF? All I need is current price. Any other
> software available for this job?
>
>
>
Fri Jan 25, 2019 1:37 pm (PST) . Posted by:
c.touchberry
Has anyone had any success in pulling data from Stockrow.com into excel? I am specifically interested in their Income Statements, Balance Sheet, Cash Flow data annually and quarterly. It seems to be a great free alternative to ADVFN and the data appears to be more accurate. Any help would be much appreciated!
Fri Jan 25, 2019 3:46 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Using the add-in to grab the data would be very difficult, because it's all
in JSON format. You'd need to retrieve and parse out something like:
https://stockrow.com/api/companies/MMM/financials.json?ticker=MMM&dimension=MRQ§ion=Income+Statement
....to get the actual data, and:
https://stockrow.com/api/indicators.json
....to understand what all the "id" fields in the first JSON file mean.
Instead, since they offer an export option, you could just use normal EXCEL
processing to bring in that. For example, you could array-enter something
like this:
='[
https://stockrow.com/api/companies/MMM/financials.xlsx?dimension=MRQ§ion=Income%20Statement&sort=desc]MMM'!$A$1:$AN$40
However, I'm not aware of any way to refer to a cell for the ticker symbol.
And, after you enter the formula, it moves the "[" symbol into a spot that
makes the formula invalid if you don't move it back to where it belongs. I
would call that an EXCEL bug.
*Note to self *-- VBA could automate it with:
Sub GetStockRowData0()
GetStockRowData (Range("rTicker").Value)
End Sub
Sub GetStockRowData(pTicker As String)
Range("A4:I15").FormulaArray = _
"='[https://stockrow.com/api/companies/" & pTicker &
"/financials.xlsx?dimension=MRQ§ion=Income%20Statement&sort=desc]" &
pTicker & "'!R1C1:R12C9"
End Sub
....but there is a delay as the external file is retrieved, during which the
cell values will be #REF!
On Fri, Jan 25, 2019 at 2:37 PM c.touchberry@... wrote:
> Has anyone had any success in pulling data from Stockrow.com into excel? I
> am specifically interested in their Income Statements, Balance Sheet, Cash
> Flow data annually and quarterly. It seems to be a great free alternative
> to ADVFN and the data appears to be more accurate. Any help would be much
> appreciated!
>
>
in JSON format. You'd need to retrieve and parse out something like:
https://stockrow.com/api/companies/MMM/financials.json?ticker=MMM&dimension=MRQ§ion=Income+Statement
....to get the actual data, and:
https://stockrow.com/api/indicators.json
....to understand what all the "id" fields in the first JSON file mean.
Instead, since they offer an export option, you could just use normal EXCEL
processing to bring in that. For example, you could array-enter something
like this:
='[
https://stockrow.com/api/companies/MMM/financials.xlsx?dimension=MRQ§ion=Income%20Statement&sort=desc]MMM'!$A$1:$AN$40
However, I'm not aware of any way to refer to a cell for the ticker symbol.
And, after you enter the formula, it moves the "[" symbol into a spot that
makes the formula invalid if you don't move it back to where it belongs. I
would call that an EXCEL bug.
*Note to self *-- VBA could automate it with:
Sub GetStockRowData0()
GetStockRowData (Range("rTicker").Value)
End Sub
Sub GetStockRowData(pTicker As String)
Range("A4:I15").FormulaArray = _
"='[https://stockrow.com/api/companies/" & pTicker &
"/financials.
pTicker & "'!
End Sub
....but there is a delay as the external file is retrieved, during which the
cell values will be #REF!
On Fri, Jan 25, 2019 at 2:37 PM c.touchberry@
> Has anyone had any success in pulling data from Stockrow.com into excel? I
> am specifically interested in their Income Statements, Balance Sheet, Cash
> Flow data annually and quarterly. It seems to be a great free alternative
> to ADVFN and the data appears to be more accurate. Any help would be much
> appreciated!
>
>
Fri Jan 25, 2019 8:41 pm (PST) . Posted by:
crollalanzaws
Thank you, it worked.
I'm not sure how you were able figure out the website for the RCHGetTableCell function. I couldn't see it anywhere in the HTML listing of the page, unless I'm just not seeing it.
I can't seem to pull back the fund name. However, when I inspect the HTML listing I do see it:
<div class="r_title">
<h1>Franklin Bissett Canadian Balanced Fund F</h1>
<span class="r_star4" id="star_span"></span>
<span class="df"></span>
</div>
Could you please let me know how to get back the fund name.
The closest I've been able to get is:
=smfGetTagContent("http://quotes.morningstar.com/fund/c-header?t="&A12&"
Thank you
Sat Jan 26, 2019 12:17 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I often use the "Developer Tools" option in my Chrome browser to see what
resources a web page is using. It even allows for the search of a value
across all of the called up resources, so it helps determine the applicable
resource.
For name, try:
=smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?t=F0CAN05N6O®ion=CAN&culture=en-CA&cur=CAD&productCode=CAN
","h1",1)
On Fri, Jan 25, 2019 at 9:41 PM florio.crollalanza@... wrote:
>
> I'm not sure how you were able figure out the website for the
> RCHGetTableCell function. I couldn't see it anywhere in the HTML listing
> of the page, unless I'm just not seeing it.
>
> I can't seem to pull back the fund name. However, when I inspect the HTML
> listing I do see it:
> <div class="r_title">
> <h1>Franklin Bissett Canadian Balanced Fund F</h1>
> <span class="r_star4" id="star_span"></span>
> <span class="df"></span>
> </div>
>
> Could you please let me know how to get back the fund name.
> The closest I've been able to get is:
> =smfGetTagContent("http://quotes.morningstar.com/fund/c-header?t=
> "&A12&"®ion=CAN&culture=en-CA&cur=CAD&productCode=CAN","div",-1,"r_title")
>
>
>
resources a web page is using. It even allows for the search of a value
across all of the called up resources, so it helps determine the applicable
resource.
For name, try:
=smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?t=F0CAN05N6O®ion=CAN&culture=en-CA&cur=CAD&productCode=CAN
","h1",1)
On Fri, Jan 25, 2019 at 9:41 PM florio.crollalanza@... wrote:
>
> I'm not sure how you were able figure out the website for the
> RCHGetTableCell function. I couldn't see it anywhere in the HTML listing
> of the page, unless I'm just not seeing it.
>
> I can't seem to pull back the fund name. However, when I inspect the HTML
> listing I do see it:
> <div class="r_title">
> <h1>Franklin Bissett Canadian Balanced Fund F</h1>
> <span class="r_star4" id="star_span"></span>
> <span class="df"></span>
> </div>
>
> Could you please let me know how to get back the fund name.
> The closest I've been able to get is:
> =smfGetTagContent("http://quotes.morningstar.com/fund/c-header?t=
> "&A12&"
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar