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
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-
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>
=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.
>
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/
>
> 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
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