Sabtu, 21 Februari 2015

[smf_addin] Digest Number 3332[1 Attachment]

5 Messages

Digest #3332

Messages

Fri Feb 20, 2015 3:29 am (PST) . Posted by:

cgrauballe

Hey all


I created a stock analysis sheet. I don't know if it useful to you guys. But feel free to use it! - Just hint me with good investments ;) (and also please don't distribute)


I also gladly receive comments which could improve it (for example conditional formatting specific cells which meets targets, that way a good stock could be pointed out)


The username is: cgrauballe, code is: cgrauballe
The excel sheets takes a little time to open in the beginning and it hasn't been "bullet-proof" checked yet.
A lot of the objects is closed by simply pressing it.


and finally, THX to Randy for making it possible


/Caspar
Attachment(s) from
1 of 1 File(s)

Fri Feb 20, 2015 3:56 am (PST) . Posted by:

cgrauballe


Hey all


Does any of you know how to retrieve the table, with table id:"Rf1", from the following webpage?
Bill Gates | Bill & Melinda Gates Foundation Trust Portfolio - 2015 Stock Picks and Performances http://www.gurufocus.com/StockBuy.php?GuruName=Bill+Gates


Bill Gates | Bill & Melinda Gates Foundation Trust Portfolio - 2015 Stock Picks and Performances http://www.gurufocus.com/StockBuy.php?GuruName=Bill+Gates Bill Gates's Profile: Bill Gates is one of the smartest businessmen in the world. He founded Microsoft and grew it to the world's largest software maker and monopolized the PC world.



View on www.gurufocus.com http://www.gurufocus.com/StockBuy.php?GuruName=Bill+Gates
Preview by Yahoo




Best regards Caspar

Fri Feb 20, 2015 6:26 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try this:

=RCHGetHTMLTable("
http://www.gurufocus.com/StockBuy.php?GuruName=Bill+Gates&n=200
","id=""Rf1""",-1,"",1)

Note that I changed the URL so that the first 200 items are listed instead
of just the first 20.

On Fri, Feb 20, 2015 at 4:56 AM, cgrauballe@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

Does any of you know how to retrieve the table, with table id:"Rf1", from
the following webpage?

Bill Gates | Bill & Melinda Gates Foundation Trust Portfolio - 2015 Stock
Picks and Performances
<http://www.gurufocus.com/StockBuy.php?GuruName=Bill+Gates>

Fri Feb 20, 2015 6:14 am (PST) . Posted by:

"Randy Harmelink" rharmelink

My membership doesn't allow access to the foreign stock data, so I can't be
of any assistance. I have nothing to look at for those non-US ticker
symbols.

On Fri, Feb 20, 2015 at 2:48 AM, soemoe.theinwin@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Hi - opened my spreadsheet this morning and the above formula is returning
> an error for many stocks now..in fact the same stocks will no longer gather
> information from the GF site now.
>
> Some examples: AAPL, WYNN, GE are OK, MIL:BMW, LSE:VOD, is not. It
> actually seems, after some investigation that only US stocks are working.
>
> I've reinstalled the plugin and still the same ones aren't returning any
> information and I'm logged into the sites with my premium membership..
>
> Any adjustments/obvious errors I'm making?
>
> For what its worth, I previously used excel via a virtual machine on
> parallels for Mac (where everything worked fine) and yesterday installed a
> new VM - still odd that only US listed stocks seem to work.
>

Sat Feb 21, 2015 12:31 am (PST) . Posted by:

tysongayada

hi randy,



is there any method to extract data from http://quotes.wsj.com/GOOGL http://quotes.wsj.com/GOOGL


for


1) Key Stock Data


2) Latest News


3) Research and Ratings





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

Tidak ada komentar:

Posting Komentar