Senin, 11 Januari 2016

[smf_addin] Digest Number 3605[1 Attachment]

8 Messages

Digest #3605

Messages

Sun Jan 10, 2016 8:06 am (PST) . Posted by:

"Gordon Pedersen"

That URL was exactly the kind of thing I was going to ask for next.

Using it forced me to go through IBD full registration process.
Establishing a valid login on their site does not, in my experience so far,
suffice to give one access to the data we need.

The images attached here strongly suggests that one must fully register at
IBD, which included handing over credit card information, not just
establish a valid login and password, in order to access certain parts of
their site. (Sorry attachment is almost 2MB; please tell me if that causes
problems here.)

I wanted to avoid giving them postal address and credit card info, or prove
it was unavoidable. It's a pity, from my point of view, that so much info
formerly available from MSN appears to have disappeared.

I'm willing to pay something for reliable information, and I don't need all
the data points, but since I don't want all the other doodads and
"features" most sites provide, my price point is usually far less than they
think they are worth. ;-)

Of all people, folks here might know: does someone sell decent stock and
bond information, with some history, at a reasonable price? And can SMF
handle such data?

Randy: Thanks for helping me find my way through this and ascertain
exactly what IBD's pound of flesh seems to be! As you can see, the IBD
formulas now populate. I hope they keep working after I refuse charges for
whatever IBD intends to sell me!

I can now start to take advantage of the great power of SMF to help me
analyze (mostly dividend but some growth) stocks.

Gordon

On Sat, Jan 9, 2016 at 11:08 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> I'm at a loss...
>
> Hmmm. When you log in with your browser, do you see the normal stock
> checkup page when you use the URL?
>
> http://research.investors.com/stock-checkup/xxxx-JNJ.aspx
>
> On Sat, Jan 9, 2016 at 10:14 PM, Gordon Pedersen gordon@...wrote:
>
>>
>> Thanks again. This is my last hurrah for tonight. :-)
>>
>> My intuition (has somw basis, I've administered Unix machines as an
>> amateur) is that the Win firewall is not causing grief--unless SMF uses
>> oddball ports. The Win 7 firewall I set up quite vanilla and it has never
>> given problems in 2 years.
>>
>> I assume that I'm doing something wrong, or I'm not doing something I
>> should. I bet it has to do with Excel, but it could have to do with IBD or
>> my login there, even though I have logged in multiple times apparently
>> successfully.
>>
>> Attached file shows a progression of steps taken with the new worksheet.
>>
>> Gordon
>>
>>
>
>

--
Gordon Pedersen
Attachment(s) from Gordon Pedersen
1 of 1 File(s)

Sun Jan 10, 2016 12:04 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You signed up for the 4-week free trial. After that, they'll charge you for
whatever you signed up for. Unless you cancel first.

I pay $199 per year for access to their data, plus $16.95 per month for
access to their e-Tables.

On Sun, Jan 10, 2016 at 9:06 AM, Gordon Pedersen gordon@...wrote:

>
> That URL was exactly the kind of thing I was going to ask for next.
>
> Using it forced me to go through IBD full registration process.
> Establishing a valid login on their site does not, in my experience so far,
> suffice to give one access to the data we need.
>
> The images attached here strongly suggests that one must fully register at
> IBD, which included handing over credit card information, not just
> establish a valid login and password, in order to access certain parts of
> their site. (Sorry attachment is almost 2MB; please tell me if that causes
> problems here.)
>
>
> I wanted to avoid giving them postal address and credit card info, or
> prove it was unavoidable. It's a pity, from my point of view, that so
> much info formerly available from MSN appears to have disappeared.
>
>
> I'm willing to pay something for reliable information, and I don't need
> all the data points, but since I don't want all the other doodads and
> "features"; most sites provide, my price point is usually far less than they
> think they are worth. ;-)
>
>
> Of all people, folks here might know: does someone sell decent stock and
> bond information, with some history, at a reasonable price? And can SMF
> handle such data?
>
> Randy: Thanks for helping me find my way through this and ascertain
> exactly what IBD's pound of flesh seems to be! As you can see, the IBD
> formulas now populate. I hope they keep working after I refuse charges for
> whatever IBD intends to sell me!
>
> I can now start to take advantage of the great power of SMF to help me
> analyze (mostly dividend but some growth) stocks.
>

Sun Jan 10, 2016 1:01 pm (PST) . Posted by:

"Gordon Pedersen"

