Messages In This Digest (25 Messages)
- 1a.
- Is there a way to get NYSE daily number of new highs and new lows? From: Tze Wei,
- 1b.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Market Monk
- 1c.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Tze Wei,
- 1d.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Randy Harmelink
- 1e.
- Re: Is there a way to get NYSE daily number of new highs and new low From: Tze Wei,
- 2.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
- 3a.
- Re: Yahoo Quote failures - work-around? From: Paul
- 3b.
- Re: Yahoo Quote failures - work-around? From: cherry77tree
- 3c.
- Re: Yahoo Quote failures - work-around? From: dguillett1
- 4.
- Question on getting NYSE New High and Low and differences between Ba From: Tze Wei,
- 5a.
- Newbie From: wu_ming_sg
- 5b.
- Re: Newbie From: Randy H
- 5c.
- Re: Newbie From: wu_ming_sg
- 5d.
- Re: Newbie From: Randy Harmelink
- 5e.
- Re: Newbie From: wu_ming_sg
- 5f.
- Re: Newbie From: Randy Harmelink
- 6a.
- How to add Talib in excel 2007 ? From: ashu
- 6b.
- Re: How to add Talib in excel 2007 ? From: Randy Harmelink
- 6c.
- Re: How to add Talib in excel 2007 ? From: ashu
- 6d.
- Re: How to add Talib in excel 2007 ? From: Randy Harmelink
- 7a.
- Incorrect price returned? From: jaja3279
- 7b.
- Re: Incorrect price returned? From: dguillett1
- 7c.
- Re: Incorrect price returned? From: Randy Harmelink
- 8a.
- Re: Finviz Earnings Date From: Fred Wright
Messages
- 1a.
-
Is there a way to get NYSE daily number of new highs and new lows?
Posted by: "Tze Wei," tzewei_79@yahoo.com.sg tzewei_79
Sat Aug 13, 2011 6:58 am (PDT)
Hi,
May I know if we can get NYSE daily number of new highs and new lows?
Regards
- 1b.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Market Monk" marketmonk777@yahoo.com marketmonk777
Sat Aug 13, 2011 7:46 am (PDT)
1st idea that comes to mind:
http://online.wsj.com/mdc/ public/page/ marketsdata. html?mod= WSJ_topnav_ na_markets
scroll down to Markets Diary and that section will have today's data for you. Not sure if it can be data mined using the Add-In.
If you are a subscriber to Wall Street Journal Online you will get access to the historical data (back to 2007). But it looks like you have to manually click on a calendar to bring up that days data. I am not a subscriber so not sure if the string can be automated to do so via the Add-In.
The Wall Street Journal is a well respected source for market data.
On another hand there is www.eoddata.com which in their Global Indicies file has a ton of market data. Go to
http://www.eoddata.com/symbols. aspx
select Global Indicies in their drop down box and hit the Display button.
You will see they have a ton of stats. They are based on their symbol library and how each symbol is assigned (to what market).
If you sign up for their free service you can download up to the last 30 days of files. But then have to extract the data you want and append each line together or manipulate in some fashion to suite your needs.
Hopefully someone else knows of a source that is accurate and allows us to download historical data.
Monk
--- In smf_addin@yahoogroups.com , "Tze Wei," <tzewei_79@...> wrote:
>
> Hi,
>
> May I know if we can get NYSE daily number of new highs and new lows?
>
> Regards
>
- 1c.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Tze Wei," tzewei_79@yahoo.com.sg tzewei_79
Sat Aug 13, 2011 8:38 am (PDT)
Hi,
Thanks for links. I guess the WSJ is the same as barchart thus we can use =RCHGetElementNumber to get the daily close.
I did managed to get about 23 days of data from http://www.eoddata.com. The symbol is HIGN for new high and LOWN for new low. But I need more data to plot some market breadth indicator.
If anyone knows how to get more data, pls advise.
--- In smf_addin@yahoogroups.com , "Market Monk" <marketmonk777@...> wrote:
>
> 1st idea that comes to mind:
> http://online.wsj.com/mdc/ public/page/ marketsdata. html?mod= WSJ_topnav_ na_markets
> scroll down to Markets Diary and that section will have today's data for you. Not sure if it can be data mined using the Add-In.
>
> If you are a subscriber to Wall Street Journal Online you will get access to the historical data (back to 2007). But it looks like you have to manually click on a calendar to bring up that days data. I am not a subscriber so not sure if the string can be automated to do so via the Add-In.
>
> The Wall Street Journal is a well respected source for market data.
>
> On another hand there is www.eoddata.com which in their Global Indicies file has a ton of market data. Go to
> http://www.eoddata.com/symbols. aspx
> select Global Indicies in their drop down box and hit the Display button.
> You will see they have a ton of stats. They are based on their symbol library and how each symbol is assigned (to what market).
>
> If you sign up for their free service you can download up to the last 30 days of files. But then have to extract the data you want and append each line together or manipulate in some fashion to suite your needs.
>
> Hopefully someone else knows of a source that is accurate and allows us to download historical data.
>
> Monk
>
> --- In smf_addin@yahoogroups.com , "Tze Wei," <tzewei_79@> wrote:
> >
> > Hi,
> >
> > May I know if we can get NYSE daily number of new highs and new lows?
> >
> > Regards
> >
>
- 1d.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Aug 13, 2011 8:47 am (PDT)
Take a look at http://unicorn.us.com/advdec/
On Sat, Aug 13, 2011 at 6:58 AM, Tze Wei, <tzewei_79@yahoo.com.sg > wrote:
>
> May I know if we can get NYSE daily number of new highs and new lows?
>
- 1e.
-
Re: Is there a way to get NYSE daily number of new highs and new low
Posted by: "Tze Wei," tzewei_79@yahoo.com.sg tzewei_79
Sat Aug 13, 2011 10:55 pm (PDT)
Hi,
Ah, this is the best. Thanks!!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at http://unicorn.us.com/advdec/
>
> On Sat, Aug 13, 2011 at 6:58 AM, Tze Wei, <tzewei_79@...> wrote:
>
> >
> > May I know if we can get NYSE daily number of new highs and new lows?
> >
>
- 2.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Sat Aug 13, 2011 7:03 am (PDT)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Uploads by forum members/YahooQuoteFailure.xls
Uploaded by : pchek <pchek@yahoo.com >
Description : Workaround for Yahoo Quote Server returning old data.
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Uploads%20by% 20forum%20member s/YahooQuoteFail ure.xls
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
pchek <pchek@yahoo.com >
- 3a.
-
Re: Yahoo Quote failures - work-around?
Posted by: "Paul" pchek@yahoo.com pchek
Sat Aug 13, 2011 7:13 am (PDT)
Posted a file YahooQuoteFailure.xls that has a work around for the old data sometimes returned by the Yahoo Quote Server.
Here is a short explaination:
Cells M4:s4 use the RCHGetYahooQuotes function to retrieve trade information. Cell P4 is the date of the last trade in text format.
Cell J3 computes the date of the last trading day.
Cell J4 converts the text date to a serial number date and compares it to J3, the last trading day. If the retrieved date is current; it shows the date. If the retrieved date is LESS THAN the last trading date it displays the string "BAD DATA".
I have not figured out how to fix the error yet; but at least I know that the prices are out of date.
Paul
--- In smf_addin@yahoogroups.com , "Market Monk" <marketmonk777@...> wrote:
>
> Are you getting this "old" data for a single ticker, the same ticker(s), or random tickers?
>
> Are you trying to obtain a single quote (latest day) or multiple days?
>
>
> --- In smf_addin@yahoogroups.com , "MikeM" <mikemcq802@> wrote:
> >
> > I have also been experiencing Yahoo Quote accuracy problems over the past couple weeks. I have a couple spreadsheets I've used for more than a year which retrieve array-entered quotes. These have worked flawlessly until recently.
> >
> > I get a quote, it's just not always today's quote. It's not unusual to get one from a week ago - or a week ending quote rather than the current.
> >
> > Once I realized the quotes weren't random but valid quotes just for the wrong day I now retrieve the date in the quote request to ensure its the day I expect. E.G., today, on Aug 10 it's not unusual to get quotes returned with an Aug 2 date. The quote is right for Aug 2, it's just not supposed to be returned on the 10th.
> >
> > I use Randy's "refresh" macro and have that as a button in the spreadsheet to speed re-tries. It usually only takes a couple clicks to get all the quotes correct. Annoying but fairly quick.
> >
> > In one spreadsheet I have 4 separate array-entered quote retrieval blocks. Interestingly, an array of quotes is either all-right or all-wrong. But, it's not unusual to have 1 array of quotes be from a different date than another array of quotes in the same spreadsheet.
> >
> > I have IE's cache set to "Every time I visit page" per Randy's documentation.
> >
> > I cannot mimic this failure using IE and downloading CSV quotes. If I could, I'd submit it to Yahoo!
> >
>
- 3b.
-
Re: Yahoo Quote failures - work-around?
Posted by: "cherry77tree" david.nincic.wg99@wharton.upenn.edu cherry77tree
Sat Aug 13, 2011 9:48 am (PDT)
Thanks Paul for doing this. In which folder did you post the xls file?
I couldn't find it.
David
--- In smf_addin@yahoogroups.com , "Paul" <pchek@...> wrote:
>
> Posted a file YahooQuoteFailure.xls that has a work around for the old
data sometimes returned by the Yahoo Quote Server.
>
> Here is a short explaination:
> Cells M4:s4 use the RCHGetYahooQuotes function to retrieve trade
information. Cell P4 is the date of the last trade in text format.
> Cell J3 computes the date of the last trading day.
> Cell J4 converts the text date to a serial number date and compares it
to J3, the last trading day. If the retrieved date is current; it shows
the date. If the retrieved date is LESS THAN the last trading date it
displays the string "BAD DATA".
>
> I have not figured out how to fix the error yet; but at least I know
that the prices are out of date.
>
> Paul
>
>
> --- In smf_addin@yahoogroups.com , "Market Monk" marketmonk777@ wrote:
> >
> > Are you getting this "old" data for a single ticker, the same
ticker(s), or random tickers?
> >
> > Are you trying to obtain a single quote (latest day) or multiple
days?
> >
> >
> > --- In smf_addin@yahoogroups.com , "MikeM" <mikemcq802@> wrote:
> > >
> > > I have also been experiencing Yahoo Quote accuracy problems over
the past couple weeks. I have a couple spreadsheets I've used for more
than a year which retrieve array-entered quotes. These have worked
flawlessly until recently.
> > >
> > > I get a quote, it's just not always today's quote. It's not
unusual to get one from a week ago - or a week ending quote rather than
the current.
> > >
> > > Once I realized the quotes weren't random but valid quotes just
for the wrong day I now retrieve the date in the quote request to ensure
its the day I expect. E.G., today, on Aug 10 it's not unusual to get
quotes returned with an Aug 2 date. The quote is right for Aug 2, it's
just not supposed to be returned on the 10th.
> > >
> > > I use Randy's "refresh" macro and have that as a button in the
spreadsheet to speed re-tries. It usually only takes a couple clicks to
get all the quotes correct. Annoying but fairly quick.
> > >
> > > In one spreadsheet I have 4 separate array-entered quote retrieval
blocks. Interestingly, an array of quotes is either all-right or
all-wrong. But, it's not unusual to have 1 array of quotes be from a
different date than another array of quotes in the same spreadsheet.
> > >
> > > I have IE's cache set to "Every time I visit page" per Randy's
documentation.
> > >
> > > I cannot mimic this failure using IE and downloading CSV quotes.
If I could, I'd submit it to Yahoo!
> > >
> >
>
- 3c.
-
Re: Yahoo Quote failures - work-around?
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Sat Aug 13, 2011 10:05 am (PDT)
You have given me an idea. I use an external query so I can now add d1 to the string and if it shows 2 August, do the fetch again automatically.
From: Paul
Sent: Saturday, August 13, 2011 9:13 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Quote failures - work-around?
Posted a file YahooQuoteFailure.xls that has a work around for the old data sometimes returned by the Yahoo Quote Server.
Here is a short explaination:
Cells M4:s4 use the RCHGetYahooQuotes function to retrieve trade information. Cell P4 is the date of the last trade in text format.
Cell J3 computes the date of the last trading day.
Cell J4 converts the text date to a serial number date and compares it to J3, the last trading day. If the retrieved date is current; it shows the date. If the retrieved date is LESS THAN the last trading date it displays the string "BAD DATA".
I have not figured out how to fix the error yet; but at least I know that the prices are out of date.
Paul
--- In mailto:smf_addin%40yahoogroups. com, "Market Monk" <marketmonk777@ ...> wrote:
>
> Are you getting this "old" data for a single ticker, the same ticker(s), or random tickers?
>
> Are you trying to obtain a single quote (latest day) or multiple days?
>
>
> --- In mailto:smf_addin%40yahoogroups. com, "MikeM" <mikemcq802@ > wrote:
> >
> > I have also been experiencing Yahoo Quote accuracy problems over the past couple weeks. I have a couple spreadsheets I've used for more than a year which retrieve array-entered quotes. These have worked flawlessly until recently.
> >
> > I get a quote, it's just not always today's quote. It's not unusual to get one from a week ago - or a week ending quote rather than the current.
> >
> > Once I realized the quotes weren't random but valid quotes just for the wrong day I now retrieve the date in the quote request to ensure its the day I expect. E.G., today, on Aug 10 it's not unusual to get quotes returned with an Aug 2 date. The quote is right for Aug 2, it's just not supposed to be returned on the 10th.
> >
> > I use Randy's "refresh" macro and have that as a button in the spreadsheet to speed re-tries. It usually only takes a couple clicks to get all the quotes correct. Annoying but fairly quick.
> >
> > In one spreadsheet I have 4 separate array-entered quote retrieval blocks. Interestingly, an array of quotes is either all-right or all-wrong. But, it's not unusual to have 1 array of quotes be from a different date than another array of quotes in the same spreadsheet.
> >
> > I have IE's cache set to "Every time I visit page" per Randy's documentation.
> >
> > I cannot mimic this failure using IE and downloading CSV quotes. If I could, I'd submit it to Yahoo!
> >
>
- 4.
-
Question on getting NYSE New High and Low and differences between Ba
Posted by: "Tze Wei," tzewei_79@yahoo.com.sg tzewei_79
Sat Aug 13, 2011 8:23 am (PDT)
Hi,
From the "RCHGetElementNumber-Element- Definitions. xls", I noticed that there are only 2 sources for NYSE New high and New Low. Barchart and Yahoo. Barchart's new HIgh is $HIGN while it's new low is $LOWN.
I managed to get
=RCHGetElementNumber("$LOWN" , 1154) = 7
=RCHGetElementNumber("$HIGN" , 1153) = 15
=RCHGetElementNumber("http://finance. yahoo.com/ ", 13826) = 31advances
=RCHGetElementNumber("http://finance. yahoo.com/ ", 13827) = 30advances
Does anybody know why barchart and yahoo's New High and New Low are so different?
The other question is, is it possible to get the new high and new low from barchart and yahoo over a period of time?
I noticed we could use RCHGetYahooHistory but the problem is there is no symbol for new high and new low in yahoo's database (maybe there is but I really couldn't find it)
Then problem with barchart...we can't use RCHGetYahooHistory.
Please help.
- 5a.
-
Newbie
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Aug 13, 2011 10:00 am (PDT)
Hi,
I have downloaded a few templates and placed the add in in the required folder.
However, I can't get the results to show up after I input the Ticker. I always get #NAME? .
Are the files outdated?
I am using Win 7 64 bit with office 2010.
Kindly advise please.
Best regards,
Hong
- 5b.
-
Re: Newbie
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Sat Aug 13, 2011 12:24 pm (PDT)
See item 0.2 of the "Links" area of the group.
--- In smf_addin@yahoogroups.com , "wu_ming_sg" <nghongchong@...> wrote:
>
> I have downloaded a few templates and placed the add in in the required folder.
>
> However, I can't get the results to show up after I input the Ticker. I always get #NAME? .
>
> Are the files outdated?
>
> I am using Win 7 64 bit with office 2010.
- 5c.
-
Re: Newbie
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Aug 13, 2011 8:19 pm (PDT)
Hi,
My installation is ok.
Just that the Google templates are not working, is it because that Google has disabled their API?
The yahoo ones such as "SMFLite-RCHGetYahooQuotes-Example" template is working.
Thanks,
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> See item 0.2 of the "Links" area of the group.
>
> --- In smf_addin@yahoogroups.com , "wu_ming_sg" <nghongchong@> wrote:
> >
> > I have downloaded a few templates and placed the add in in the required folder.
> >
> > However, I can't get the results to show up after I input the Ticker. I always get #NAME? .
> >
> > Are the files outdated?
> >
> > I am using Win 7 64 bit with office 2010.
>
- 5d.
-
Re: Newbie
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Aug 13, 2011 8:23 pm (PDT)
The SMFLite templates don't use the add-in. They have their own VBA versions
of the functions.
What do you get with this function:
=RCHGetElementNumber("Version" )
Note that you may need the new element definitions from the "Works in
Progress" folder (*.txt files). Some web sites have changed and required
updates to element definitions.
On Sat, Aug 13, 2011 at 8:18 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> My installation is ok.
>
> Just that the Google templates are not working, is it because that Google
> has disabled their API?
>
> The yahoo ones such as "SMFLite-RCHGetYahooQuotes-Example" template is
> working.
>
- 5e.
-
Re: Newbie
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Aug 13, 2011 8:37 pm (PDT)
Hi,
I see this "Stock Market Functions add-in, Version 2.1.2010.08.02"
I don't see any "work in progress" folder.
Thanks,
Hong
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The SMFLite templates don't use the add-in. They have their own VBA versions
> of the functions.
>
> What do you get with this function:
>
> =RCHGetElementNumber("Version" )
>
> Note that you may need the new element definitions from the "Works in
> Progress" folder (*.txt files). Some web sites have changed and required
> updates to element definitions.
>
> On Sat, Aug 13, 2011 at 8:18 PM, wu_ming_sg <nghongchong@...> wrote:
>
> >
> > My installation is ok.
> >
> > Just that the Google templates are not working, is it because that Google
> > has disabled their API?
> >
> > The yahoo ones such as "SMFLite-RCHGetYahooQuotes-Example" template is
> > working.
> >
>
- 5f.
-
Re: Newbie
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Aug 13, 2011 8:45 pm (PDT)
In the "Files" area of the group.
But new element definitions won't fix #NAME! errors. You need to manually
remove any of the path that is in the function's formulas, as noted in the
"Links" area item I referred you to.
On Sat, Aug 13, 2011 at 8:37 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I don't see any "work in progress" folder.
>
- 6a.
-
How to add Talib in excel 2007 ?
Posted by: "ashu" smartychaps4u@yahoo.com smartychaps4u
Sat Aug 13, 2011 10:01 am (PDT)
Hello sir
I am final year MBA fiance student working on technical analysis I try to add in Tab lib in excel but it didn't show how i try to fix this error and if u have any excel spread sheet for technical analysis kindly sent to me or upload .
- 6b.
-
Re: How to add Talib in excel 2007 ?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Aug 13, 2011 10:03 am (PDT)
You add the TA-Lib add-in pretty much the same way you do the SMF add-in. In
fact, I have the TA-Lib XLL file in the same folder as I have the SMF
add-in.
On Sat, Aug 13, 2011 at 9:34 AM, ashu <smartychaps4u@yahoo.com > wrote:
>
> I am final year MBA fiance student working on technical analysis I try to
> add in Tab lib in excel but it didn't show how i try to fix this error and
> if u have any excel spread sheet for technical analysis kindly sent to me or
> upload .
>
>
- 6c.
-
Re: How to add Talib in excel 2007 ?
Posted by: "ashu" smartychaps4u@yahoo.com smartychaps4u
Sat Aug 13, 2011 11:14 am (PDT)
Sir I am new to this kindly tell me the process I go to add in option do all things but it didnt show on my excel .
please provide the link .
and thanks for your support
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You add the TA-Lib add-in pretty much the same way you do the SMF add-in. In
> fact, I have the TA-Lib XLL file in the same folder as I have the SMF
> add-in.
>
> On Sat, Aug 13, 2011 at 9:34 AM, ashu <smartychaps4u@...> wrote:
>
> >
> > I am final year MBA fiance student working on technical analysis I try to
> > add in Tab lib in excel but it didn't show how i try to fix this error and
> > if u have any excel spread sheet for technical analysis kindly sent to me or
> > upload .
> >
> >
>
- 6d.
-
Re: How to add Talib in excel 2007 ?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Aug 13, 2011 11:17 am (PDT)
Do a search on the message archives -- it's what I would have to do to find
the answer.
On Sat, Aug 13, 2011 at 10:50 AM, ashu <smartychaps4u@yahoo.com > wrote:
> Sir I am new to this kindly tell me the process I go to add in option do
> all things but it didnt show on my excel .
>
> please provide the link .
>
> and thanks for your support
>
- 7a.
-
Incorrect price returned?
Posted by: "jaja3279" karerat@yahoo.com jaja3279
Sat Aug 13, 2011 11:46 am (PDT)
I'm trying to retrieve end-of-week adjusted closing price, one week at a time. In the example below, the date in column A, row 6 is 4/16/2007 (April 16).
=RCHGetYahooHistory("VTI",YEAR( A6),MONTH( A6),DAY(A6) ,YEAR(A6) ,MONTH(A6) ,DAY(A6), "w","A",0)
The returned price is 67.41. Where as on Yahoo the historical price is 68.05.
Can someone explain the descrepency? Am I doing something wrong?
- 7b.
-
Re: Incorrect price returned?
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Sat Aug 13, 2011 12:10 pm (PDT)
67.41 was 4/16/2007
68.05 was 4/20/2007
Apr 20, 2007 147.40 147.64 146.86 147.58 387,800 68.05
Apr 19, 2007 145.78 146.59 145.48 146.28 452,600 67.45
Apr 18, 2007 146.10 146.90 145.94 146.55 847,000 67.58
Apr 17, 2007 146.40 146.79 146.09 146.42 307,600 67.52
Apr 16, 2007 145.35 146.30 145.35 146.19 697,600 67.41
Apr 13, 2007 144.51 144.73 143.85 144.73 235,200 66.74
From: jaja3279
Sent: Saturday, August 13, 2011 1:46 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Incorrect price returned?
I'm trying to retrieve end-of-week adjusted closing price, one week at a time. In the example below, the date in column A, row 6 is 4/16/2007 (April 16).
=RCHGetYahooHistory("VTI",YEAR( A6),MONTH( A6),DAY(A6) ,YEAR(A6) ,MONTH(A6) ,DAY(A6), "w","A",0)
The returned price is 67.41. Where as on Yahoo the historical price is 68.05.
Can someone explain the descrepency? Am I doing something wrong?
- 7c.
-
Re: Incorrect price returned?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Aug 13, 2011 12:23 pm (PDT)
The reported Yahoo adjusted weekly closing price using 2007-04-16 as a
beginning and ending date is $67.41 -- see here:
http://finance.yahoo.com/ q/hp?s=VTI& a=03&b=16& c=2007&d= 03&e=16&f= 2007&g=w
Although I'm baffled why you would retrieve the data one week at a time?
Each request require an additional Internet access.
On Sat, Aug 13, 2011 at 11:46 AM, jaja3279 <karerat@yahoo.com > wrote:
> I'm trying to retrieve end-of-week adjusted closing price, one week at a
> time. In the example below, the date in column A, row 6 is 4/16/2007 (April
> 16).
>
>
> =RCHGetYahooHistory("VTI",YEAR( A6),MONTH( A6),DAY(A6) ,YEAR(A6) ,MONTH(A6) ,DAY(A6), "w","A",0)
>
> The returned price is 67.41. Where as on Yahoo the historical price is
> 68.05.
>
> Can someone explain the descrepency? Am I doing something wrong?
>
- 8a.
-
Re: Finviz Earnings Date
Posted by: "Fred Wright" fredwwright@yahoo.com fredwwright
Sat Aug 13, 2011 3:04 pm (PDT)
Monk,
Take a look at the underlying HTML for the finviz page (in IE right click and click on view source) and then search for the text and related value you find on the screen and then you can use the gettablecell command to pick up the text value that comes after the text. You can get ALL of the finviz fields this way and for one stock it only needs to retrieve the page once so it is reasonably fast.
Good luck.
Fred
_____________________ _________ __
From: Market Monk <marketmonk777@yahoo.com >
To: smf_addin@yahoogroups.com
Sent: Friday, August 12, 2011 8:54 PM
Subject: [smf_addin] Re: Finviz Earnings Date
Thanks, that worked.
Don't know how or why just yet, but it works.
--- In smf_addin@yahoogroups.com , Fred Wright <fredwwright@...> wrote:
>
> Monk,
>
> I useÂ
>
> =RCHGetTableCell("http://www.finviz. com/quote. "&ticker,1,"ashx?t= >Earnings" )
>
>
> to get the finviz earnings data and it seems to work fine.Â
>
>
> Fred
>
>
>
> _____________________ _________ __
> From: Market Monk <marketmonk777@...>
> To: smf_addin@yahoogroups.com
> Sent: Friday, August 12, 2011 7:11 PM
> Subject: [smf_addin] Re: Finviz Earnings Date
>
>
> Â
> Hi Randy,
>
> Just playing around learning the various functions. I will have a look at the function you suggest.
>
> Thanks,
> Monk
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Sorry, you can't. The add-in parser isn't designed to handle their variation
> > of HTML.
> >
> > It should be a fixed string -- why bother extracting it?
> >
> > Have you tried just using the Finviz screener output instead of extracting
> > the data from the web page? For example:
> >
> > =smfGetCSVFile("http://finviz. com/export. ")ashx?v=151& t=GE&c=1, 68
> >
> > There an item in the "Links" area of the group with more detail on the
> > process.
> >
> > On Fri, Aug 12, 2011 at 3:33 PM, Market Monk <marketmonk777@>wrote:
> >
> > >
> > > When I use this code I don't get the title "Earnings" from the Finviz table
> > > for GE (http://www.finviz.com/quote. )ashx?t=ge
> > >
> > > =RCHGetTableCell("http://finviz. com/quote. ashx?t=
> > > "&"GE",""&5,"fullview- ticker",, ,,""&15)
> > >
> > > I get the long string:
> > > BMO = Before Market Open<br>AMC = After Market Close] offsetx=[10]
> > > offsety=[20] delay=[300]
> > >
> > > How do I skip over that to get to "Earnings"?
> > >
> >
>
- 9.
-
=RCHGetElementNumber(B12,25) returns "error" if no symbol in "B12"
Posted by: "Digger" cavesinarizona@cox.net cavesinarizona
Sun Aug 14, 2011 2:30 am (PDT)
the function =RCHGetElementNumber(B12,25) works ok as long as there is a symbol in cell B12 but returns "error" if no symbol in B12. is there a way to avoid this?
Thanks for any help provided
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
4 komentar:
Yahoo Finance Stock Market The Yahoo finance stock market is a place where you can get all of the latest news about Yahoo finance. Yahoo finance features news and other relevant information. The yahoo finance stock market is a place to go when you want to get updated on business news, and other.........................LEARN MORE HERE
Have you heard of the new iCloud terms and conditions?
Join me in playing free games
I have some updates for you here ... Manok Na Pula Mod Apk 5.5 Download, Heymods.Com 18.20 GbWhatsapp, Best Single Parent Dating App, and get Uber Eats Promo Codes
Posting Komentar