Does anyone know of a similar set of software tools (Excel-based or other) that issues the proper request parameters and then parses HTML produced by a stock...
1492
Randy Harmelink
rharmelink
Apr 2, 2007 5:05 am
Not quite sure what you're asking? I have been able to retrieve screener results from Reuters and Telescan. I'm not sure if you can from Java-based ones like...
1493
tetoinf
Apr 2, 2007 8:22 am
Hi Randy & Friends, I see you have insert new coordinate on advfn. on the bottom I see the Z-score. I have already done my Z-score but without success, exactly...
1494
Randy Harmelink
rharmelink
Apr 2, 2007 8:48 am
... Not sure what you mean by that... ... In the VBA code, it's done like this: Case "Calculated -- Altman Z-Score" n1 = RCHGetElementNumber(pTicker, 10786) '...
1495
Mark Simms
msimmsx
Apr 2, 2007 4:59 pm
One more time: just as the SMF add-in provides the tools to both issue a request for selected data as well as to be able to retrieve the results, is there a...
1496
Randy Harmelink
rharmelink
Apr 2, 2007 5:49 pm
Well, like you say, the MSN Deluxe Screener is Java-based. I don't know of a way to grab the data out of the embedded application, since they don't provide an...
1497
Mark Simms
msimmsx
Apr 2, 2007 7:47 pm
Well, I doubt the functionality is java-based....below is the HTML from the website. Some of the functions are initiated from a javascript library, but the key...
1498
Randy Harmelink
rharmelink
Apr 2, 2007 9:32 pm
I can use VBA to interact with the ActiveX object, but no luck getting actual data out of it....
1499
Panos Boufardeas
blaxaki
Apr 2, 2007 9:33 pm
I have set up with DynDNS.com one web site with Apache HTTP Server in my home PC What I would like to do (for my personal use) is to make a web stream so I...
1500
Randy Harmelink
rharmelink
Apr 2, 2007 9:41 pm
The add-in won't put it onto the web page for you, but you could certainly program it yourself. There are tools out there to do it. I haven't done it myself,...
1501
Mark Bray
mj_bray
Apr 2, 2007 10:10 pm
Randy or anyone who can answer the question, With element items like Free Cash Flow Growth (Element numbers 14355-14365) there are values for multple years-in...
1502
Randy Harmelink
rharmelink
Apr 2, 2007 10:27 pm
"Year 1" should be the most recent fiscal year that the web page is reporting. If you want more recent data, you would need to compute the TTM (Trailing...
1503
Mark Bray
mj_bray
Apr 2, 2007 10:40 pm
Thank you Randy. ... From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink Sent: Monday, April 02, 2007 3:27 PM To:...
1504
Mark Simms
msimmsx
Apr 3, 2007 1:31 am
Thanks for checking it out. I'll look into it further as well. There are other DLL components in this ....it's pretty involved. The component that provides the...
1505
K
kchaconas
Apr 3, 2007 8:14 pm
Hi Randy, et al! I'm finally getting around to incorporating your functions into my spreadsheet and am getting "something wrong with dates" and #Value! error...
1506
Randy Harmelink
rharmelink
Apr 3, 2007 9:37 pm
... You're getting the error message because you have the dates reversed. The 2nd, 3rd, and 4th parameters are for the starting date, not the ending date. This...
1507
K
kchaconas
Apr 3, 2007 11:38 pm
... Oh good grief! Sorry! I actually had thought that but then when I read "defaults to most recent date available" (see below) I reconsidered, thinking it...
1508
Randy Harmelink
rharmelink
Apr 4, 2007 12:12 am
... Oops. Sorry. I just recently rewrote those, copied and pasted the date descriptions, then modified the "default" wording on the wrong set. Fixing it...
1509
K
kchaconas
Apr 4, 2007 1:00 am
... "http://bigcharts.marketwatch.com/historical/ Yup, one day at a time! So my routine gets the last weekday of the month and if it's not a trading day,...
1510
Vick
vivekkapil
Apr 4, 2007 2:17 am
Group, Has anyone developed or come across Excel to IIF (Intuit Interchange Format) converter? I am trying to read in Excel Bank (financial) statement into my...
1511
Randy Harmelink
rharmelink
Apr 4, 2007 2:22 am
... This formula would pick up the closing price: =RCHGetTableCell(" ...
1512
Richard Power
rpower0714
Apr 5, 2007 12:53 pm
Can someone tell me the element numbers for Name and last price for the following? Thanks in advance. DIA SPY QQQQ IWM IWO If there is no element number, then...
1513
Randy Harmelink
rharmelink
Apr 5, 2007 3:32 pm
For last price, I think you'd be better off using the RCHGetYahooQuotes() function instead of the RCHGetElementNumber() function. You could array-enter this...
1514
dfaris1
Apr 7, 2007 2:23 am
Has anyone figured ou a way to get data from Ivolatility.com option calculator? I'm trying to figure out how the get the volatility % for a given options...
1515
Randy Harmelink
rharmelink
Apr 7, 2007 2:29 am
There is an example of data extraction in the files area, under the "Requested Samples" folder. If you search the message archives for "ivolatility", you...
1516
Randy Harmelink
rharmelink
Apr 7, 2007 2:47 am
Oops, sorry. I missed that this request was for the calculator...I didn't realize there was a difference....
1517
Randy Harmelink
rharmelink
Apr 7, 2007 2:58 am
How about a different web site? http://www.schaeffersresearch.com/streetools/options/greeks.aspx?ticker_symbol=IBM...
1518
dfaris1
Apr 7, 2007 5:37 am
... ticker_symbol=IBM ... option ... for a ... data ... Hey Randy thats a pretty good site. I guess that would work. The volatility on that site could do it...
1519
Randy Harmelink
rharmelink
Apr 7, 2007 5:58 am
Well, my problem is that I don't deal with options, so I have little idea of what you're trying to pick up off the page and how you intend to use it. For...
1520
dfaris1
Apr 7, 2007 4:11 pm
Thanks Randy, I'll try the Schaeffer site. I'm new to useing this plugin an I'm still trying to figure out what I should for this type of task. I will play...
