Jumat, 04 November 2016

[smf_addin] Digest Number 3834

11 Messages

Digest #3834
2b
Re: 20 Day moving avg. by "Randy Harmelink" rharmelink
2d
Re: 20 Day moving avg. by "Randy Harmelink" rharmelink
2f
Re: 20 Day moving avg. by "Randy Harmelink" rharmelink
2h
Re: 20 Day moving avg. by futants46and2
2i
Re: 20 Day moving avg. by "Randy Harmelink" rharmelink

Messages

Thu Nov 3, 2016 9:03 am (PDT) . Posted by:

rr76012

re: rchgetyahooquotes, key strokes to refresh download data.
I tried hitting F9 that did not work to download fresh data?


Hi Randy,


What are the keystrokes using rchgetyahooquotes to get a refresh on the data?


Thanks


Thu Nov 3, 2016 12:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to run the smfForceRecalculation macro. See the "Tips and FAQs"
page for info on it.

I have it assigned to a button on my toolbar, so it's available any time.

On Thu, Nov 3, 2016 at 9:03 AM, rr76012@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> re: rchgetyahooquotes, key strokes to refresh download data.
>
> I tried hitting F9 that did not work to download fresh data?
>
>
> Hi Randy,
>
> What are the keystrokes using rchgetyahooquotes to get a refresh on the
> data?
>
> Thanks
>
>

Thu Nov 3, 2016 10:10 am (PDT) . Posted by:

wolfiyah

Hi randy,

unfortunately the problem still persists.

Thu Nov 3, 2016 12:29 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. The whole template works for me. I just tried both MMM and SPY.

Did you exit EXCEL before updating the definitions?

On Thu, Nov 3, 2016 at 10:10 AM, p.wolfensberger@
​...wrote:

>
> Hi randy,
>
> unfortunately the problem still persists.
>
> __._,_.
>

Thu Nov 3, 2016 2:10 pm (PDT) . Posted by:

wolfiyah

Hi Randy,

No. Even after exiting Excel, still the same. When I debug just before evaluate, I can see that sFormula contains the new string from smf-elements-9.txt. But I assumed that this file was the only update I had to do. Am I wrong? My version is 2.1.2016.09.02

Thanks

Thu Nov 3, 2016 4:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

All you should need to do is update the element definition file.

Right now, after you have retrieved at least one element, this formula:

=smfGetAParms(1221)

...should be returning the element definition that was loaded:

BarChartTech;Moving Average -- 2;=smfGetTagContent("
https://www.barchart.com/stocks/quotes/~~~~~/technical-analysis","td",7,">Average
Volume",,,,1)

...with the "www" prefix on the URL instead of "quotes".

Does that formula in the definition work for you? That is:

=smfGetTagContent("
https://www.barchart.com/stocks/quotes/MMM/technical-analysis","td",7,">Average
Volume",,,,1)

On Thu, Nov 3, 2016 at 2:10 PM, p.wolfensberger@datacomm.ch [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> No. Even after exiting Excel, still the same. When I debug just before
> evaluate, I can see that sFormula contains the new string from
> smf-elements-9.txt. But I assumed that this file was the only update I had
> to do. Am I wrong? My version is 2.1.2016.09.02
>
> ​​

Thu Nov 3, 2016 5:08 pm (PDT) . Posted by:

wolfiyah

Hi Randy,

=smfGetAParms(1218) yields

BarChartTech;Percent Change -- 1;=smfGetTagContent("https://www.barchart.com/stocks/quotes/~~~~~/technical-analysis","td",4,">Average Volume",,,,1)

substituting and using

=smfGetTagContent("https://www.barchart.com/stocks/quotes/MMM/technical-analysis";"td";4;">Average Volume";;;;1)

produces

Error

Thu Nov 3, 2016 5:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

​Not sure what to tell you. If I copy your formula below and change all the
semi-colons to commas, it works fine here.

Is BarChart still delivering the old web pages to you? Or some other
variation? If you use the URL from that last formula in a browser, do you
end up at some other web address?

On Thu, Nov 3, 2016 at 5:08 PM, p.wolfensberger@datacomm.ch [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> =smfGetAParms(1218) yields
>
> BarChartTech;Percent Change -- 1;=
> ​​
> smfGetTagContent("https://www.barchart.com/stocks/quotes/~~~~~/technical-
> analysis","td",4,">Average Volume",,,,1)
>
> substituting and using
>
> =
> ​​
> smfGetTagContent("https://www.barchart.com/stocks/
> quotes/MMM/technical-analysis";"td";4;">Average Volume";;;;1)
>
> produces
>
> Error
>

Thu Nov 3, 2016 5:55 pm (PDT) . Posted by:

wolfiyah

Hi Randy,

=smfGetAParms(1218) yields
BarChartTech;Percent Change -- 1;=smfGetTagContent("https://www.barchart.com/stocks/quotes/~~~~~/technical-analysis","td",4,">Average Volume",,,,1)
substituting and using
=smfGetTagContent("https://www.barchart.com/stocks/quotes/MMM/technical-analysis";"td";4;">Average Volume";;;;1)
produces
Error

Thu Nov 3, 2016 6:54 pm (PDT) . Posted by:

futants46and2

HI Randy,

In the element definitions file I defined 1221 as


2;=smfGetTagContent("https://www.barchart.com/stocks/quotes/~~~~~/technical-analysis","td",7,">Average Volume",,,,1)



Then on the sheet that I pull the moving avg's I used


=smfGetTagContent("https://www.barchart.com/stocks/quotes/GIMO/technical-analysis","td",7,">Average Volume",,,,1)



Which yields the moving avg. However when I then use =smfGetAParms(A3,1221) I receive #value.


I am trying to pull moving avg's for 100 tickers, so I am trying to figure out a way to call the cell containing the ticker and corresponding moving avg.

Thanks






Thu Nov 3, 2016 10:39 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Thu, Nov 3, 2016 at 6:54 PM, futants46and2@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> In the element definitions file I defined 1221 as
>
> 2;=smfGetTagContent("https://www.barchart.com/stocks/
> quotes/~~~~~/technical-analysis","td",7,">Average Volume",,,,1)
>

​That makes no sense to me. It's not a valid element definition.​ The "2"
in my element definition is part of an element description. An element
definition of this format wold be:

element number;web page nickname;element description;formula

Then on the sheet that I pull the moving avg's I used
>
> =
> ​​
> ​​
> smfGetTagContent("https://www.barchart.com/stocks/
> quotes/GIMO/technical-analysis","td",7,">Average Volume",,,,1)
>

​If that works, the element definition I wrote should work.​

>
> Which yields the moving avg. However when I then use =smfGetAParms(A3,1221)
> I receive #value.
>

​It would. That function only has one parameter -- the element number.​

> I am trying to pull moving avg's for 100 tickers, so I am trying to figure
> out a way to call the cell containing the ticker and corresponding moving
> avg.
>

​If that formula above is working for you, you could just concatenate the
ticker symbol into the URL:

=smfGetTagContent("https://www.barchart.com/stocks/quotes/"&B6&"/technical-analysis","td",7,">Average
Volume",,,,1)​
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)