10 New Messages
Digest #2399
Messages
Mon Nov 12, 2012 6:17 am (PST) . Posted by:
"smithjhhic" smithjhhic
Randy,
Thank you! The price trend site defaults to 14 bar period. The site allows you to change to 21. Is there a way to specify in the formula 21 period? I tried with ZLC and able to retrieve if I specify the symbol and name. But I'm unable to accomplish when referring to cell C39 to obtain the symbol.
Thanks,
Jeff
http://www.marketvolume.com/stocks/vpricetrend.asp?s=ZLC&t=zale&p1=21
http://www.marketvolume.com/stocks/vpricetrend.asp?s= "&C39&"&p1=21
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It would just be:
>
> =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> ",6,">Date",,,,1)
> =RCHGetTableCell("http://www.marketvolume.com/stocks/vpricetrend.asp?s=AAPL
> ",6,">Date",,,,1)
>
> Font shouldn't be an issue for MFI, since it's just based on the value
> itself. But, to get the color, you could do something like:
>
> =smfStrExtr(smfGetTagContent("
> http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
> ","tr",1,">Date"),"color:","""")
>
> On Mon, Nov 12, 2012 at 3:31 AM, smithjhhic <smithjhhic@...> wrote:
>
> > The site recently changed and broke the formula in the previous post.
> >
> > http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
> >
> > Due to the recent site changes I was trying to bring back "MFI (14)". For
> > some reason I can't get the formula correct. The value is also in green or
> > red font. Is there a way to bring back that information as well? If it is
> > not possible to display red or green could the value be represented by a (+
> > or -) or some other method?
> >
> > I am also trying to obtain the VPT signal for site below with red/green
> > font and having similar difficulty with formula. Any help would be greatly
> > appreciated.
> > Jeff
> >
> > http://www.marketvolume.com/stocks/vpricetrend.asp?s=AAPL&t=apple
> >
>
Thank you! The price trend site defaults to 14 bar period. The site allows you to change to 21. Is there a way to specify in the formula 21 period? I tried with ZLC and able to retrieve if I specify the symbol and name. But I'm unable to accomplish when referring to cell C39 to obtain the symbol.
Thanks,
Jeff
http://www.marketvo
http://www.marketvo
--- In smf_addin@yahoogrou
>
> It would just be:
>
> =RCHGetTableCell(
> ",6,">Date",
> =RCHGetTableCell(
> ",6,">Date",
>
> Font shouldn't be an issue for MFI, since it's just based on the value
> itself. But, to get the color, you could do something like:
>
> =smfStrExtr(
> http://www.marketvo
> ","tr",1,">Date"
>
> On Mon, Nov 12, 2012 at 3:31 AM, smithjhhic <smithjhhic@
>
> > The site recently changed and broke the formula in the previous post.
> >
> > http://www.marketvo
> >
> > Due to the recent site changes I was trying to bring back "MFI (14)". For
> > some reason I can't get the formula correct. The value is also in green or
> > red font. Is there a way to bring back that information as well? If it is
> > not possible to display red or green could the value be represented by a (+
> > or -) or some other method?
> >
> > I am also trying to obtain the VPT signal for site below with red/green
> > font and having similar difficulty with formula. Any help would be greatly
> > appreciated.
> > Jeff
> >
> > http://www.marketvo
> >
>
Mon Nov 12, 2012 6:45 am (PST) . Posted by:
"smithjhhic" smithjhhic
Randy,
Thank you! The price trend site defaults to 14 bar period. The site allows you to change to 21. Is there a way to specify in the formula 21 period? I tried with ZLC and able to retrieve if I specify the symbol and name. But I'm unable to accomplish when referring to cell C39 to obtain the symbol.
http://www.marketvolume.com/stocks/vpricetrend.asp?s=ZLC&t=zale&p1=21
http://www.marketvolume.com/stocks/vpricetrend.asp?s= "&C39&"&p1=21
I was also trying to apply your examples below to the selling buying site (link below). However, I see to have an error.
Thanks,
Jeff
http://www.marketvolume.com/stocks/sellingbuying.asp?s=AAPL&t=apple
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > It would just be:
> >
> > =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> > ",6,">Date",,,,1)
> > =RCHGetTableCell("http://www.marketvolume.com/stocks/vpricetrend.asp?s=AAPL
> > ",6,">Date",,,,1)
> >
> > Font shouldn't be an issue for MFI, since it's just based on the value
> > itself. But, to get the color, you could do something like:
> >
> > =smfStrExtr(smfGetTagContent("
> > http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
> > ","tr",1,">Date"),"color:","""")
> >
> > On Mon, Nov 12, 2012 at 3:31 AM, smithjhhic <smithjhhic@> wrote:
> >
> > > The site recently changed and broke the formula in the previous post.
> > >
> > > http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL&t=apple
> > >
> > > Due to the recent site changes I was trying to bring back "MFI (14)". For
> > > some reason I can't get the formula correct. The value is also in green or
> > > red font. Is there a way to bring back that information as well? If it is
> > > not possible to display red or green could the value be represented by a (+
> > > or -) or some other method?
> > >
> > > I am also trying to obtain the VPT signal for site below with red/green
> > > font and having similar difficulty with formula. Any help would be greatly
> > > appreciated.
> > > Jeff
> > >
> > > http://www.marketvolume.com/stocks/vpricetrend.asp?s=AAPL&t=apple
> > >
> >
>
Thank you! The price trend site defaults to 14 bar period. The site allows you to change to 21. Is there a way to specify in the formula 21 period? I tried with ZLC and able to retrieve if I specify the symbol and name. But I'm unable to accomplish when referring to cell C39 to obtain the symbol.
http://www.marketvo
http://www.marketvo
I was also trying to apply your examples below to the selling buying site (link below). However, I see to have an error.
Thanks,
Jeff
http://www.marketvo
> --- In smf_addin@yahoogrou
> >
> > It would just be:
> >
> > =RCHGetTableCell(
> > ",6,">Date",
> > =RCHGetTableCell(
> > ",6,">Date",
> >
> > Font shouldn't be an issue for MFI, since it's just based on the value
> > itself. But, to get the color, you could do something like:
> >
> > =smfStrExtr(
> > http://www.marketvo
> > ","tr",1,">Date"
> >
> > On Mon, Nov 12, 2012 at 3:31 AM, smithjhhic <smithjhhic@
> >
> > > The site recently changed and broke the formula in the previous post.
> > >
> > > http://www.marketvo
> > >
> > > Due to the recent site changes I was trying to bring back "MFI (14)". For
> > > some reason I can't get the formula correct. The value is also in green or
> > > red font. Is there a way to bring back that information as well? If it is
> > > not possible to display red or green could the value be represented by a (+
> > > or -) or some other method?
> > >
> > > I am also trying to obtain the VPT signal for site below with red/green
> > > font and having similar difficulty with formula. Any help would be greatly
> > > appreciated.
> > > Jeff
> > >
> > > http://www.marketvo
> > >
> >
>
Mon Nov 12, 2012 8:55 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It would be:
"http://www.marketvolume.com/stocks/vpricetrend.asp?s= "&C4&"&t=zale&p1=21"
However, I usually just rearrange the order of the parameters so that the
ticker symbol is the last thing (also note that the "t" parameter is
irrelevant):
"http://www.marketvolume.com/stocks/vpricetrend.asp?p1=21&s= "&C4
On Mon, Nov 12, 2012 at 7:17 AM, smithjhhic <smithjhhic@yahoo.com > wrote:
> Randy,
> Thank you! The price trend site defaults to 14 bar period. The site
> allows you to change to 21. Is there a way to specify in the formula 21
> period? I tried with ZLC and able to retrieve if I specify the symbol and
> name. But I'm unable to accomplish when referring to cell C39 to obtain
> the symbol.
> Thanks,
> Jeff
>
>
> http://www.marketvolume.com/stocks/vpricetrend.asp?s=ZLC&t=zale&p1=21
>
>
> http://www.marketvolume.com/stocks/vpricetrend.asp?s= "&C39&"&p1=21
>
"http://www.marketvo
However, I usually just rearrange the order of the parameters so that the
ticker symbol is the last thing (also note that the "t" parameter is
irrelevant):
"http://www.marketvo
On Mon, Nov 12, 2012 at 7:17 AM, smithjhhic <smithjhhic@yahoo.
> Randy,
> Thank you! The price trend site defaults to 14 bar period. The site
> allows you to change to 21. Is there a way to specify in the formula 21
> period? I tried with ZLC and able to retrieve if I specify the symbol and
> name. But I'm unable to accomplish when referring to cell C39 to obtain
> the symbol.
> Thanks,
> Jeff
>
>
> http://www.marketvo
>
>
> http://www.marketvo
>
Mon Nov 12, 2012 3:32 pm (PST) . Posted by:
"smithjhhic" smithjhhic
Randy,
Thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It would be:
>
> "http://www.marketvolume.com/stocks/vpricetrend.asp?s= "&C4&"&t=zale&p1=21"
>
> However, I usually just rearrange the order of the parameters so that the
> ticker symbol is the last thing (also note that the "t" parameter is
> irrelevant):
>
> "http://www.marketvolume.com/stocks/vpricetrend.asp?p1=21&s= "&C4
>
> On Mon, Nov 12, 2012 at 7:17 AM, smithjhhic <smithjhhic@...> wrote:
>
> > Randy,
> > Thank you! The price trend site defaults to 14 bar period. The site
> > allows you to change to 21. Is there a way to specify in the formula 21
> > period? I tried with ZLC and able to retrieve if I specify the symbol and
> > name. But I'm unable to accomplish when referring to cell C39 to obtain
> > the symbol.
> > Thanks,
> > Jeff
> >
> >
> > http://www.marketvolume.com/stocks/vpricetrend.asp?s=ZLC&t=zale&p1=21
> >
> >
> > http://www.marketvolume.com/stocks/vpricetrend.asp?s= "&C39&"&p1=21
> >
>
Thanks!
--- In smf_addin@yahoogrou
>
> It would be:
>
> "http://www.marketvo
>
> However, I usually just rearrange the order of the parameters so that the
> ticker symbol is the last thing (also note that the "t" parameter is
> irrelevant):
>
> "http://www.marketvo
>
> On Mon, Nov 12, 2012 at 7:17 AM, smithjhhic <smithjhhic@
>
> > Randy,
> > Thank you! The price trend site defaults to 14 bar period. The site
> > allows you to change to 21. Is there a way to specify in the formula 21
> > period? I tried with ZLC and able to retrieve if I specify the symbol and
> > name. But I'm unable to accomplish when referring to cell C39 to obtain
> > the symbol.
> > Thanks,
> > Jeff
> >
> >
> > http://www.marketvo
> >
> >
> > http://www.marketvo
> >
>
Mon Nov 12, 2012 1:30 pm (PST) . Posted by:
"Steven" stevenletzer
The FINRA website maintains price, description and transation data: http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/Default.aspx
I am trying to extract Composite Trade Information. For example: CUSIP 167593JA1, the Bond Detail page is at this adddress: http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx. The last 12 characters (MTY3NTkzSkEx)are an internal coding system, assigned by FINRA. Since I have not found a way to determine this code, I have created an Excel table with the CUSIP and the FINRA code copied in (any suggestions for finding the FINRA code would be appreciated].
The Bond Detail page display both fixed description information and variable price/yield information. At the bottom of the page in the section Composite Trade Information, I want to extract in the last 3 lines on the left of the table: Date, Price and Yield.
I created an Excel table with these fields:
CUSIP: 167593JA1
Short Name: CHICAGO IL B 3.75 010128
Bond Detail Page address: http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx
FINRA ID: MTY3NTkzSkEx [extracted from the page address]
Price: =RCHGetTableCell("http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID= "&$H2,1,"Price:")[the Last Sale Price returned is correct].
Date: RCHGetTableCell("http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID= "&$H2,1,"Date:")*1 --- This returns the wrong date. The date should be they Last Sale Date
Any ideas?
I am trying to extract Composite Trade Information. For example: CUSIP 167593JA1, the Bond Detail page is at this adddress: http://cxa.gtm.
The Bond Detail page display both fixed description information and variable price/yield information. At the bottom of the page in the section Composite Trade Information, I want to extract in the last 3 lines on the left of the table: Date, Price and Yield.
I created an Excel table with these fields:
CUSIP: 167593JA1
Short Name: CHICAGO IL B 3.75 010128
Bond Detail Page address: http://cxa.gtm.
FINRA ID: MTY3NTkzSkEx [extracted from the page address]
Price: =RCHGetTableCell(
Date: RCHGetTableCell(
Any ideas?
Mon Nov 12, 2012 4:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You need to do additional search strings to get to the correct date:
=RCHGetTableCell("
http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx ",1,">Last
Sale","Date:")
On Mon, Nov 12, 2012 at 2:30 PM, Steven <stevenletzer@yahoo.com > wrote:
> The FINRA website maintains price, description and transation data:
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/Default.aspx
> I am trying to extract Composite Trade Information. For example: CUSIP
> 167593JA1, the Bond Detail page is at this adddress:
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx.
> The last 12 characters (MTY3NTkzSkEx)are an internal coding system,
> assigned by FINRA. Since I have not found a way to determine this code, I
> have created an Excel table with the CUSIP and the FINRA code copied in
> (any suggestions for finding the FINRA code would be appreciated].
>
> The Bond Detail page display both fixed description information and
> variable price/yield information. At the bottom of the page in the section
> Composite Trade Information, I want to extract in the last 3 lines on the
> left of the table: Date, Price and Yield.
>
> I created an Excel table with these fields:
> CUSIP: 167593JA1
>
> Short Name: CHICAGO IL B 3.75 010128
>
> Bond Detail Page address:
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID=MTY3NTkzSkEx
>
> FINRA ID: MTY3NTkzSkEx [extracted from the page address]
>
> Price: =RCHGetTableCell("
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID= "&$H2,1,"Price:")[the
> Last Sale Price returned is correct].
>
> Date: RCHGetTableCell("
> http://cxa.gtm.idmanagedsolutions.com/finra/BondCenter/BondDetail.aspx?ID= "&$H2,1,"Date:")*1
> --- This returns the wrong date. The date should be they Last Sale Date
>
> Any ideas?
>
=RCHGetTableCell(
http://cxa.gtm.
Sale","Date:
On Mon, Nov 12, 2012 at 2:30 PM, Steven <stevenletzer@
> The FINRA website maintains price, description and transation data:
> http://cxa.gtm.
> I am trying to extract Composite Trade Information. For example: CUSIP
> 167593JA1, the Bond Detail page is at this adddress:
> http://cxa.gtm.
> The last 12 characters (MTY3NTkzSkEx)
> assigned by FINRA. Since I have not found a way to determine this code, I
> have created an Excel table with the CUSIP and the FINRA code copied in
> (any suggestions for finding the FINRA code would be appreciated]
>
> The Bond Detail page display both fixed description information and
> variable price/yield information. At the bottom of the page in the section
> Composite Trade Information, I want to extract in the last 3 lines on the
> left of the table: Date, Price and Yield.
>
> I created an Excel table with these fields:
> CUSIP: 167593JA1
>
> Short Name: CHICAGO IL B 3.75 010128
>
> Bond Detail Page address:
> http://cxa.gtm.
>
> FINRA ID: MTY3NTkzSkEx [extracted from the page address]
>
> Price: =RCHGetTableCell(
> http://cxa.gtm.
> Last Sale Price returned is correct].
>
> Date: RCHGetTableCell(
> http://cxa.gtm.
> --- This returns the wrong date. The date should be they Last Sale Date
>
> Any ideas?
>
Mon Nov 12, 2012 4:10 pm (PST) . Posted by:
"chad.touchberry" chad.touchberry
Really all I need to do what I want is for excel to pull the historic data (date, open, high,low, close, avg vol, adj close) from a website like http://ichart.finance.yahoo.com. Is this possible with the =RCHGetYahooHistory function? I can't seem to get it to work.
Tue Nov 13, 2012 1:25 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Are you array-entering the formula over a range? Otherwise, I have no
suggestions to make until you explain the symptoms of not working...
At its simplest, all you need is something like:
=RCHGetYahooHistory("MSFT")
...over a range of 7 columns and the number of rows of data you want.
On Mon, Nov 12, 2012 at 4:42 PM, chad.touchberry
<chad.touchberry@yahoo.com >wrote:
> Really all I need to do what I want is for excel to pull the historic data
> (date, open, high,low, close, avg vol, adj close) from a website like
> http://ichart.finance.yahoo.com. Is this possible with the
> =RCHGetYahooHistory function? I can't seem to get it to work.
>
suggestions to make until you explain the symptoms of not working...
At its simplest, all you need is something like:
=RCHGetYahooHistory
...over a range of 7 columns and the number of rows of data you want.
On Mon, Nov 12, 2012 at 4:42 PM, chad.touchberry
<chad.touchberry@
> Really all I need to do what I want is for excel to pull the historic data
> (date, open, high,low, close, avg vol, adj close) from a website like
> http://ichart.
> =RCHGetYahooHistory function? I can't seem to get it to work.
>
Mon Nov 12, 2012 7:50 pm (PST) . Posted by:
"highflight1985" highflight1985
Hello. I'm looking through RCHGetElementNumber Definitions and can't find a definition that will pull Dividends Paid and Sale Purchase of Stock from Yahoo. If that cannot be done, then here's my overall objective; perhaps there is another source that can be a one-stop-shop for all the data I need. It's important that the data is consistent and from one source.
I need to calculate:
1. Add all quarterly stock buyback for the last four quarters.
2. Add all dividends paid.
3. Add Step 1 and Step 2.
4. Divide Step 3 by Market Cap.
Any help would be appreciated.
Thanks!
I need to calculate:
1. Add all quarterly stock buyback for the last four quarters.
2. Add all dividends paid.
3. Add Step 1 and Step 2.
4. Divide Step 3 by Market Cap.
Any help would be appreciated.
Thanks!
Mon Nov 12, 2012 7:52 pm (PST) . Posted by:
"highflight1985" highflight1985
In step 2, I meant to say:
Add all quarterly dividends paid (not per share) for the last four quarters.
Sorry for the typo.
Thanks...
--- In smf_addin@yahoogroups.com , "highflight1985" <highflight1985@...> wrote:
>
> Hello. I'm looking through RCHGetElementNumber Definitions and can't find a definition that will pull Dividends Paid and Sale Purchase of Stock from Yahoo. If that cannot be done, then here's my overall objective; perhaps there is another source that can be a one-stop-shop for all the data I need. It's important that the data is consistent and from one source.
>
> I need to calculate:
>
> 1. Add all quarterly stock buyback for the last four quarters.
> 2. Add all dividends paid.
> 3. Add Step 1 and Step 2.
> 4. Divide Step 3 by Market Cap.
>
> Any help would be appreciated.
>
> Thanks!
>
Add all quarterly dividends paid (not per share) for the last four quarters.
Sorry for the typo.
Thanks...
--- In smf_addin@yahoogrou
>
> Hello. I'm looking through RCHGetElementNumber Definitions and can't find a definition that will pull Dividends Paid and Sale Purchase of Stock from Yahoo. If that cannot be done, then here's my overall objective; perhaps there is another source that can be a one-stop-shop for all the data I need. It's important that the data is consistent and from one source.
>
> I need to calculate:
>
> 1. Add all quarterly stock buyback for the last four quarters.
> 2. Add all dividends paid.
> 3. Add Step 1 and Step 2.
> 4. Divide Step 3 by Market Cap.
>
> Any help would be appreciated.
>
> Thanks!
>
Tidak ada komentar:
Posting Komentar