Sabtu, 29 Desember 2012

[smf_addin] Digest Number 2450

12 New Messages

Digest #2450
1a
Re: Parsing Yahoo CSV Data by "Stock Jock" stockjocktrader
1b
Re: Parsing Yahoo CSV Data by "Randy Harmelink" rharmelink
1c
Re: Parsing Yahoo CSV Data by "Stock Jock" stockjocktrader
2a
RCHGetTableCell and uk.moneycentral.msn.com by "max854@ymail.com" max854@ymail.com
2c
Re: RCHGetTableCell and uk.moneycentral.msn.com by "max854@ymail.com" max854@ymail.com
3a
3b
Re: Troubleshooting Non-Working Function by "Randy Harmelink" rharmelink
4a
Curious error with ^IXIC by "Pete" petekoch
4b
4c
4d
Re: Curious error with ^IXIC by "Randy Harmelink" rharmelink

Messages

Fri Dec 28, 2012 8:26 am (PST) . Posted by:

"Stock Jock" stockjocktrader


Can you recommend any reading material that specifically addresses the
issue of parsing csv files like you have done. I'm reading through your
code to understand how you have done it. Is your method unique or is
there something I can read about it?

====================================================
--- In smf_addin@yahoogroups.com, Randy Harmelink wrote:
>
> I haven't uploaded the version of the add-in with the new function...
>
> But really, all it does is create the URL for the API feed and then
call
> the smfGetTagContent() function. For example, using the URL I gave
you, if
> you wanted to extract the Last Traded Price:
>
> =smfGetTagContent(_URL_,"LastTradePriceOnly")
>
> On Thu, Dec 27, 2012 at 10:17 PM, Stock Jock stockjocktrader@...wrote:
>
> > Yahoo used to have a webpage with a complete list of all their
database
> > tables: http://www.datatables.org/ They must have moved it. I was
> > thinking of including the news on each symbol in my database, but I
don't
> > know where the Yahoo news table is anymore.
> >
> > So is your new function available in your addin?
> >
>

Fri Dec 28, 2012 12:31 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I learned most of my programming from looking at examples and doing trial
and error. Google has helped that process a lot. My first exposure was back
in the 1960's -- I took home the IBM Reference Manual and User's Guide for
BASIC, and read them cover to cover.

So I'm home-grown. :)

One technique I use a lot is to simply list the necessary steps that need
to be done, as comments, and then flesh out the programming code for each
of those steps. Leaving the comments in for future reference.

I did a lot of parsing of data back in the 1980's -- I used to download all
the raw data in report formats, then run my parser on it to extract the
data and load it into databases. Back then, I used a great product called
TAS (Technical Analysis Scanner), which would read all of those databases
and do technical and fundamental screening and filtering. I'm so glad I no
longer have to do all that work -- maintaining those databases was a
nightmare.

On Fri, Dec 28, 2012 at 9:26 AM, Stock Jock <stockjocktrader@yahoo.com>wrote:

> Can you recommend any reading material that specifically addresses the
> issue of parsing csv files like you have done. I'm reading through your
> code to understand how you have done it. Is your method unique or is there
> something I can read about it?
>

Fri Dec 28, 2012 2:27 pm (PST) . Posted by:

"Stock Jock" stockjocktrader


Well, you're a damn good programmer for being home grown. That's how I
learned too. My projects at work dealt with so much data and the IT
programmers at the place where I worked must have been hard to work
with, because my management avoided dealing with them. So I had to learn
from examples and develop my own databases by searching MS Access forums
and Googling. These days I can't find a program that I like to do my
market analysis; so I'm back to doing my own customizing. I'd use Excel,
but real time data and using indicator code to analyze trends doesn't
seem to fit in; so the best way to handle all that data is a database. I
don't see any forums that do VBA programming for market data in MS
Access, but yours is one of the few that specializes in this for Excel.

I know I can't ask any questions on Access in this forum, but the VBA is
essentially the same. Parsing data is a necessary operation, whether its
in Excel or Access. I'm trying to get information in whatever way I can
as you have done in your earlier days. After I retired, I started a
database for my trading journal using Yahoo historical data and now I'm
modifying it to include a bulk quantity of real time data with indicator
analysis. Now, it's back to Googling and VBA forums to adapt sample
code to my project. This project is for my personal use to help me in my
trading decisions. I see much of your code is very sophisticated and
useful, but the addin is not compatible to Access, otherwise I'd use it.
That's why I'm trying to reuse your code in Access. For a home grown
programmer, you've really Excelled.

----------------------------------------------------------

--- In smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> I learned most of my programming from looking at examples and doing
trial and error. Google has helped that process a lot. My first exposure
was back in the 1960's -- I took home the IBM Reference Manual and
User's Guide for BASIC, and read them cover to cover.

So I'm home-grown. :)

Fri Dec 28, 2012 12:02 pm (PST) . Posted by:

"max854@ymail.com" max854@ymail.com

Hi,

This is an excellent addin for Excel. It saves me loads of time.

I am having an issue with the function RCHGetTableCell on uk.moneycentral.msn.com.

This function:

RCHGetTableCell("http://uk.moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=CPI&stmtView=Ann&lstStatement=Balance",1,"Total Common Shares Outstanding")

returns the correct value "2905.71".

This function, which is exactly the same except for a different ticker symbol (ADM), returns "Error":

RCHGetTableCell("http://uk.moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=ADM&stmtView=Ann&lstStatement=Balance",1,"Total Common Shares Outstanding")

Both internet addresses appear to work correctly when cut and pasted into the browser. I have the same issue across about 350 ticker symbols where about a third return dont return "Error".

Your help is appreciated.

Max

Fri Dec 28, 2012 12:38 pm (PST) . Posted by:

"Randy H" rharmelink



I'm not sure what to tell you -- I cut and pasted both formulas below and they worked fine for me.

However, I did not get the 2905.71 you mention -- I got 613.4, which is what I see when I visit the web page.

--- In smf_addin@yahoogroups.com, "max854@..." <max854@...> wrote:
>
> I am having an issue with the function RCHGetTableCell on uk.moneycentral.msn.com.
>
> This function:
>
> RCHGetTableCell("http://uk.moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=CPI&stmtView=Ann&lstStatement=Balance",1,"Total Common Shares Outstanding")
>
> returns the correct value "2905.71".
>
> This function, which is exactly the same except for a different ticker symbol (ADM), returns "Error":
>
> RCHGetTableCell("http://uk.moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=ADM&stmtView=Ann&lstStatement=Balance",1,"Total Common Shares Outstanding")
>
> Both internet addresses appear to work correctly when cut and pasted into the browser. I have the same issue across about 350 ticker symbols where about a third return dont return "Error".

Fri Dec 28, 2012 1:08 pm (PST) . Posted by:

"max854@ymail.com" max854@ymail.com

Thanks for the fast reply.

After your message I tried restarting Excel, my browser and then finally my PC. That fixed it. Maybe it was some caching problem.

Thanks for the great addin.

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
>
>
> I'm not sure what to tell you -- I cut and pasted both formulas below and they worked fine for me.
>
> However, I did not get the 2905.71 you mention -- I got 613.4, which is what I see when I visit the web page.
>
> --- In smf_addin@yahoogroups.com, "max854@" <max854@> wrote:
> >
> > I am having an issue with the function RCHGetTableCell on uk.moneycentral.msn.com.
> >
> > This function:
> >
> > RCHGetTableCell("http://uk.moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=CPI&stmtView=Ann&lstStatement=Balance",1,"Total Common Shares Outstanding")
> >
> > returns the correct value "2905.71".
> >
> > This function, which is exactly the same except for a different ticker symbol (ADM), returns "Error":
> >
> > RCHGetTableCell("http://uk.moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=ADM&stmtView=Ann&lstStatement=Balance",1,"Total Common Shares Outstanding")
> >
> > Both internet addresses appear to work correctly when cut and pasted into the browser. I have the same issue across about 350 ticker symbols where about a third return dont return "Error".
>

Fri Dec 28, 2012 12:35 pm (PST) . Posted by:

"rjemery7" rjemery7

I have a master spreadsheet in which the function "=RCHGetElementNumber("T", 13863)", meant to retrieve Company Name, is not working. That same command put into a fresh workbook works just fine.

What could be the cause of this problem? How might I track down the cause? What suggestions do you have for overcoming the problem?

Fri Dec 28, 2012 3:52 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Offhand, I'm at a loss. But you haven't explained what "not working" means?

Is it possible the "master spreadsheet" is pointing to an older version of
the add-in -- do you have two different copies installed? That element
number uses a new method of element definition.

On Fri, Dec 28, 2012 at 1:35 PM, rjemery7 <rjemery@gmail.com> wrote:

> I have a master spreadsheet in which the function
> "=RCHGetElementNumber("T", 13863)", meant to retrieve Company Name, is not
> working. That same command put into a fresh workbook works just fine.
>
> What could be the cause of this problem? How might I track down the
> cause? What suggestions do you have for overcoming the problem?
>

Fri Dec 28, 2012 2:07 pm (PST) . Posted by:

"Pete" petekoch

I have an array to retrieve Date/Open/High/Low/Close via RCHGetYahooQuotes for 12 stocks and 2 indices, ^GSPC and ^IXIC.

Beginning about a week ago and every day since then, the date returned for ^IXIC is always 12/20/2012, the close for the index is always 3050.39, and the Open, High and Low are always zeros. However, the data returned for the 12 stocks and for ^GSPC is correct. ^IXIC always worked previously and my sheet was last modified back in the first week of December.

When retrieving weekly data for a list of stocks, funds and indices using RCHGetYahooHistory (array-entered), all is correct.

In a new sheet, when I enter '=RCHGetYahooQuotes("^IXIC","l1")'into a single cell, it returns that same value of 3050.39, which was the correct closing price on 12/20/12. When I substitute "^GSPC" in the same cell, TODAY's correct closing price is returned, but when I enter "^DJI", 'Missing Symbols List" is returned. I don't think we are dealing with a repeat of the DJI issue.

Ideas ? I don't think this is just a plain old brain-fart by moi.

Fri Dec 28, 2012 2:12 pm (PST) . Posted by:

"Pete" petekoch


I neglected to mention: Version 2.1.2012.02.02

Fri Dec 28, 2012 2:49 pm (PST) . Posted by:

"Pete" petekoch

This is definitely NOT an SMF issue.

An hour ago, MyYahoo! page showed today's O/H/L/C for NASDAQ/^IXIC.

Now, an hour and 40 minutes after the close, MyYahoo's Market Summary section showed the infamous 3050.39, and when I clicked on 'Nasdaq' it also showed 3050.39 with zeros for O/H/L. When I returned to Market Summary (via my browser), today's numbers magically appeared. When I clicked again on 'Nasdaq', that page also showed the correct numbers.

And, no, I'm not making this up.

Since this is NOT an SMF problem, I'm just wasting bandwith, but I am curious what would cause this only for ^IXIC. Must be a licensing/data feed issue on Yahoo's part.

Fri Dec 28, 2012 2:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Just a plain old Yahoo problem -- here's the standard file they produce
JUST for ^IXIC (from the link on the quotes page):

http://download.finance.yahoo.com/d/quotes.csv?s=%5EIXIC&f=sl1d1t1c1ohgv&e=.csv

...which currently returns:

"^IXIC",3050.39,"12/20/2012","5:16pm",0.00,0.00,0.00,0.00,0

It could be they have an issue with whoever feeds them the data for the
current quotes file. I'd let Yahoo know.

On Fri, Dec 28, 2012 at 3:06 PM, Pete <petekoch@yahoo.com> wrote:

> I have an array to retrieve Date/Open/High/Low/Close via RCHGetYahooQuotes
> for 12 stocks and 2 indices, ^GSPC and ^IXIC.
>
> Beginning about a week ago and every day since then, the date returned for
> ^IXIC is always 12/20/2012, the close for the index is always 3050.39, and
> the Open, High and Low are always zeros. However, the data returned for the
> 12 stocks and for ^GSPC is correct. ^IXIC always worked previously and my
> sheet was last modified back in the first week of December.
>
> When retrieving weekly data for a list of stocks, funds and indices using
> RCHGetYahooHistory (array-entered), all is correct.
>
> In a new sheet, when I enter '=RCHGetYahooQuotes("^IXIC","l1")'into a
> single cell, it returns that same value of 3050.39, which was the correct
> closing price on 12/20/12. When I substitute "^GSPC" in the same cell,
> TODAY's correct closing price is returned, but when I enter "^DJI",
> 'Missing Symbols List" is returned. I don't think we are dealing with a
> repeat of the DJI issue.
>
> Ideas ? I don't think this is just a plain old brain-fart by moi.
>

Tidak ada komentar:

Posting Komentar