Thanks for the costs.

On Sun, Jan 10, 2016 at 12:04 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> You signed up for the 4-week free trial. After that, they'll charge you
> for whatever you signed up for. Unless you cancel first.
>
> I pay $199 per year for access to their data, plus $16.95 per month for
> access to their e-Tables.
>
> On Sun, Jan 10, 2016 at 9:06 AM, Gordon Pedersen gordon@...wrote:
>
>>
>> That URL was exactly the kind of thing I was going to ask for next.
>>
>> Using it forced me to go through IBD full registration process.
>> Establishing a valid login on their site does not, in my experience so far,
>> suffice to give one access to the data we need.
>>
>> The images attached here strongly suggests that one must fully register
>> at IBD, which included handing over credit card information, not just
>> establish a valid login and password, in order to access certain parts of
>> their site. (Sorry attachment is almost 2MB; please tell me if that causes
>> problems here.)
>>
>>
>> I wanted to avoid giving them postal address and credit card info, or
>> prove it was unavoidable. It's a pity, from my point of view, that so
>> much info formerly available from MSN appears to have disappeared.
>>
>>
>> I'm willing to pay something for reliable information, and I don't need
>> all the data points, but since I don't want all the other doodads and
>> "features"; most sites provide, my price point is usually far less than they
>> think they are worth. ;-)
>>
>>
>> Of all people, folks here might know: does someone sell decent stock and
>> bond information, with some history, at a reasonable price? And can SMF
>> handle such data?
>>
>> Randy: Thanks for helping me find my way through this and ascertain
>> exactly what IBD's pound of flesh seems to be! As you can see, the IBD
>> formulas now populate. I hope they keep working after I refuse charges for
>> whatever IBD intends to sell me!
>>
>> I can now start to take advantage of the great power of SMF to help me
>> analyze (mostly dividend but some growth) stocks.
>>
>
>
>

--
Gordon Pedersen

Sun Jan 10, 2016 8:58 am (PST) . Posted by:

"Brad Reel" reeldeal9090

Thanks, Randy. I actually played around with it last night, and it turns
out the URL I had been using in the past is working again. Who knows why.
Based on that, I do know the URL, so the info you provided will work
great. Thanks again for all the help!

On Sat, Jan 9, 2016 at 8:18 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Coincidentally, I'm just starting to look at downloading a few files using
> VBA. I didn't like the method that you're using, because it reads it into
> VBA and then writes it. I want to download it directly. I'll have to,
> because some of my files are VERY large.
>
> I tried the technique described on these two web pages, which uses a
> Windows API for downloading::
>
>
> https://social.msdn.microsoft.com/Forums/en-US/beb6fa0e-fbc8-49df-9f2e-30f85d941fad/download-file-from-ie-with-vba
> http://officetricks.com/download-file-from-website-using-excel/
>
> In its simplest version, this test worked fine for me:
>
> Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA"
> _
> (ByVal pCaller As Long, _
> ByVal szURL As String, _
> ByVal szFileName As String, _
> ByVal dwReserved As Long, _
> ByVal lpfnCB As Long) As Long
>
> Sub Sample_Download()
> Const sURL = "
> http://www.dripinvesting.org/Tools/U.S.DividendChampions.xls"
> Const sFile = "C:\Users\Randy\Documents\Temp\U.S.DividendChampions.xls"
> MsgBox (URLDownloadToFile(0, sURL, sFile, 0, 0))
> End Sub
>
> But I knew the URL of the EXCEL file. I don't know if you can use the URL
> you know or not. To see if anything else is going on, you could use some
> type of URL sniffer. I use the HTTPFox extension with FireFox. Or, if using
> FireFox, you can go to your download dropdown and copy the URL if the
> downloaded file? I've done that a time or two.
>
>
> On Sat, Jan 9, 2016 at 6:15 PM, brad.reel@... wrote:
>
>> Hi Randy. Long time, no talk and Happy New Year. Hope 2016 treats you
>> well.
>>
>> Have a problem I am hoping you might be able to help me with. I had some
>> VBA code written that would pull down from the investor's.com site the
>> various IBD screens in excel format. Sometime back, this code quit working
>> when IBD did one of their code re-writes. I've managed to cobble something
>> together that works, but it's pretty ugly. Hoping you might know a better
>> way.
>>
>> This piece of code use to work, I could send this URL as part of an HTTP
>> get and it would pull down the screen in Excel format:
>>
>> 'myURL(1) = "
>> http://research.investors.com/screencenter/export.aspx?ScreenID=" &
>> IBD50Code & "&Type=1&exportType=excel"
>>
>> The IBD50Code is a variable because IBD used to rotate the codes on the
>> URL daily. I don't think they rotate them anymore, but I haven't really
>> been paying attention of late.
>>
>> Once that URL stopped working, I was able to make this work:
>> 'myURL(1) = "http://research.investors.com/screen-center/?screen=" &
>> IBD50Code & ""
>>
>> This will pull down the webpage as an excel file, which I can then open
>> and pull the symbols out of. It works, but it's a mess because while
>> running it throws all kinds of errors because I'm opening a web page with
>> an Excel extension.
>>
>> Here's the code I run to execute the URL's. I believe it's fairly
>> standard, but maybe there's a problem in there.
>>
>> j = 1
>> For Each i In myURL
>> WinHttpReq.Open "GET", i, False
>> WinHttpReq.Send
>>
>> Path = Directory + Filename(j)
>>
>> i = WinHttpReq.ResponseBody
>> If WinHttpReq.Status = 200 Then
>> Set oStream = CreateObject("ADODB.Stream")
>> oStream.Open
>> oStream.Type = 1
>> oStream.Write WinHttpReq.ResponseBody
>> oStream.SaveToFile (Path)
>> oStream.Close
>> End If
>> j = j + 1
>>
>> Next
>>
>> I have dug through the web pages trying to figure out a URL I could call,
>> but I'm not having any luck. Part of the problem is that I know just
>> enough HTML programming to be dangerous. :)
>>
>> If you have any ideas on what I VBA code I could execute to be able to
>> download the actual excel files for the IBD screens I would be most
>> appreciative. If you don't want to mess with it, I understand that also,
>> but figured it didn't hurt to ask.
>>
>>
>
>

