Messages In This Digest (5 Messages)
- 1a.
- historical stock prices From: lawrence.leesh
- 1b.
- Re: historical stock prices From: Randy Harmelink
- 2a.
- Dynamically Displayed Data From: frusilier
- 2b.
- Re: Dynamically Displayed Data From: Randy Harmelink
Messages
- 1a.
-
historical stock prices
Posted by: "lawrence.leesh" lawrence.leesh@yahoo.com lawrence.leesh
Tue Jun 26, 2012 9:54 am (PDT)
Hi
Is there a way to have stock ticker as row headings, date as column headings and formulaes in individual cells referencing stock ticker and date and returning the adjusted closing prices?
thanks
LL
- 1b.
-
Re: historical stock prices
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 26, 2012 10:01 am (PDT)
Take a look at the smfPricesByDates() function. It does exactly that.
On Tue, Jun 26, 2012 at 8:49 AM, lawrence.leesh <lawrence.leesh@yahoo.com >wrote:
>
> Is there a way to have stock ticker as row headings, date as column
> headings and formulaes in individual cells referencing stock ticker and
> date and returning the adjusted closing prices?
>
- 2a.
-
Dynamically Displayed Data
Posted by: "frusilier" frusilier@yahoo.com frusilier
Tue Jun 26, 2012 12:00 pm (PDT)
Hi Randy,
I use the RCHGetWebData and played with the Position and Length to test the web page data and found that some sections are not retrievable though the sections are reflected in the source page. Does that mean they are Dynamically Displayed and hence not retrievable?
I then save the page to my desktop and then using the same function, I am able to use RCHGetWebData and extract those that are not retrievable directly via the website using the source from the desktop. Then I use RCHGetTableCell to select the data but it came up 'Error'. Before I explore further, can I use RCHGetTableCell to work on the webpage saved on my desktop as the source?
Thanks
Fru
- 2b.
-
Re: Dynamically Displayed Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jun 26, 2012 12:55 pm (PDT)
Another possibility is that the "sections" are frames, in which case you
would need to extract the data from the URL that the frame is displaying.
And, yes, you can use add-in functions to extract data from a webpage saved
on your desktop. It could be that the data was not actually presented
within a table.
On Tue, Jun 26, 2012 at 12:23 AM, frusilier <frusilier@yahoo.com > wrote:
>
> I use the RCHGetWebData and played with the Position and Length to test
> the web page data and found that some sections are not retrievable though
> the sections are reflected in the source page. Does that mean they are
> Dynamically Displayed and hence not retrievable?
>
> I then save the page to my desktop and then using the same function, I am
> able to use RCHGetWebData and extract those that are not retrievable
> directly via the website using the source from the desktop. Then I use
> RCHGetTableCell to select the data but it came up 'Error'. Before I explore
> further, can I use RCHGetTableCell to work on the webpage saved on my
> desktop as the source?
>
- 3.
-
CBOE put/call ration for the total market and individual equities fo
Posted by: "Vijay" vb_patel@yahoo.com vb_patel
Tue Jun 26, 2012 4:41 pm (PDT)
Hello,
Where do I get the CBOE total and individual equity put/call volume data from? I am looking for the historical as well as daily data.
Thanks,
-Vijay
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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