Kamis, 03 Mei 2018

[smf_addin] Digest Number 4327

15 Messages

Digest #4327
2b
Re: Security Certificate has be revoked.... by "Randy Harmelink" rharmelink
2c
3a
4-traders by lawleesh
3b
Re: 4-traders by "Randy Harmelink" rharmelink
3c
Re: 4-traders by lawleesh
6b
Re: Toteboard Company Fundamentals Workbood by "Randy Harmelink" rharmelink
6d
Re: Toteboard Company Fundamentals Workbood by "Randy Harmelink" rharmelink
7
Navellier Port ranking not working by "Fred Wright" fredwwright

Messages

Fri Apr 27, 2018 7:04 pm (PDT) . Posted by:

tarakayan

Is there a problem with yahoo site? when I open the spreadsheet this is the msg I get...
Shankar

Fri Apr 27, 2018 7:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

More details, please. Which URL (or spreadsheet) are you using?

On Fri, Apr 27, 2018 at 7:04 PM, tarakayan@
​....
wrote:

> Is there a problem with yahoo site? when I open the spreadsheet this is
> the msg I get...
>
>
>

Fri Apr 27, 2018 8:01 pm (PDT) . Posted by:

"Andrea Giuliani" ane13sk

Hi Randy,

It seems I had the same issue of the fellow who wrote this message when retrieving the smfGetYahooPortfolioView but just for a few minutes.
Then everything went back to normal.
Unsure whether the recently updated T&C of Yahoo affected, but hopefully was just a temporary blink in the service.


Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

________________________________
From: smf_addin@yahoogroups.com <smf_addin@yahoogroups.com> on behalf of Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>
Sent: Saturday, April 28, 2018 11:36:55 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Security Certificate has be revoked....



More details, please. Which URL (or spreadsheet) are you using?

On Fri, Apr 27, 2018 at 7:04 PM, tarakayan@
​....
wrote:

Is there a problem with yahoo site? when I open the spreadsheet this is the msg I get...



Fri Apr 27, 2018 8:24 pm (PDT) . Posted by:

thadqda

Same error here:
Public Function RCHGetURLData1


pURL=https://finance.yahoo.com/quote/AG/history?period1=315532800&period2=1524873600&interval=1d&filter=history&frequency=1d


oHTTP.responseText=""


Note: in vba, when I moved the code cursor back to the start of the function, it succeeded.


Sat Apr 28, 2018 11:42 am (PDT) . Posted by:

lawleesh

Hi Randy


Is there a way to extract "Australian Agricultural Company Ltd"
from http://www.4-traders.com/AUSTRALIAN-AGRICULTURAL-C-6492735/company/ http://www.4-traders.com/AUSTRALIAN-AGRICULTURAL-C-6492735/company/

thanks

Sat Apr 28, 2018 2:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try either:

=smfGetTagContent("
http://www.4-traders.com/AUSTRALIAN-AGRICULTURAL-C-6492735/company/
","a",-1,"class=""fvTitleInfo""")
=smfStrExtr(smfGetTagContent("
http://www.4-traders.com/AUSTRALIAN-AGRICULTURAL-C-6492735/company/","title"),"~","
company :")

But you practically need the name to create the URL, so wouldn't you
already have it?

On Sat, Apr 28, 2018 at 11:32 AM, lawrence.leesh@
​...
wrote:

> Is there a way to extract "Australian Agricultural Company Ltd"
>
> from http://www.4-traders.com/AUSTRALIAN-AGRICULTURAL-C-6492735/company/
>
>
>

Sat Apr 28, 2018 5:40 pm (PDT) . Posted by:

lawleesh

Thanks Randy.

The 4-traders symbols sometimes change and this is one way I could tell whether an old symbol that I used to use is still valid.


Sun Apr 29, 2018 10:30 am (PDT) . Posted by:

"Leo Bueno" leobueno

Figured it out thanks to message from other group member in response to the 30 year bond info.

One needs to use "ticker" and field number in the =smfGetYahooPortfolioView function.

So here it is:

=smfGetYahooPortfolioView("EURUSD=X", "15")

Thanks to Randy and y'all again.

=========
Leo Bueno
=========


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, April 23, 2018 3:58 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Euro/Dollar exchange rate from Yahoo



This

=RCHGetYahooQuotes($A33&B$29&"=X","l1")

used to work but no longer.

Please let me know call and parameters for Euros.

Thanks.


Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com<mailto:Leo@BuenoLaw.com>
Skype: BuenoLaw

[cid:image001.png@01D1E033.9E0A3CC0]



Sun Apr 29, 2018 10:37 am (PDT) . Posted by:

"Leo Bueno" leobueno

Thank you.

I did not realize I simply had to use the "ticker" and the field number in the =smfGetYahooPortfolioView function.

=========
Leo Bueno
=========


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, April 23, 2018 11:16 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo 30 year US Bond Yield [1 Attachment]


[Attachment(s) from Jose Jacob included below]
For the 10 Year Treasury I use

=smfGetYahooPortfolioView("^TNX", "15")/100

For 30 year Treasury, I think, the ticker is "^TYX"


Regards,
Jose L. Jacob

On Monday, April 23, 2018 4:35 PM, "Leo Bueno Leo@BuenoLaw.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


In the old days, this would work, but no more:

=RCHGetYahooQuotes("^TYX","l1")/100

Will appreciate y'all pointing me to the right function parameters.


Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com<mailto:Leo@BuenoLaw.com>
Skype: BuenoLaw

[cid:image001.png@01D1E033.9E0A3CC0]





Tue May 1, 2018 11:39 am (PDT) . Posted by:

bobc94595

Toteboard used to have a very useful spreadsheet to compare several companies fundamentals on one spreadsheet. Is there a similar spreadsheet in the files inventory on this site. I can't find one.


Tue May 1, 2018 12:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Toteboard still has workbooks on the website:

https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/Toteboard.net/

....but they are all over 8 years old, so I doubt they would work as-is.

On Tue, May 1, 2018 at 11:39 AM, conlonrc@
​...
wrote:

>
> Toteboard used to have a very useful spreadsheet to compare several
> companies fundamentals on one spreadsheet. Is there a similar spreadsheet
> in the files inventory on this site. I can't find one.
>
>
>

Tue May 1, 2018 12:13 pm (PDT) . Posted by:

bobc94595

they don't work, and deliver the message "
Navigation to the webpage was canceled" Do you know of any other such sheets for the comparison of two or more stocks?




Tue May 1, 2018 12:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't really do anything related to workbooks uploaded by members. I
usually do what I want from scratch, as I have custom things I look for.

On Tue, May 1, 2018 at 12:13 PM, conlonrc@
​...
wrote:

>
> they don't work, and deliver the message "
> Navigation to the webpage was canceled"
>
> Do you know of any other such sheets for the comparison of two or more
> stocks?
>
>
>

Thu May 3, 2018 6:10 pm (PDT) . Posted by:

"Fred Wright" fredwwright

I have been pulling the free navellier portfolio ranking for a while and it stopped working recently.
I don't think the URL has changed, but perhaps they changed the structure of the web page?
I am using - =RCHGetTableCell("https://www.navelliergrowth.investorplace.com/portfolio-grader/stock-report.html?q="&A3&"&submit=submit&type=site",0,"Total Grade:") (where A3 is a symbol)
This now returns Error.  
Any thoughts?
Fred
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.10

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)