Kamis, 09 Juni 2016

[smf_addin] Digest Number 3725[1 Attachment]

14 Messages

Digest #3725
2b
Re: Trying to download RCH zip file by "Randy Harmelink" rharmelink
2d
Re: Trying to download RCH zip file by "Randy Harmelink" rharmelink
3b

Messages

Wed Jun 8, 2016 6:51 am (PDT) . Posted by:

mark.boogaers

Hi,


I am using the Excel Addin on a daily basis to track my portfolios and are very happy with such a simple solution. I am now trying to track some virtual portfolios in different markets and having some difficulties getting data from Yahoo. In attached I am using RCHGetYahooQuotes array to retrieve data and mostly return N/A. If I type the ticker codes manually in Yahoo they work fine so they are the correct Yahoo tickers.


Any idea what could have caused these problems?


Thanks in advance.
Mark
Attachment(s) from
1 of 1 File(s)

Wed Jun 8, 2016 8:23 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Actually, most don't work fine in Yahoo. For example:

https://finance.yahoo.com/q?s=ALC.MC

Click on the "Download Data (delayed)" link towards the lower right. It
contains all "N/A" values, as you noted. That is the CSV file interface
that the RCHGetYahooQuotes() function uses.

You could click on the "Report an issue" link on the upper right and let
Yahoo know that the "Download Data (delayed)" link is giving you all "N/A"
values. They might fix the problem?

Otherwise, you'd need to use other add-in functions to extract prices, but
you had quite a number of them. I wouldn't suggest using the Yahoo Quotes
because you'd need to grab a web page for each ticker symbol. That can be
slow. I'd look for another source that would allow you to grab the data for
multiple tickers in one Internet access.

Hmmm. You could try their "Portfolio" quotes option. Try array-entering
this over a range:

=RCHGetHTMLTable("
https://finance.yahoo.com/quotes/ALC.MC,AZK.MC,DIA.MC,A3M.MC,AMS.MC,PRM.MC","Mkt
Cap")

On Wed, Jun 8, 2016 at 6:51 AM, mark.boogaers@
​...​
wrote:

> I am using the Excel Addin on a daily basis to track my portfolios and are
> very happy with such a simple solution. I am now trying to track some
> virtual portfolios in different markets and having some difficulties
> getting data from Yahoo. In attached I am using RCHGetYahooQuotes array to
> retrieve data and mostly return N/A. If I type the ticker codes manually in
> Yahoo they work fine so they are the correct Yahoo tickers.
>
> Any idea what could have caused these problems?
>
>

Wed Jun 8, 2016 8:26 am (PDT) . Posted by:

michal_emory

And I keep getting an error message saying the page isn't working. Any ideas of what is going on?


Thanks.

Wed Jun 8, 2016 8:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Probably a temporary issue with the hosting services. I just tried this
link from the web page and it worked fine for me:

http://ogres-crypt.com/SMF/RCH_Stock_Market_Functions-2.1.2016.04.19.zip

Unless you mean a different file somewhere?

On Wed, Jun 8, 2016 at 8:05 AM, michal_emory@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> And I keep getting an error message saying the page isn't working. Any
> ideas of what is going on?
>
>

Wed Jun 8, 2016 8:50 am (PDT) . Posted by:

michal_emory

That's the link I'm having issues with. I've tried it in Chrome and Explorer and I get the same error message saying the page isn't working.

Wed Jun 8, 2016 8:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you. Both the web page and the file download are
working fine for me in both Chrome and FireFox.

You could try going to the web page and hitting a Ctrl+F5 before clicking
on the link. That should clear the cache when refreshing the web page. I
don't know if that will help or not.

On Wed, Jun 8, 2016 at 8:36 AM, michal_emory@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> That's the link I'm having issues with. I've tried it in Chrome and
> Explorer and I get the same error message saying the page isn't working.
>

Wed Jun 8, 2016 9:27 am (PDT) . Posted by:

michal_emory

Ok thanks. It's strange that I'm having problems accessing it and you aren't. I'll continue messing with it.

Wed Jun 8, 2016 9:57 am (PDT) . Posted by:

sirons1962

Randy,


I received this from Zacks today. Can you add that back in?


We have heard your voice loud and clear. Thus, we are putting the Zacks Rank and Style Score ratings back on our quote pages and in the free portfolio tracker.

That's right. The Zacks Rank for stocks, mutual funds and ETFs are now available to you once again in these popular sections of Zacks.com.


Regards


Wed Jun 8, 2016 4:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. See:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30395

On Wed, Jun 8, 2016 at 9:57 AM, sirons1962@
​...​
wrote:

> I received this from Zacks today. Can you add that back in?
>
> We have heard your voice loud and clear. Thus, we are putting the Zacks
> Rank and Style Score ratings back on our quote pages and in the free
> portfolio tracker.
>
> That's right. The Zacks Rank for stocks, mutual funds and ETFs are now
> available to you once again in these popular sections of Zacks.com.
>
>

Wed Jun 8, 2016 4:47 pm (PDT) . Posted by:

rharmelink

I've updated Zacks element definitions on smf-element-4.txt for Zacks web page updates:
Added element numbers #844-#847 for Zacks stock styles Restored element #848 (Zacks Rank), which had been obsoleted
Fixed element #13873 (Zacks Recommendation) The associated Zacks template has also been updated for those changes.


See these website pages for updated files:


http://ogres-crypt.com/SMF/Elements/
http://ogres-crypt.com/SMF/Templates/ http://ogres-crypt.com/SMF/Templates/

Best practice is to exit EXCEL before updating files in the add-in folder on your computer.






Wed Jun 8, 2016 5:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Oops -- should be smf-element-6.txt, not the 4.

On Wed, Jun 8, 2016 at 4:47 PM, rharmelink@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I've updated Zacks element definitions on smf-element-4.txt for Zacks web
> page updates:
>
> - Added element numbers #844-#847 for Zacks stock styles
> - Restored element #848 (Zacks Rank), which had been obsoleted
> - Fixed element #13873 (Zacks Recommendation)
>
> The associated Zacks template has also been updated for those changes.
>
> See these website pages for updated files:
>
> http://ogres-crypt.com/SMF/Elements/
> http://ogres-crypt.com/SMF/Templates/
>
> Best practice is to exit EXCEL before updating files in the add-in folder
> on your computer.
>

Wed Jun 8, 2016 10:39 pm (PDT) . Posted by:

ane13sk

Hi Randy

since I am new here, first I want to say big thanks for the great work you have done through the years.

I recently joined and tried to bring some nice automation into my valuation spreadsheets....


I know nothing of programming, little of excel, but anyways I successfully connected Morningstar, Google, Zacks, Yahoo and in general, most of the things I needed.

Unfortunately, as a matter of fact, it seems now Google has reduced the number of FS available for download from 6 to 4, Morningstar from 10 to 5, Gurufocus keeps change the format but anyways not much available for poor people looking for freebies like me.

I have many problems connecting AdvFN, might be a regional issue I dont know, I am in Asia and the site redirects me, I know this, I tried to fix it but dont really know what is the issue keep blocking me, The spreadsheet talked about above seemed the only one working for me but I have the same issue of niavery (I tried also the ones you suggested, nothing shows up). I understand you would not update other people spreadsheets, but if you can try help us somehow with AdvFN stuff in the future, I guess many people will appreciate.that


Thanks again


Andrea

Wed Jun 8, 2016 11:55 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

GuruFocus in my main data source these days, but I subscribed. AdvFN was
really flaky for a few years, so I started avoiding it.

In any case, to access AdvFN in a region other than the US, three issues:

1. You'll probably need the cross-domains fix:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/10464.
That's actually a US issue as well.

2. If you are being redirected away from the "www" addresses of AdvFN, see:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/21069.
You'll need to put your redirection replacement of "www" in that file. You
should exit EXCEL before adding that file to the SMF add-in folder on your
machine.

3. If you are being redirected away from the "www" address, you'll also
probably need to specify both exchange and ticker symbol to access US
stocks. For example "NYSE:IBM" instead of just "IBM".

You should use these templates as reference:

http://ogres-crypt.com/SMF/Templates/#AdvFN

Most of those in the "Uploads by Forum Members" folder in the FILES area of
the Yahoo group were in response to some of that "flakiness" I mentioned.
All of that should be settled now.

I take that back. I just noticed a glitch on those AdvFN templates just now
when I tried annual. The last three periods on MMM weren't coming up 1993
to 1995. But I see it is a problem on the AdvFN website. If I use the
drop-down box on their website and select the 1993/12 period, that's NOT
what AdvFN is displaying. Sigh.

On Wed, Jun 8, 2016 at 8:34 PM, andrea.giuliani@live.it [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Unfortunately, as a matter of fact, it seems now Google has reduced the
> number of FS available for download from 6 to 4, Morningstar from 10 to 5,
> Gurufocus keeps change the format but anyways not much available for poor
> people looking for freebies like me.
>
> I have many problems connecting AdvFN, might be a regional issue I dont
> know, I am in Asia and the site redirects me, I know this, I tried to fix
> it but dont really know what is the issue keep blocking me, The spreadsheet
> talked about above seemed the only one working for me but I have the same
> issue of niavery (I tried also the ones you suggested, nothing shows up). I
> understand you would not update other people spreadsheets, but if you can
> try help us somehow with AdvFN stuff in the future, I guess many people
> will appreciate.that
>
>
>

Thu Jun 9, 2016 12:33 am (PDT) . Posted by:

ane13sk


Thanks again Randy, you solved it.
I actually already came across and fixed points 2 and 3, Even I read something about IE couldnt find the instructions and overlooked on point 1. Now that you provided it again, I was able to run the data dump,

Clearly not the best site but the most complete for free FS data as of now, I guess I will try to use morningstar and google for my more simple models and use it only if I need to dig more and crunch more numbers.

Gurufocus would be a good option, but as long as I cannot make 8k+ a year on my investments, pointless to pay 400$ for it,
Not to say I discovered your amazing tools right because I was searching an alternative to it.



For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar