6 New Messages
Digest #2360
| |
Messages
Thu Oct 4, 2012 4:40 am (PDT) . Posted by:
"bushpilote" bushpilote
Hi,
you can import the spreadsheet into excel from the Web button in the Get External Data group on the Data tab. Enter Ron's address (https://spreadsheets.google.com/spreadsheet/pub?hl=en&key=0An9cLcebwyomdHV4MHBRMUNQdk5xNVljQ2tqWW9iNGc&hl=en&chrome=false&gid=0 ) in the address bar.
Hope this helps.
Randy, you are missed.
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> Randy is AWOL.Â
>
>
> I am no expert, but when I look at the source code for this page nothing is there. The website that has the data is below. You might try RCHGetHTMLTable() on this page. I could make it work, but it returned blank. There has to be some way to import google docs into Excel.
>
>
> Ron Spruell
>
>
> https://spreadsheets.google.com/spreadsheet/pub?hl=en&key=0An9cLcebwyomdHV4MHBRMUNQdk5xNVljQ2tqWW9iNGc&hl=en&chrome=false&gid=0
>
>
> >________________________________
> > From: tbrayman <tbrayman@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Wednesday, October 3, 2012 2:18 PM
> >Subject: [smf_addin] Problems Getting Data From Website
> >
> >
> >Â
> >
> >Hi,
> >
> >I was trying to get some information off this website:
> >
> >http://www.crossingwallstreet.com/buylist
> >
> >I tried to use both smfGetTagContent & RCHGetTableCell, but neither one is returning the web page contents. Is there a different method to do this?
> >
> >
> >
> >
> >
>
you can import the spreadsheet into excel from the Web button in the Get External Data group on the Data tab. Enter Ron's address (https://spreadsheet
Hope this helps.
Randy, you are missed.
--- In smf_addin@yahoogrou
>
> Randy is AWOL.Â
>
>
> I am no expert, but when I look at the source code for this page nothing is there. The website that has the data is below. You might try RCHGetHTMLTable(
>
>
> Ron Spruell
>
>
> https://spreadsheet
>
>
> >___________
> > From: tbrayman <tbrayman@..
> >To: smf_addin@yahoogrou
> >Sent: Wednesday, October 3, 2012 2:18 PM
> >Subject: [smf_addin] Problems Getting Data From Website
> >
> >
> >Â
> >
> >Hi,
> >
> >I was trying to get some information off this website:
> >
> >http://www.crossing
> >
> >I tried to use both smfGetTagContent & RCHGetTableCell, but neither one is returning the web page contents. Is there a different method to do this?
> >
> >
> >
> >
> >
>
Thu Oct 4, 2012 5:19 am (PDT) . Posted by:
"bushpilote" bushpilote
Hi,
try this for the 14-day data:
=RCHGetTableCell($C$4,C$5,"<body",,,,$B13,,,"--")
where $C$4 = http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
C$5:J$5 = Column numbers starting with 1 ending with 8 in increments of 1 (there are 8 columns of data in the table)
$B13:$B84 = row numbers starting from 8 ending with 79 in increments of one (there are 72 rows of data in the table including headings). One to seven (B6:B12) returns a combination of blanks, explanatory data and duplicate headings.
Copy the formula in C5:B84.
PS There's nothing sacred about starting in cells C4,C5 and B13.
Can't help you with the "other than 14-day" question.
Cheers.
--- In smf_addin@yahoogroups.com , "smithjhhic" <smithjhhic@...> wrote:
>
> Hello,
> I am trying to return "14-day SBV" and "14-day Volume MA" for the latest date (see site link below). There were some emails post relating to this site from 2009, but I was unable to apply those to my request. Also, the site allows the user to change the bar period from 14 day to another value (ie. 16 day). Is there away to use something other than 14 day with the addin? I appreciate any help you could provide.
>
> http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
>
try this for the 14-day data:
=RCHGetTableCell(
where $C$4 = http://www.marketvo
C$5:J$5 = Column numbers starting with 1 ending with 8 in increments of 1 (there are 8 columns of data in the table)
$B13:$B84 = row numbers starting from 8 ending with 79 in increments of one (there are 72 rows of data in the table including headings). One to seven (B6:B12) returns a combination of blanks, explanatory data and duplicate headings.
Copy the formula in C5:B84.
PS There's nothing sacred about starting in cells C4,C5 and B13.
Can't help you with the "other than 14-day" question.
Cheers.
--- In smf_addin@yahoogrou
>
> Hello,
> I am trying to return "14-day SBV" and "14-day Volume MA" for the latest date (see site link below). There were some emails post relating to this site from 2009, but I was unable to apply those to my request. Also, the site allows the user to change the bar period from 14 day to another value (ie. 16 day). Is there away to use something other than 14 day with the addin? I appreciate any help you could provide.
>
> http://www.marketvo
>
Thu Oct 4, 2012 4:13 pm (PDT) . Posted by:
"smithjhhic" smithjhhic
Thank you very much for your help.
--- In smf_addin@yahoogroups.com , "bushpilote" <bushpilote@...> wrote:
>
> Hi,
> try this for the 14-day data:
>
> =RCHGetTableCell($C$4,C$5,"<body",,,,$B13,,,"--")
>
> where $C$4 = http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
>
> C$5:J$5 = Column numbers starting with 1 ending with 8 in increments of 1 (there are 8 columns of data in the table)
>
> $B13:$B84 = row numbers starting from 8 ending with 79 in increments of one (there are 72 rows of data in the table including headings). One to seven (B6:B12) returns a combination of blanks, explanatory data and duplicate headings.
>
> Copy the formula in C5:B84.
>
> PS There's nothing sacred about starting in cells C4,C5 and B13.
>
> Can't help you with the "other than 14-day" question.
>
> Cheers.
>
> --- In smf_addin@yahoogroups.com , "smithjhhic" <smithjhhic@> wrote:
> >
> > Hello,
> > I am trying to return "14-day SBV" and "14-day Volume MA" for the latest date (see site link below). There were some emails post relating to this site from 2009, but I was unable to apply those to my request. Also, the site allows the user to change the bar period from 14 day to another value (ie. 16 day). Is there away to use something other than 14 day with the addin? I appreciate any help you could provide.
> >
> > http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
> >
>
--- In smf_addin@yahoogrou
>
> Hi,
> try this for the 14-day data:
>
> =RCHGetTableCell(
>
> where $C$4 = http://www.marketvo
>
> C$5:J$5 = Column numbers starting with 1 ending with 8 in increments of 1 (there are 8 columns of data in the table)
>
> $B13:$B84 = row numbers starting from 8 ending with 79 in increments of one (there are 72 rows of data in the table including headings). One to seven (B6:B12) returns a combination of blanks, explanatory data and duplicate headings.
>
> Copy the formula in C5:B84.
>
> PS There's nothing sacred about starting in cells C4,C5 and B13.
>
> Can't help you with the "other than 14-day" question.
>
> Cheers.
>
> --- In smf_addin@yahoogrou
> >
> > Hello,
> > I am trying to return "14-day SBV" and "14-day Volume MA" for the latest date (see site link below). There were some emails post relating to this site from 2009, but I was unable to apply those to my request. Also, the site allows the user to change the bar period from 14 day to another value (ie. 16 day). Is there away to use something other than 14 day with the addin? I appreciate any help you could provide.
> >
> > http://www.marketvo
> >
>
Thu Oct 4, 2012 12:49 pm (PDT) . Posted by:
"ntknow" ntknow
Hi,
New to this but have the individual stock prices working. Can some one tell me the symbols to use for the Dow, S&P500, NASDAQ, and Philadelphia Gold & Silver Index. The Yahoo ^symbols don't seem to work.
New to this but have the individual stock prices working. Can some one tell me the symbols to use for the Dow, S&P500, NASDAQ, and Philadelphia Gold & Silver Index. The Yahoo ^symbols don't seem to work.
Thu Oct 4, 2012 3:06 pm (PDT) . Posted by:
"Craig" c1sander
I'd like to use the 50 day moving average, but when I use RCHGetYahooQuotes,
the values are never quite correct. Anyone have any explanations or
suggestions?
Thanks,
Craig
the values are never quite correct. Anyone have any explanations or
suggestions?
Thanks,
Craig
Thu Oct 4, 2012 3:14 pm (PDT) . Posted by:
"Craig" c1sander
A follow-up to my question regarding inaccurate moving averages using
RCHGetYahooQuotes. The Add-in and function seem to be working properly,
Yahoo just has the wrong info. Does anyone have a good source for pulling
moving averages?
Craig
RCHGetYahooQuotes. The Add-in and function seem to be working properly,
Yahoo just has the wrong info. Does anyone have a good source for pulling
moving averages?
Craig
Tidak ada komentar:
Posting Komentar