Messages In This Digest (8 Messages)
- 1a.
- Re: US Treasury Yield Data - RCHGetHTMLTable - Vlookup From: hashky
- 1b.
- Re: US Treasury Yield Data - RCHGetHTMLTable - Vlookup From: Randy Harmelink
- 2a.
- Re: find earliest date of history From: colinmmoors
- 3a.
- Re: Real-time data during market hours From: paul messerschmidt
- 3b.
- Re: Real-time data during market hours From: Randy Harmelink
- 3c.
- Re: Real-time data during market hours From: t
- 3d.
- Re: Real-time data during market hours From: t
- 4a.
- Private followup Re: Download MACD and RSI numbers on a weekly basis From: julien0986
Messages
- 1a.
-
Re: US Treasury Yield Data - RCHGetHTMLTable - Vlookup
Posted by: "hashky" hashky@yahoo.com hashky
Fri May 20, 2011 6:02 am (PDT)
Randy -
I used your link to pull in the Treasury Yield Table. But I am only interested in the latest "7 yr" return. I tried to use Vlookup, but it only returns a blank cell.
=VLOOKUP(TEXT(TODAY()," mm/dd/yy" ),$C5:$N$ 35,8)
I can add a column to the left =DATEVALUE(C5) through =DATEVALUE(C35), then it works.
VLOOKUP(Today(),$B$5:$N$ 35,9) returns the latest interest rate.
What am I missing here? Is there a better way?
Ron
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try something like:
>
> =RCHGetHTMLTable("
> http://www.treasury.gov/resource- center/data- chart-center/ interest- rates/Pages/ TextView. aspx?data= yield
> ",
> "7 Yr",-1,"",1)
>
> On Thu, May 19, 2011 at 7:42 AM, Steven <stevenletzer@...> wrote:
>
> > At this URL, I am trying to bring in the US Treasury yield table.
> >
> >
> > http://www.treasury.gov/resource- center/data- chart-center/ interest- rates/Pages/ TextView. aspx?data= yield
> >
> > Any ideas?
> >
>
- 1b.
-
Re: US Treasury Yield Data - RCHGetHTMLTable - Vlookup
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri May 20, 2011 8:29 am (PDT)
Well, you did say you wanted the table -- for an individual table cell, you
could do:
=RCHGetTableCell("
http://www.treasury.gov/resource- center/data- chart-center/ interest- rates/Pages/ TextView. aspx?data= yield
",
9,"7 Yr",,,,14)
On Fri, May 20, 2011 at 6:02 AM, hashky <hashky@yahoo.com > wrote:
>
> I used your link to pull in the Treasury Yield Table. But I am only
> interested in the latest "7 yr" return. I tried to use Vlookup, but it only
> returns a blank cell.
> =VLOOKUP(TEXT(TODAY()," mm/dd/yy" ),$C5:$N$ 35,8)
>
> I can add a column to the left =DATEVALUE(C5) through =DATEVALUE(C35), then
> it works.
>
> VLOOKUP(Today(),$B$5:$N$ 35,9) returns the latest interest rate.
>
> What am I missing here? Is there a better way?
>
- 2a.
-
Re: find earliest date of history
Posted by: "colinmmoors" colinmmoors@yahoo.com colinmmoors
Fri May 20, 2011 7:12 am (PDT)
perfect! thank you
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> This appears to work, for a ticker symbol in cell B8:
>
> =DATEVALUE(smfGetTagContent( "http://finance. yahoo.com/ "&B8,"option"q/hp?s= ,0,"name= ""a""","option
> selected")&" "
> &smfStrExtr(RCHGetWebData( "http://finance. yahoo.com/ "&B8,"id=""startdayq/hp?s= """,100), "value="" ","""")&" ,
> "
> &smfStrExtr(RCHGetWebData( "http://finance. yahoo.com/ q/hp?s=
> "&B8,"id=""startyear""",100) ,"value=" "",""""))
>
> On Thu, May 19, 2011 at 1:00 PM, colinmmoors <colinmmoors@...> wrote:
>
> > Hello, is there a way to return the date representing the earliest
> > historical price? example: RENN would return 5/4/2011 (the day it came
> > public).
> >
>
- 3a.
-
Re: Real-time data during market hours
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Fri May 20, 2011 7:18 am (PDT)
the url says it all
http://quotes.freerealtime. com/dl/frt/ S
On Thu, May 19, 2011 at 12:41 PM, t <tnmc77@yahoo.com > wrote:
>
>
> I am sure this has been addressed before. Unfortunately, I could not find
> the answer.
>
> Is there a way to get real-time data on stocks during market hours?
>
> TIA,
> Shashank
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 3b.
-
Re: Real-time data during market hours
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri May 20, 2011 8:39 am (PDT)
I just tried that template and both Yahoo and Google are giving me real-time
quotes, at least for some tickers. For example, SPY gave me a delayed quote
-- but so did your quote.com link.
On Thu, May 19, 2011 at 9:56 AM, t <tnmc77@yahoo.com > wrote:
> I thought I was but I misunderstood. As you know, the file you helped me
> with gives real time data for after-hours and not during market hours.
>
- 3c.
-
Re: Real-time data during market hours
Posted by: "t" tnmc77@yahoo.com tnmc77
Fri May 20, 2011 4:12 pm (PDT)
I am trying to fetch it to excel. Otherwise, there are few which provide real free real time data on their web site.
Thanks.
--- In smf_addin@yahoogroups.com , paul messerschmidt <financepaul@...> wrote:
>
> the url says it all
>
> http://quotes.freerealtime. com/dl/frt/ S
>
> On Thu, May 19, 2011 at 12:41 PM, t <tnmc77@...> wrote:
>
> >
> >
> > I am sure this has been addressed before. Unfortunately, I could not find
> > the answer.
> >
> > Is there a way to get real-time data on stocks during market hours?
> >
> > TIA,
> > Shashank
> >
> >
> >
>
>
>
> --
> --------------------- --------- --------- --
> Paul Messerschmidt
> paul.messerschmidt (skype)
> +1-813-334-8682 (mobile)
>
- 3d.
-
Re: Real-time data during market hours
Posted by: "t" tnmc77@yahoo.com tnmc77
Fri May 20, 2011 4:13 pm (PDT)
If you got real time data DURING market hours, then I will have to try it again on Monday with different tickers.
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just tried that template and both Yahoo and Google are giving me real-time
> quotes, at least for some tickers. For example, SPY gave me a delayed quote
> -- but so did your quote.com link.
>
> On Thu, May 19, 2011 at 9:56 AM, t <tnmc77@...> wrote:
>
> > I thought I was but I misunderstood. As you know, the file you helped me
> > with gives real time data for after-hours and not during market hours.
> >
>
- 4a.
-
Private followup Re: Download MACD and RSI numbers on a weekly basis
Posted by: "julien0986" bhaal0909@gmail.com julien0986
Sat May 21, 2011 3:26 am (PDT)
Hello,
Sorry for my late answer but I was not able to answer before. I will try to look at all to understand what is the problem.
Thanks a lot;
Julien
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> *My* version is currently 2.1.2011.04.28. Take a look in the "Works in
> Progress" folder and you'll find a change log. It should contain all changes
> I've made since the last official release, version 2.1.2010.08.02.
>
> Specifically, I had a lot of similar code in various functions that I moved
> to two new utility functions:
>
> 2011-02-16 smfGetWebPage Added this internal function to consolidate common
> coding that was in a number of modules related to the saved array of web
> pages. 2011-02-16 smfConvertData Added this internal function to consolidate
> common text-to-numeric conversion processing that in a number of modules.
> Currently, the smfConvertData() is simply:
>
> Public Function smfConvertData(ByVal pData As String, _
> Optional ByVal pConv As Integer = 0)
>
> '-------------------- --------- --------- --------- --------- --*
> ' 2011.02.16 -- Add routine
>
> '-------------------- --------- --------- --------- --------- --*
> s1 = pData
> On Error GoTo ErrorExit
> If InStr(s1, "/") > 0 Then
> Else
> If Trim(s1) = "-" Then s1 = "0"
> If Trim(s1) = "--" Then s1 = "0"
> If Trim(s1) = "---" Then s1 = "0"
> If s1 = Chr(150) Then s1 = "0"
> If Left(s1, 1) = "$" Then s1 = Mid(s1, 2)
> If Left(s1, 1) = "(" And Right(s1, 1) = ")" Then s1 = "-" & Mid(s1,
> 2, Len(s1) - 2)
> s2 = s1
>
> Select Case True
> Case Right(s2, 1) = "B": s2 = Left(s2, Len(s2) - 1): nMult =
> 1000000
> Case Right(s2, 1) = "M": s2 = Left(s2, Len(s2) - 1): nMult =
> 1000
> Case Right(s2, 1) = "%": s2 = Left(s2, Len(s2) - 1): nMult =
> 0.01
> Case Right(s2, 4) = " Bil": s2 = Left(s2, Len(s2) - 4): nMult =
> 1000000000
> Case Right(s2, 4) = " Mil": s2 = Left(s2, Len(s2) - 4): nMult =
> 1000000
> Case Else: nMult = 1
> End Select
>
> On Error Resume Next
> s1 = CDec(s2) * nMult
> On Error GoTo ErrorExit
> End If
>
> ErrorExit:
> smfConvertData = s1
>
> End Function
>
> Almost all of the routines that used to have something similar to that
> processing now call that routine instead. The two cDate() functions are both
> in the RCHGetYahooHistory() function. The other two cDec() functions are in
> the RCHCreateComment() routine. The reason I didn't change the
> RCHCreateComment() routine is because it has a specified "default" value
> that is independent of the string being passed, plus it is in an obscure
> part of the routine I don't think anyone uses.
>
> So it should be relatively easy now to adapt to your routine(s).
>
> On Tue, May 10, 2011 at 1:42 PM, prosuite <prosuite2000i@...> wrote:
>
> > > On a positive note, there are currently on two cDec() and two cDate()
> > > references in my version of the add-in.
> >
> > Really ... I may misunderstand but do you mean that in your actual version,
> > there are 2 cDec and 2 cDate only. If so, in the tweak SMF is use everyday
> > (is it really base version "2.1.2010.06.06" or never, I don't remember and
> > usually don't update that const), I have
> >
> > GlobalText -> 0 occurrences as this function is an helper for Excel
> >
> > LocalCDate -> 2 occurrences as you
> >
> > LocalCDec -> 26 occurrences
> > --------------------- -----
> > RCHCreateComment -> 2
> > RCHExtractData -> 1
> > smfGetEconData -> 1
> > RCHGetHTMLTable -> 1
> > smfGetMSNHistory -> 5
> > smfGetOptionQuotes -> 2
> > smgGetYahooOptionQuote -> 4
> > RCHGetYahooHistory -> 9
> > RCHGetYahooQuotes -> 1
> >
> > I would try to document every LocalCDec, I use. I guess that using
> > different regional settings than yours may help to enlight some misleading
> > behavior that you can't discover with your settings.
> >
> > Let me know if you have any interest on that matter ? If so, is "Version
> > 2.1.2011.04.03" in WIP your latest ?
> >
> > Before posting modRegionalSettings.bas, it would be great if we could 'kind
> > of synchronize' my small contribution (mainly cDec) into your latest
> > version.
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar