Selasa, 03 Maret 2015

[smf_addin] Digest Number 3343

6 Messages

Digest #3343
1a
Re: Finviz Heatmaps by bushpilote
1b
Re: Finviz Heatmaps by "Randy Harmelink" rharmelink
2a
4a
RCHGetTableCell() Troubleshooting by "Ron Spruell" hashky
4b
Re: RCHGetTableCell() Troubleshooting by "Randy Harmelink" rharmelink

Messages

Mon Mar 2, 2015 3:39 am (PST) . Posted by:

bushpilote

Hi Randy, the "final" function above has stopped working since Finviz redesigned their heatmap page. Any suggestions on how I can capture this http://www.finviz.com/map.ashx?t=sec&st=ytd http://www.finviz.com/map.ashx?t=sec&st=ytd with RCHCreateComment?
Thanks

Mon Mar 2, 2015 7:04 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't see a way. They now generate it on-the-fly using JavaScript. The
"base" image is just a white background.

On Mon, Mar 2, 2015 at 4:39 AM, bushpilote@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> the "final" function above has stopped working since Finviz redesigned
> their heatmap page. Any suggestions on how I can capture this
> http://www.finviz.com/map.ashx?t=sec&st=ytd with RCHCreateComment?
>

Mon Mar 2, 2015 8:42 am (PST) . Posted by:

rus101

Works great, thanks Randy!

Mon Mar 2, 2015 2:49 pm (PST) . Posted by:

nicolasanchoa

Thanks Randy for your reply.
Got to make a macro then.

Mon Mar 2, 2015 5:21 pm (PST) . Posted by:

"Ron Spruell" hashky

Randy -
I use the following to pull the percent of bonds that are issued by the state of Illinois. 

=IF(RCHGetTableCell("http://www.cefconnect.com/Details/Summary.aspx?ticker="&$B60,1,"State Allocation","Illinois")="Error",0,RCHGetTableCell("http://www.cefconnect.com/Details/Summary.aspx?ticker="&$B60,1,"State Allocation","Illinois&quot;))
B60 contains the Ticker.  In this case the Ticker is BIE.  Another is MEN.
BIE pulls 221000.00%MEN pulls 1293000.00%
These numbers should be 0.00%.  The other 90 Tickers get the correct answer, which in some cases is 0.00%, when Illinois is not listed..
Am I doing something wrong?  Or is this just mirrors and magic of the Internet?  Would there be a better way to pull this information?
Ron

Mon Mar 2, 2015 6:02 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The others may end up with 0% because there is no "Illinois" string on the
web pages. However, BIE has a top holding of:

Illinois St Toll Hwy Auth 5.5% 5.50 01 Jan 2033

...and MEN has a top holding of:

Illinois Sports Facilities Authority, Rb 5.00 15 May 2028

...so in both cases, it *is* finding the "Illinois" search string and then
giving you the next table cell. In both of these cases, that is the amount
held in each of those entities.

You could try a search string of ">Illinois<" instead?

On Mon, Mar 2, 2015 at 6:21 PM, Ron Spruell hashky@... wrote:

>
> I use the following to pull the percent of bonds that are issued by the
> state of Illinois.
>
> =IF(RCHGetTableCell("
> http://www.cefconnect.com/Details/Summary.aspx?ticker="&$B60,1,"State
> Allocation","Illinois")="Error",0,RCHGetTableCell("
> http://www.cefconnect.com/Details/Summary.aspx?ticker="&$B60,1,"State
> Allocation","Illinois&quot;))
>
> B60 contains the Ticker. In this case the Ticker is BIE. Another is MEN.
> BIE pulls 221000.00%
> MEN pulls 1293000.00%
>
> These numbers should be 0.00%. The other 90 Tickers get the correct
> answer, which in some cases is 0.00%, when Illinois is not listed..
>
> Am I doing something wrong? Or is this just mirrors and magic of the
> Internet? Would there be a better way to pull this information?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar