Senin, 26 Maret 2018

[smf_addin] Digest Number 4319

15 Messages

Digest #4319
2b
Re: SMF Add-in not working by "Randy Harmelink" rharmelink
2d
Re: SMF Add-in not working by "Randy Harmelink" rharmelink
2f
Re: SMF Add-in not working by "Randy Harmelink" rharmelink
2i
Re: SMF Add-in not working by "Randy Harmelink" rharmelink
2k
Re: Yahoo real time quotes intraday? by "Pieter van Leeuwen" pietertvl

Messages

Sat Mar 24, 2018 11:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

smfForceRecalculation is a macro you need to run to force the add-in to
retrieve fresh copies of web pages. See the "FAQs and Tips" web page for
information on it.

On Sat, Mar 24, 2018 at 11:37 AM, cschwartz@
​...
wrote:

>
> Thanks how do I use this (and where do I place the string).
>
>
>

Sat Mar 24, 2018 1:59 pm (PDT) . Posted by:

stumpy_chris

Steps I took:

1. Did the Drop down for Macros
2. Selected View Macros
3. Added the Macros "smfForceRecalculation"
4. Hit Run


Nothing changes.

Sat Mar 24, 2018 2:00 pm (PDT) . Posted by:

stumpy_chris

My bad. Jumped the gun too soon.

I did save the file as Macro Enabled. I closed it and reopened it - seems to works.


Thanks.

Sun Mar 25, 2018 3:16 pm (PDT) . Posted by:

raig002

Hi Randy:
I installed Office 2016 and now nothing works, I installed the SMF Add-in according to the instructions and I did some troubleshooting, for example, I did the "Fix Links", I re-loaded the add-in, Browsing again and picking the RCH_Stock_Market_Functions.xla file.
I executed the =RCHGetElementNumber("Version") and I get:

Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In; Windows (64-bit) NT :.00; 16.0; ; ; 1) Also I execute =smfConvertData("1B") and I get : 1000000


So far, nothing works



So, I am wondering What is wrong? It looks like the Add-in is not active, How Can I active it?


Thanks, a lot.


Tony

Sun Mar 25, 2018 3:38 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If those two functions are working, the add-in is activated. Is it possible
you have some type of firewall that prevents EXCEL and the add-in from
accessing the Internet? What happens is you use the EXCEL Web Query dialog
(alt+d+d+w) to access this web page:

http://ogres-crypt.com/SMF/Elements/smf-elements-info.txt

What do you get with the formula:

=RCHGetWebData("http://ogres-crypt.com/SMF/Elements/smf-elements-info.txt
",1,100)

The smfFixLinks macro should only be necessary when opening up a workbook
that has unresolved links. For example, if it uses add-in functions, but
was saved when the add-in was installed in a different location.

On Sun, Mar 25, 2018 at 3:16 PM, raig002@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I installed Office 2016 and now nothing works, I installed the SMF Add-in
> according to the instructions and I did some troubleshooting, for
> example, I did the "Fix Links", I re-loaded the add-in, Browsing again and
> picking the RCH_Stock_Market_Functions.xla file.
>
> I executed the =RCHGetElementNumber("Version&quot;) and I get:
>
> Stock Market Functions add-in, Version 2.1.2018.01.24 (C:\SMF Add-In;
> Windows (64-bit) NT :.00; 16.0; ; ; 1)
>
> Also I execute =smfConvertData("1B") and I get : 1000000
>
> So far, nothing works
>
> So, I am wondering What is wrong? It looks like the Add-in is not active,
> How Can I active it?
>
>
>

Sun Mar 25, 2018 4:22 pm (PDT) . Posted by:

raig002


From Excel Web Query http://ogres-crypt.com/SMF/Elements/smf-elements-info..txt http://ogres-crypt.com/SMF/Elements/smf-elements-info.txt
I got:
The add-in loads element definitions from files smf-elements-0.txt thru smf-elements-20.txt, in that order, if they exist. I'd suggest creating the currently non-existing smf-elements-20.txt file for your own element definitions. Otherwise, if you put them into an existing file, they would get wiped out if you need to replace the file with a new update from me. The #20 file will also be loaded last, so you can override and replace other element definitions by just reusing the element number. Files currently used by the add-in for existing element definitions: smf-elements-0.txt = Calculated data elements smf-elements-1.txt = MSN data elements smf-elements-2.txt = Yahoo data elements smf-elements-3.txt = Google data elements smf-elements-4.txt = Morningstar data elements smf-elements-5.txt = Reuters data elements smf-elements-6.txt = Zacks data elements smf-elements-7.txt = AdvFN data elements smf-elements-8.txt = Earnings.com data elements smf-elements-9.txt = Other misc data elements
Original method of definining an element (basically parameters of the RCHGetTableCell function): #;source;element;url;cells;find1;find2;find3;find4;rows;end;look;type New method of defining an element (a much simpler and more flexible version): #;source;name;formula where: "#" is the index for all element definitions. It can be anything from 1 to 20000. "source" can be whatever you want. I try to use a unique group name for all elements coming from the same web page. It is informational only, and not critical to anything. "name" is the name of the element, and can be whatever you want. It is informational only, and not critical to anything. "formula" can be the add-in formula you use in a worksheet cell, except that five tildas (i.e.. "~~~~~") should be where you want the "Ticker" parameter from the RCHGetElementNumber() formula to be placed. For example, suppose I had this formula retrieving the 20-day volume for ticker MMM from website stockscores.com: =RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20 Day Avg Vol") I could define an element number by adding an element number, the name of the source, the name of the element, and then the formula (changing the ticker symbol to "~~~~~"): 785;StockScores;20 Day Avg Vol;=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~",1,"20 Day Avg Vol") Once loaded, this formula would be the equivalent of the original formula: =RCHGetElementNumber("MMM",785) ----------------------------------------------------------


With the formula: =RCHGetWebData("http://ogres-crypt.com/SMF/Elements/smf-elements-info.txt http://ogres-crypt.com/SMF/Elements/smf-elements-info.txt",1,100)

I got same thing:
The add-in loads element definitions from files smf-elements-0.txt thru smf-elements-20.txt, in that order, if they exist. I'd suggest creating the currently non-existing smf-elements-20.txt file for your own element definitions. Otherwise, if you put them into an existing file, they would get wiped out if you need to replace the file with a new update from me. The #20 file will also be loaded last, so you can override and replace other element definitions by just reusing the element number.

Files currently used by the add-in for existing element definitions:

smf-elements-0.txt = Calculated data elements
smf-elements-1.txt = MSN data elements
smf-elements-2.txt = Yahoo data elements
smf-elements-3.txt = Google data elements
smf-elements-4.txt = Morningstar data elements
smf-elements-5.txt = Reuters data elements
smf-elements-6.txt = Zacks data elements
smf-elements-7.txt = AdvFN data elements
smf-elements-8.txt = Earnings.com data elements
smf-elements-9.txt = Other misc data elements

Original method of definining an element (basically parameters of the RCHGetTableCell function):

#;source;element;url;cells;find1;find2;find3;find4;rows;end;look;type

New method of defining an element (a much simpler and more flexible version):

#;source;name;formula

where:

"#" is the index for all element definitions. It can be anything from 1 to 20000.

"source" can be whatever you want. I try to use a unique group name for all elements coming from the same web page.
It is informational only, and not critical to anything.

"name" is the name of the element, and can be whatever you want. It is informational only, and not critical to anything.

"formula" can be the add-in formula you use in a worksheet cell, except that five tildas (i.e. "~~~~~") should be
where you want the "Ticker" parameter from the RCHGetElementNumber() formula to be placed.

For example, suppose I had this formula retrieving the 20-day volume for ticker MMM from website stockscores.com:

=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20 Day Avg Vol")

I could define an element number by adding an element number, the name of the source, the name of the element, and then the formula (changing the ticker symbol to "~~~~~"):

785;StockScores;20 Day Avg Vol;=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~",1,"20 Day Avg Vol")

Once loaded, this formula would be the equivalent of the original formula:

=RCHGetElementNumber("MMM";,785)



I also disabled Windows Defender Firewall and same problem.No idea what is going on.


Thanks











Sun Mar 25, 2018 4:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It appears both EXCEL and the add-in can access the Internet just fine.

So, what do you get with:

=RCHGetTableCell("https://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20
Day Avg Vol")
=RCHGetElementNumber("MMM",785)
=RCHGetTableCell("https://www.stockscores.com/charts/charts/?ticker=MMM",1,"20
Day Avg Vol")

On Sun, Mar 25, 2018 at 4:22 PM, raig002@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> From Excel Web Query http://ogres-crypt.com/S
> MF/Elements/smf-elements-info.txt
> I got:
> ​​
>
The add-in loads element definitions
> ​...
> ----------------------------------------------------------
> ----------------------------------------------------------
>
>
> With the formula:
> =RCHGetWebData("http://ogres-crypt.com/SMF/Elements/smf-elements-info.txt
> ",1,100)
> I got same thing:
>

Sun Mar 25, 2018 5:29 pm (PDT) . Posted by:

raig002


Here are the results:


=RCHGetTableCell("https://www. stockscores.com/quickreport. asp?ticker=MMM https://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20 Day Avg Vol"
Error


=RCHGetElementNumber("MMM", 785)

2575325



=RCHGetTableCell("https://www.stockscores.com/charts/charts/?ticker=MMM",1,"20 Day Avg Vol")

2575325



Thanks




Sun Mar 25, 2018 6:05 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

So the add-in is working.

It's odd that the 2nd one worked, but not the first. The first **IS** the
definition of element #785.

On Sun, Mar 25, 2018 at 5:29 PM, raig002@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Here are the results:
>
> =RCHGetTableCell("https://www. stockscores.com/quickreport. asp?ticker=MMM
> <https://www.stockscores.com/quickreport.asp?ticker=MMM>",1,"20 Day Avg
> Vol"
> Error
>
> =
> ​​
> RCHGetElementNumber("MMM", 785)
> 2575325
>
> =RCHGetTableCell("https://www.stockscores.com/charts/charts/?ticker=MMM",1,"20
> Day Avg Vol")
> 2575325
>
>

Sun Mar 25, 2018 7:00 pm (PDT) . Posted by:

raig002


I removed the blanks (after www. and before asp) in the internet link from the FIRST

=RCHGetTableCell("https://www. stockscores.com/quickreport. asp?ticker=MMM https://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20 Day Avg Vol"
Error



After the modification the result :
=RCHGetTableCell("https://www.stockscores.com/quickreport.asp?ticker=MMM https://www.stockscores.com/quickreport.asp?ticker=MMM",1,"20 Day Avg Vol"
2575325





Thanks



Sun Mar 25, 2018 7:29 pm (PDT) . Posted by:

raig002



So still nothing works, I have not idea what is the problem. I am frustrated that the add-ins does not work in my spreadsheet.




Sun Mar 25, 2018 8:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You'll need to give me specific examples of what is not working, because
the functions I'm giving you are working...

On Sun, Mar 25, 2018 at 7:29 PM, raig002@
​...
wrote:

>
> So still nothing works, I have not idea what is the problem. I am
> frustrated that the add-ins does not work in my spreadsheet.
>
>

Sun Mar 25, 2018 9:11 pm (PDT) . Posted by:

raig002

Hi Randy:


Finally, I think I found the problem in my spreadsheet, I am using the RCHGetYahooQuotes() function,
and after reading a post on the Forum, I realized that this function is replaced by smfGetYahooPortfolioView, so I will read the documentation and modify my spreadsheet with this function.




Thanks a lot.

Mon Mar 26, 2018 9:27 am (PDT) . Posted by:

"Pieter van Leeuwen" pietertvl

Hi Randy .... I'm using your addin using Google Finance and Googlesheets, to import nearly real time OHLC quotes into Excel per your blog guidance from months ago. (And its working)

I'm wondering if there is still any kind of Yahoo "API" style alternative? Such as involving perhaps Portfolio View instead, as I'm not familiar with what that does.

The reason I'm asking ... aside from seeking a backup ... is that I use an after hours service for daily updates and the Google Finance data are horribly off on the volumes reported intraday.

And .. there are more than a few symbols for which Google Finance seems unwilling to furnish quotes. OIH, as one example. OILD and OILU as others. There are plenty.

If there is an Yahoo alternative, please point me in the right direction. Thanks again for your continuing efforts.

Cheers

Pieter

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Sunday, March 25, 2018 8:01 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: SMF Add-in not working

You'll need to give me specific examples of what is not working, because the functions I'm giving you are working...

On Sun, Mar 25, 2018 at 7:29 PM, raig002@

​...

wrote:

So still nothing works, I have not idea what is the problem. I am frustrated that the add-ins does not work in my spreadsheet..

Mon Mar 26, 2018 11:17 am (PDT) . Posted by:

brad.reel

Hi everyone. I have a list of symbols I pull in from a screen.. The screen is a mish-mash of equities and ETF's. I don't have any way within the screen to determine whether a symbol is an equity or ETF. However, it would make some of my downstream activities much easier if I could add a filter for this.


Does anyone know of an easy way to look up a symbol and determine if it is an ETF? Any help appreciated.

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)