Kamis, 19 April 2018

[smf_addin] Digest Number 4324

15 Messages

Digest #4324
2b
3b
Re: Getting data from gurufocus by "Randy Harmelink" rharmelink
4a
Re: Yahoo Earnings Growth by thealphainvestor
4b
Re: Yahoo Earnings Growth by "Randy Harmelink" rharmelink
5b
Re: no longer can extract from wsj by "Randy Harmelink" rharmelink

Messages

Sun Apr 15, 2018 4:55 pm (PDT) . Posted by:

beatnut8827

Oh, so that solved it. Is there any documentation for the Portfolio View Neil

Sun Apr 15, 2018 5:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Both documentation and template are on the web site. The template contains
a list of all the available fields.

On Sun, Apr 15, 2018 at 4:55 PM, neil@
​...
wrote:

>
> Oh, so that solved it. Is there any documentation for the Portfolio View
>
>

Sun Apr 15, 2018 7:15 pm (PDT) . Posted by:

sjagers

Hey Randy.... I hope all is well with you. I have a dumb question about changing the location of the add-in on my PC. When I first started using your add-in, several years and hundreds of files ago, I installed it in my Documents folder. I'm reinstalling Windows and I thought I would install your add-in in the C;\ root directory as you suggested. Is there an easy way to do this, or will the old location be hard coded in all of my worksheets?
Thanks.


Sun Apr 15, 2018 9:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The old location will still be hard-coded in all of your saved workbooks. I
just have the smfFixLinks macro on a toolbar button so it's easily
available. It's also an option on the context menu (via a right-mouse
click). Once you save the workbook with the fixed links, it will have the
new location hard-coded, so you should only need to do it once per workbook
that you fix and save.

On Sun, Apr 15, 2018 at 7:15 PM, sjagers@
​...
wrote:

>
> Hey Randy.... I hope all is well with you. I have a dumb question about
> changing the location of the add-in on my PC. When I first started using
> your add-in, several years and hundreds of files ago, I installed it in my
> Documents folder. I'm reinstalling Windows and I thought I would install
> your add-in in the C;\ root directory as you suggested. Is there an easy
> way to do this, or will the old location be hard coded in all of my
> worksheets?
>

Mon Apr 16, 2018 2:51 pm (PDT) . Posted by:

sjagers

Thanks for the reply and thanks for all the work you put into the add-in. Have a great week.

Mon Apr 16, 2018 1:48 am (PDT) . Posted by:

lawrence.leesh

When I performed those keyboard entries a web query box popped up and I navigated to gurufocus.com and logged in. After that I had to import or cancel. I chose import and the page went into the spreadsheet. After that I tried the formula again and it still says Premium Members Only...I did a GURUF refresh and it is the same thing.

Am I doing it correctly?


thanks




Mon Apr 16, 2018 1:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Once you've logged in, you can just cancel out. The security cookie will
have been created.

Did you do an smfForceRecalculation? Without doing that, the "new" formula
will just extract data off of the same saved copy of the web page. The
add-in saves copies of web pages before extracting data from them. The
smfForceRecalculation macro purges all of the saved copies of web pages,
forcing a new one to be retrieved from the Internet.

​You can always go back into the EXCEL IE object and check your
login/membership status​ via this web page:

https://www.gurufocus.com/membership/

On Mon, Apr 16, 2018 at 1:48 AM, lawrence.leesh@
​...
wrote:

>
> When I performed those keyboard entries a web query box popped up and I
> navigated to gurufocus.com and logged in. After that I had to import or
> cancel. I chose import and the page went into the spreadsheet. After that I
> tried the formula again and it still says Premium Members Only...I did a
> GURUF refresh and it is the same thing.
>
> Am I doing it correctly?
>
>
>

Mon Apr 16, 2018 2:25 am (PDT) . Posted by:

lawrence.leesh

Thanks Randy. Everything is working now.

Wed Apr 18, 2018 2:18 pm (PDT) . Posted by:

thealphainvestor

Randy,

Any ETA on a fix for this issue, or is Yahoo not going to allow us to access those particular data items any more.


Thanks,


Bruce

Wed Apr 18, 2018 5:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I had some time available this afternoon, so (hopefully) took care of it:

https://smf-add-in.blogspot.com/2018/04/alert-updates-to-yahoo-analyst-element.html

On Wed, Apr 18, 2018 at 2:18 PM, the.alpha.investor@
​....
wrote:

>
> Any ETA on a fix for this issue, or is Yahoo not going to allow us to
> access those particular data items any more.
>
>

Wed Apr 18, 2018 8:12 pm (PDT) . Posted by:

sri.yanto

haii randy.


i have an issue with wsj website.


2 days ago i found myself, can not any longer extract any data from wsj.com


is there any problem with the website or there is any changes with wsj randy?


here the link :


https://quotes.wsj.com/ID/XIDX/SMDR/financials/annual/income-statement https://quotes.wsj.com/ID/XIDX/SMDR/financials/annual/income-statement



here im using smf :


RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/SMDR/financials/Quarter/Income-Statement",5,"Net Income After Extraordinaries<")

its return "error&#39;

many thanks randy

Wed Apr 18, 2018 8:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

They've just changed from "http://" to "https://". Change your URLs and
they should work OK. It did for the example you gave. I don't think they've
changed the content of the web pages.

That's happened so often on websites in the last year or two, it's the
first thing I check now.

On Wed, Apr 18, 2018 at 8:12 PM, sri.yanto@
​...
wrote:

> i have an issue with wsj website.
>
> 2 days ago i found myself, can not any longer extract any data from
> wsj.com
>
> is there any problem with the website or there is any changes with wsj
> randy?
>
> here the link :
>
> https://quotes.wsj.com/ID/XIDX/SMDR/financials/annual/income-statement
>
> here im using smf :
> RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/SMDR/
> financials/Quarter/Income-Statement",5,"Net Income After
> Extraordinaries<")
>
> its return "error&#39;
>
> many thanks randy
>
>
>

Thu Apr 19, 2018 1:17 am (PDT) . Posted by:

ethanbond911

Hello:
I have an excel data sheet, every time I type numbers in 1,000 excel automatically inserts a decimal in the middle so it looks like 10.00. I have tried everything to get rid of it and so far nothing has worked. So I turn to you fine folks for help. Any suggestions? Thanks in advance.
Regards
Ethan

Thu Apr 19, 2018 4:27 pm (PDT) . Posted by:

jterrenceho

Randy,


SmfPricesByDates works on one computer but not on another. I remember reading on this before, but I couldn't find the thread. I remember you saying that it has something to do with security settings.


I tried recalculate and I also tried clearing my browser.



Thanks for your help.


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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)