Sun Jan 10, 2016 8:07 pm (PST) . Posted by:

bobc94595

Currently, I am pulling PE data from this web site:http://www.reuters.com/finance/stocks/overview?symbol=XOM.N

I am using: RCHGetTableCell("http://www.reuters.com/finance/stocks/financialHighlights?symbol="&Ticker,1,"Valuation Ratios","P/E Ratio (",,,0)

How can I pull the Closing price from that page?


Sun Jan 10, 2016 10:23 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

If you have the latest version of the add-in, try:

=smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=XOM.N
","span",2,"id=""headerQuoteContainer""",,,,1)

...otherwise, try:

=smfConvertData(smfGetTagContent("
http://www.reuters.com/finance/stocks/overview?symbol=XOM.N
","span",2,"id=""headerQuoteContainer"""))

The "pConv" parameter of smfGetTagContent() runs the smfConvertData()
function automatically in the versions of the add-in after 2014-04-10.

On Sun, Jan 10, 2016 at 9:07 PM, conlonrc@... wrote:

>
> Currently, I am pulling PE data from this web site:
> http://www.reuters.com/finance/stocks/overview?symbol=XOM.N
>
> I am using: RCHGetTableCell("
> http://www.reuters.com/finance/stocks/financialHighlights?symbol="&Ticker,1,"Valuation
> Ratios","P/E Ratio (",,,0)
>
> How can I pull the Closing price from that page?
>

Sun Jan 10, 2016 8:30 pm (PST) . Posted by:

jimw1705

Thanks for this. Yes, a positive value would not have the parenthesis. Skipping 39 cells works most of the time, but not always. I'm not sure what the web page structure format is.

Sun Jan 10, 2016 9:48 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

One possibility for % change and $ change:

=smfConvertData(smfWord(TRIM(smfStrExtr(smfGetTagContent("
http://www.ftportfolios.com/retail/dp/dpprice.aspx?fundid=10277","td",1,"NAV
Change:"),">","~")),1," "))

=smfConvertData(smfWord(TRIM(smfStrExtr(smfGetTagContent("
http://www.ftportfolios.com/retail/dp/dpprice.aspx?fundid=10277","td",1,"NAV
Change:"),">","~")),2," "))

The "NAV Change:" label is the quickest way to get the the required data...

On Sun, Jan 10, 2016 at 9:30 PM, jimw@premier1.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks for this. Yes, a positive value would not have the parenthesis.
> Skipping 39 cells works most of the time, but not always. I'm not sure
> what the web page structure format is.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar