1 New Message

Digest #2361

Re: Money Flow Calculator by "bushpilote@yahoo.ca" bushpilote

Message

1a

Re: Money Flow Calculator

Fri Oct 5, 2012 4:27 am (PDT) . Posted by:

"bushpilote@yahoo.ca" bushpilote

You are welcomed.
--- In smf_addin@yahoogroups.com, "smithjhhic" <smithjhhic@...> wrote:
>
> 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
> > >
> >
>