Kamis, 09 April 2015

[smf_addin] Digest Number 3378

6 Messages

Digest #3378
1a
Getting IPO data by alonch77
1b
Re: Getting IPO data by "Randy Harmelink" rharmelink
2b
Re: smfGetTagContent - retension of old data by "Randy Harmelink" rharmelink
3b

Messages

Wed Apr 8, 2015 8:05 am (PDT) . Posted by:

alonch77

There is away to get the details from this page and also the data from each company?
like in this one: Tracon Pharmaceuticals - IPO Scoop http://www.iposcoop.com/index.php?option=com_content&task=view&id=4023&Itemid=191


Tracon Pharmaceuticals - IPO Scoop http://www.iposcoop.com/index.php?option=com_content&task=view&id=4023&Itemid=191 Covering the IPO market from A to Z. Stay in the loop with the IPO Scoop with John E. Fitzgibbon, Jr.



View on www.iposcoop.com http://www.iposcoop.com/index.php?option=com_content&task=view&id=4023&Itemid=191
Preview by Yahoo


2015 Pricings - IPO Scoop http://www.iposcoop.com/index.php?option=com_content&task=view&id=2299&Itemid=191



http://www.iposcoop.com/index.php?option=com_content&task=view&id=2299&Itemid=191

2015 Pricings - IPO Scoop http://www.iposcoop.com/index.php?option=com_content&task=view&id=2299&Itemid=191 Covering the IPO market from A to Z. Stay in the loop with the IPO Scoop with John E. Fitzgibbon, Jr.



View on www.iposcoop.com http://www.iposcoop.com/index.php?option=com_content&task=view&id=2299&Itemid=191
Preview by Yahoo




Wed Apr 8, 2015 11:44 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Individual company is easy -- try something like:

=RCHGetTableCell("
http://www.iposcoop.com/index.php?option=com_content&task=view&id=4023&Itemid=191",1,"Market
Cap:")

For the table, more difficult. You'd have to use something like:

=smfGetTagContent("
http://www.iposcoop.com/index.php?option=com_content&task=view&id=2299&Itemid=191","td",...item#...,">Offer
Price")

...where "...item#..." varies from 11 to 25 for the first company, 28 to 42
for the second company, and so forth. And you will need to do some parsing
of the table cell's content.

On Wed, Apr 8, 2015 at 8:05 AM, alonch77@... wrote:

>
> There is away to get the details from this page and also the data from
> each company?
>
> like in this one:
> http://www.iposcoop.com/index.php?option=com_content&task=view&id=4023&Itemid=191
>
>
> http://www.iposcoop.com/index.php?option=com_content&task=view&id=2299&Itemid=191
>

Wed Apr 8, 2015 4:05 pm (PDT) . Posted by:

stevet99uk

Am using =smfGetTagContent("http://www.shareprice.co.uk/"&B24,"span",5) in a cell to get a fund's daily value. B24 contains @GB:7:I3PE or similar
unfortunately the SMFAddIn routines save downloaded data for reuse, thus it is just repeating the old retrieval and not updating to the new price
I can get around this by closing and reopening excel, but I was wondering if there was a call/option to clear the data after extracting the required values.
Many thanks
steve

Wed Apr 8, 2015 4:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to run the smfForceRecalculation macro to flush out the web pages
the add-in is extracting data from and to get a fresh copy of the web
pages. See the "Tips and FAQs" web page for more details.

On Wed, Apr 8, 2015 at 4:05 PM, stevethompson486@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Am using =smfGetTagContent("http://www.shareprice.co.uk/"&B24,"span",5)
> in a cell to get a fund's daily value. B24 contains @GB:7:I3PE or similar
>
> unfortunately the SMFAddIn routines save downloaded data for reuse, thus
> it is just repeating the old retrieval and not updating to the new price
>
> I can get around this by closing and reopening excel, but I was wondering
> if there was a call/option to clear the data after extracting the required
> values.
>
> Many thanks
>
>

Wed Apr 8, 2015 11:13 pm (PDT) . Posted by:

presentsigi

Hi Randy,


I was trying this formula:


Range("G1:G407") = RCHGetElementNumber(Range("A1:A407") ,1285)


Intended for earnings date of a matrix range (app 3000 tickers)


But it gives a VBA error... Object doesn't match.


Can you assist in how I use the formula correctly for this approach?


Thanks.


Sigi

Wed Apr 8, 2015 11:26 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Nope, won't work that way. Just one ticker per function invocation.
Besides, the add-in won't allow you to access more than 1000 web pages in a
session anyway. Those are the types of mass data requests I'd rather people
not do. It can make the free services look to methods to prevent something
like the add-in from accessing the data -- not hard to do.

What I would suggest is using the Zacks screener tool. It will allow you to
export a file with that data on it for their entire set of tickers. Then
use VLOOKUP() on that exported file. Just use a criteria of "Next EPS
Report Date" > 0 and edit the view to include that field. It exports nearly
6000 stocks. It's something you'd only need to do once or twice a quarter.

On Wed, Apr 8, 2015 at 11:13 PM, presentsigi@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I was trying this formula:
>
> Range("G1:G407") = RCHGetElementNumber(Range("A1:A407") ,1285)
>
> Intended for earnings date of a matrix range (app 3000 tickers)
>
> But it gives a VBA error... Object doesn't match.
>
> Can you assist in how I use the formula correctly for this approach?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.39

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)