9 New Messages
Digest #2460
Messages
Sun Jan 6, 2013 11:03 am (PST) . Posted by:
"Paul mcglinchey" mcglinchey77
Hi Prosuite
Would you possibly be able to help me with the current url. PGAtour.com have updated their website and the old links no longer work. Last years money list is at http://www.pgatour.com/content/pgatour/stats/stat.109.html using the http sniffer you suggested i found that http://www.pgatour.com/data/r/stats/current/109.json contains all the data i need but dont know how to get it into excel. I cant see any html page from the sniffer.
I have tried using the addin and RCHGetHTMLTable on the standard site using the table name but all it gets is the header of the table
Thanks in advance for any help.
--- In smf_addin@yahoogroups.com , "Kim Blake" wrote:
>
> I appreciate your efforts in helping me out, this will cut 15 to 20 minutes from my prep time to send out an update to the 137 members that are in my pool.
> 15 min X 32 Weeks left = 8 hours! I have reworked my spreadsheet for when the results for this weeks tournament are posted.
> P.S. Just by changing the year in the URL I can look up all the previous year totals as well.
> Thank you and especially thanks to Randy
> Again much appreciated
>
> From: prosuite
> Sent: Sunday, March 20, 2011 12:06 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] Golf Pool Money
>
>
> Different time zone helps to get some rest.
>
> To get effective URL, I use a HTTP sniffer. A tool that hooks itself between your browser and your modem/router to read each HTTP packets. HttpWatch is the simpliest to use by far but you need to buy a licence. Another one is EffeTech HTTP Sniffer which is a freeware but poweruser oriented. Either tool helps to "decode" real URL.
>
> You have no guarantee to obtain a usable URL as some site use fancy cookies/script to "secure" their HTTP source. By experience, it takes time only to access underlying data. One of the few site that I can't read was an indian energy site. In fact, I didn't want to waste my time trying to figure out what was the parameters.
>
> As for HTML escape chars, Randy uses a smaller set than HTML standards and my tweak version ; I can't remember if NBSP (ie char 160) is automatically process by Randy addin.
>
Would you possibly be able to help me with the current url. PGAtour.com have updated their website and the old links no longer work. Last years money list is at http://www.pgatour.
I have tried using the addin and RCHGetHTMLTable on the standard site using the table name but all it gets is the header of the table
Thanks in advance for any help.
--- In smf_addin@yahoogrou
>
> I appreciate your efforts in helping me out, this will cut 15 to 20 minutes from my prep time to send out an update to the 137 members that are in my pool.
> 15 min X 32 Weeks left = 8 hours! I have reworked my spreadsheet for when the results for this weeks tournament are posted.
> P.S. Just by changing the year in the URL I can look up all the previous year totals as well.
> Thank you and especially thanks to Randy
> Again much appreciated
>
> From: prosuite
> Sent: Sunday, March 20, 2011 12:06 PM
> To: smf_addin@yahoogrou
> Subject: Re: [smf_addin] Golf Pool Money
>
>
> Different time zone helps to get some rest.
>
> To get effective URL, I use a HTTP sniffer. A tool that hooks itself between your browser and your modem/router to read each HTTP packets. HttpWatch is the simpliest to use by far but you need to buy a licence. Another one is EffeTech HTTP Sniffer which is a freeware but poweruser oriented. Either tool helps to "decode" real URL.
>
> You have no guarantee to obtain a usable URL as some site use fancy cookies/script to "secure" their HTTP source. By experience, it takes time only to access underlying data. One of the few site that I can't read was an indian energy site. In fact, I didn't want to waste my time trying to figure out what was the parameters.
>
> As for HTML escape chars, Randy uses a smaller set than HTML standards and my tweak version ; I can't remember if NBSP (ie char 160) is automatically process by Randy addin.
>
Sun Jan 6, 2013 11:15 am (PST) . Posted by:
"Randy Harmelink" rharmelink
With that type of data, I would do a cascading extraction. For example:
C4: 1
D4: =RCHGetWebData("http://www.pgatour.com/data/r/stats/current/109.json
",C4,1000)
B5: =FIND("""plrNum""",D4,2)
C5: =C4+B5
D5: =RCHGetWebData("http://www.pgatour.com/data/r/stats/current/109.json
",C5,500)
Then copy B5:D5 down as needed. At that point, the start of the values in
D5 and downward contain all of the data for each of the players. Then just
extract each item you need with smfStrExtr(). For example, to extract last
name from D5:
=smfstrExtr($D5,"""last"" : ""","""")
On Sun, Jan 6, 2013 at 11:53 AM, Paul mcglinchey <
pajmcglinchey@googlemail.com > wrote:
>
> Would you possibly be able to help me with the current url. PGAtour.com
> have updated their website and the old links no longer work. Last years
> money list is at
> http://www.pgatour.com/content/pgatour/stats/stat.109.html using the http
> sniffer you suggested i found that
> http://www.pgatour.com/data/r/stats/current/109.json contains all the
> data i need but dont know how to get it into excel. I cant see any html
> page from the sniffer.
>
> I have tried using the addin and RCHGetHTMLTable on the standard site
> using the table name but all it gets is the header of the table
>
C4: 1
D4: =RCHGetWebData(
",C4,1000)
B5: =FIND("
C5: =C4+B5
D5: =RCHGetWebData(
",C5,500)
Then copy B5:D5 down as needed. At that point, the start of the values in
D5 and downward contain all of the data for each of the players. Then just
extract each item you need with smfStrExtr()
name from D5:
=smfstrExtr(
On Sun, Jan 6, 2013 at 11:53 AM, Paul mcglinchey <
pajmcglinchey@
>
> Would you possibly be able to help me with the current url. PGAtour.com
> have updated their website and the old links no longer work. Last years
> money list is at
> http://www.pgatour.
> sniffer you suggested i found that
> http://www.pgatour.
> data i need but dont know how to get it into excel. I cant see any html
> page from the sniffer.
>
> I have tried using the addin and RCHGetHTMLTable on the standard site
> using the table name but all it gets is the header of the table
>
Mon Jan 7, 2013 4:01 am (PST) . Posted by:
"Paul mcglinchey" mcglinchey77
Thanks for your help Randy much appreciated.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> With that type of data, I would do a cascading extraction. For example:
>
> C4: 1
> D4: =RCHGetWebData("http://www.pgatour.com/data/r/stats/current/109.json
> ",C4,1000)
> B5: =FIND("""plrNum""",D4,2)
> C5: =C4+B5
> D5: =RCHGetWebData("http://www.pgatour.com/data/r/stats/current/109.json
> ",C5,500)
>
> Then copy B5:D5 down as needed. At that point, the start of the values in
> D5 and downward contain all of the data for each of the players. Then just
> extract each item you need with smfStrExtr(). For example, to extract last
> name from D5:
>
> =smfstrExtr($D5,"""last"" : ""","""")
>
> On Sun, Jan 6, 2013 at 11:53 AM, Paul mcglinchey <
> pajmcglinchey@...> wrote:
>
> >
> > Would you possibly be able to help me with the current url. PGAtour.com
> > have updated their website and the old links no longer work. Last years
> > money list is at
> > http://www.pgatour.com/content/pgatour/stats/stat.109.html using the http
> > sniffer you suggested i found that
> > http://www.pgatour.com/data/r/stats/current/109.json contains all the
> > data i need but dont know how to get it into excel. I cant see any html
> > page from the sniffer.
> >
> > I have tried using the addin and RCHGetHTMLTable on the standard site
> > using the table name but all it gets is the header of the table
> >
>
--- In smf_addin@yahoogrou
>
> With that type of data, I would do a cascading extraction. For example:
>
> C4: 1
> D4: =RCHGetWebData(
> ",C4,1000)
> B5: =FIND("
> C5: =C4+B5
> D5: =RCHGetWebData(
> ",C5,500)
>
> Then copy B5:D5 down as needed. At that point, the start of the values in
> D5 and downward contain all of the data for each of the players. Then just
> extract each item you need with smfStrExtr()
> name from D5:
>
> =smfstrExtr(
>
> On Sun, Jan 6, 2013 at 11:53 AM, Paul mcglinchey <
> pajmcglinchey@
>
> >
> > Would you possibly be able to help me with the current url. PGAtour.com
> > have updated their website and the old links no longer work. Last years
> > money list is at
> > http://www.pgatour.
> > sniffer you suggested i found that
> > http://www.pgatour.
> > data i need but dont know how to get it into excel. I cant see any html
> > page from the sniffer.
> >
> > I have tried using the addin and RCHGetHTMLTable on the standard site
> > using the table name but all it gets is the header of the table
> >
>
Sun Jan 6, 2013 2:52 pm (PST) . Posted by:
"JP" front.paige
Sun Jan 6, 2013 4:45 pm (PST) . Posted by:
"Pete A" option2z
Hi Randy,
I run some code that depends on there being a specified range of data (way BMS for 1/1/2003 - 1/1/2008). Programmatically, what's the fastest, easiest way to find BMS's earliest and latest YAHOO History available dates?
Thanks,
Pete A
I run some code that depends on there being a specified range of data (way BMS for 1/1/2003 - 1/1/2008). Programmatically, what's the fastest, easiest way to find BMS's earliest and latest YAHOO History available dates?
Thanks,
Pete A
Sun Jan 6, 2013 4:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
See: http://finance.groups.yahoo.com/group/smf_addin/message/14544
On Sun, Jan 6, 2013 at 5:45 PM, Pete A optionzz@gmail.com > wrote:
>
> I run some code that depends on there being a specified range of data (way
> BMS for 1/1/2003 - 1/1/2008). Programmatically, what's the fastest,
> easiest way to find BMS's earliest and latest YAHOO History available dates?
>
On Sun, Jan 6, 2013 at 5:45 PM, Pete A optionzz@gmail.
>
> I run some code that depends on there being a specified range of data (way
> BMS for 1/1/2003 - 1/1/2008). Programmatically, what's the fastest,
> easiest way to find BMS's earliest and latest YAHOO History available dates?
>
Sun Jan 6, 2013 4:48 pm (PST) . Posted by:
"Adam Singh" adamsingh1
I am pulling earnings dates from earnings.com using RCHGetElementNumber. I built in a method to recognize if the report was AMC/BMO, and thus my vlookup adjusts for that factor and retrieves the appropriate earnings prices to calculate the price change due to earnings.
However, earnings.com often supplies dates which have neither AMC/BMO of they provide the exact time. How should I handle this? Does another website have more consistent data going back that far? I have played around with pulling the stock prices from the day before, during, and after. But I don't know how I would recognize which two of the three dates gives me the correct price return.
Thanks for your help.
However, earnings.com often supplies dates which have neither AMC/BMO of they provide the exact time. How should I handle this? Does another website have more consistent data going back that far? I have played around with pulling the stock prices from the day before, during, and after. But I don't know how I would recognize which two of the three dates gives me the correct price return.
Thanks for your help.
Sun Jan 6, 2013 5:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
If no exact time, I think the assumption would be it was sometime during
the market day.
And, by the way, I wouldn't rely on RCHGetElementNumber() for stuff like
that from earnings.com -- I later found out that a corporation can report
data for multiple corporate entities they own. For an example, take a look
at IBM.
Also, I don't know how the estimates are arrived at. If you go to different
data sources, you get different estimates depending on which data provider
they use and which analysts they follow. If you plan to use the results in
the future, you should be consistent on your source of the data. It
wouldn't be good to test based on one set of data, and then trade based on
another.
I don't know of any other source with such collected data.
On Sun, Jan 6, 2013 at 5:48 PM, Adam Singh singh.adam@gmail.com > wrote:
> I am pulling earnings dates from earnings.com using RCHGetElementNumber.
> I built in a method to recognize if the report was AMC/BMO, and thus my
> vlookup adjusts for that factor and retrieves the appropriate earnings
> prices to calculate the price change due to earnings.
>
> However, earnings.com often supplies dates which have neither AMC/BMO of
> they provide the exact time. How should I handle this? Does another
> website have more consistent data going back that far? I have played
> around with pulling the stock prices from the day before, during, and
> after. But I don't know how I would recognize which two of the three dates
> gives me the correct price return.
>
the market day.
And, by the way, I wouldn't rely on RCHGetElementNumber
that from earnings.com -- I later found out that a corporation can report
data for multiple corporate entities they own. For an example, take a look
at IBM.
Also, I don't know how the estimates are arrived at. If you go to different
data sources, you get different estimates depending on which data provider
they use and which analysts they follow. If you plan to use the results in
the future, you should be consistent on your source of the data. It
wouldn't be good to test based on one set of data, and then trade based on
another.
I don't know of any other source with such collected data.
On Sun, Jan 6, 2013 at 5:48 PM, Adam Singh singh.adam@gmail.
> I am pulling earnings dates from earnings.com using RCHGetElementNumber
> I built in a method to recognize if the report was AMC/BMO, and thus my
> vlookup adjusts for that factor and retrieves the appropriate earnings
> prices to calculate the price change due to earnings.
>
> However, earnings.com often supplies dates which have neither AMC/BMO of
> they provide the exact time. How should I handle this? Does another
> website have more consistent data going back that far? I have played
> around with pulling the stock prices from the day before, during, and
> after. But I don't know how I would recognize which two of the three dates
> gives me the correct price return.
>
Sun Jan 6, 2013 6:12 pm (PST) . Posted by:
"Adam Singh" adamsingh1
Thanks, but unfortunately I have run into cases where the report was AMC or BMO when no time was given. So it appears there is no way to build a formula to filter out the reporting time. I came to the same conclusion as you regarding the analyst data. Looks like I've hit a dead end.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> If no exact time, I think the assumption would be it was sometime during
> the market day.
>
> And, by the way, I wouldn't rely on RCHGetElementNumber() for stuff like
> that from earnings.com -- I later found out that a corporation can report
> data for multiple corporate entities they own. For an example, take a look
> at IBM.
>
> Also, I don't know how the estimates are arrived at. If you go to different
> data sources, you get different estimates depending on which data provider
> they use and which analysts they follow. If you plan to use the results in
> the future, you should be consistent on your source of the data. It
> wouldn't be good to test based on one set of data, and then trade based on
> another.
>
> I don't know of any other source with such collected data.
>
> On Sun, Jan 6, 2013 at 5:48 PM, Adam Singh wrote:
>
> > I am pulling earnings dates from earnings.com using RCHGetElementNumber.
> > I built in a method to recognize if the report was AMC/BMO, and thus my
> > vlookup adjusts for that factor and retrieves the appropriate earnings
> > prices to calculate the price change due to earnings.
> >
> > However, earnings.com often supplies dates which have neither AMC/BMO of
> > they provide the exact time. How should I handle this? Does another
> > website have more consistent data going back that far? I have played
> > around with pulling the stock prices from the day before, during, and
> > after. But I don't know how I would recognize which two of the three dates
> > gives me the correct price return.
> >
>
--- In smf_addin@yahoogrou
>
> If no exact time, I think the assumption would be it was sometime during
> the market day.
>
> And, by the way, I wouldn't rely on RCHGetElementNumber
> that from earnings.com -- I later found out that a corporation can report
> data for multiple corporate entities they own. For an example, take a look
> at IBM.
>
> Also, I don't know how the estimates are arrived at. If you go to different
> data sources, you get different estimates depending on which data provider
> they use and which analysts they follow. If you plan to use the results in
> the future, you should be consistent on your source of the data. It
> wouldn't be good to test based on one set of data, and then trade based on
> another.
>
> I don't know of any other source with such collected data.
>
> On Sun, Jan 6, 2013 at 5:48 PM, Adam Singh wrote:
>
> > I am pulling earnings dates from earnings.com using RCHGetElementNumber
> > I built in a method to recognize if the report was AMC/BMO, and thus my
> > vlookup adjusts for that factor and retrieves the appropriate earnings
> > prices to calculate the price change due to earnings.
> >
> > However, earnings.com often supplies dates which have neither AMC/BMO of
> > they provide the exact time. How should I handle this? Does another
> > website have more consistent data going back that far? I have played
> > around with pulling the stock prices from the day before, during, and
> > after. But I don't know how I would recognize which two of the three dates
> > gives me the correct price return.
> >
>
Tidak ada komentar:
Posting Komentar