How to extract just the historical open/close for a given day

[bullishtech]

I am trying to populate a spreadsheet to track the profitability of a
spread model that I have created in real-time. I am basically paper-
trading this thing and want to use Google Docs to help me vet its
performance prior to plopping any money down. One thing I need to
figure out is how to place the open and/or close of a stock on a given
day. I have tried using the following:

=googlefinance(SPY,"open","3/2/2012")

with no luck. I am actually using cells to populate the ticker and
date but I think you get the idea.

This function call populates four cells instead of just one. I simply
want one cell to be populated with the specified open or close for the
given date. Is this possible? If so, how?

[John Gilmour]

Good Luck!

I would also like to know. I messed with this function some months ago and finally gave up. Even the documentation Google provided is contradictory and incomplete.

J

John Gilmour
www.JcGilmour.ca
cell: 905-964-0614
phone: 905-346-3488

Computer Service, Sales & More

Special Dell P4 2.8, DDR2, SATA  XP pro, $199 no tax!

--
You received this message because you are subscribed to the Google Groups "Google Finance" group.
To post to this group, send email to google-...@googlegroups.com.
To unsubscribe from this group, send email to google-financ...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-finance?hl=en.

[frank1828]

I'm using SI in cell A1 and successfully pulling the close for a date range:

 

=GoogleFinance(+A1,"close","6/1/2011","12/31/2011","daily")

 

When I use SPY in A1, there is no data.

 

When I use INDEXSP:.INX, I see the data for the cash S&P 500 index.

 

When I use NYSE:SPY  in A1, I see the data for SPY.

[John Gilmour]

this and variations was what I attempted but no luck at all.

I too, simply wanted the previous days close

=GoogleFinance("rimm"; "close, 01/12/2012")  

John Gilmour
www.JcGilmour.ca
cell: 905-964-0614
phone: 905-346-3488

Computer Service, Sales & More

Special Dell P4 2.8, DDR2, SATA  XP pro, $199 no tax!

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/aBfq0ZOOAoQJ.

[frank1828]

First you have two syntax errors:

 

=GoogleFinance("rimm"; "close, 01/12/2012")  

 

should be:

 

=GoogleFinance("rimm"; "close", "01/12/2012")  

 

and if that still does not work try adding the exchange acrynoym in front of the stock symbol.

On Wednesday, March 7, 2012 6:37:57 PM UTC-6, bullishtech wrote:

[John Gilmour]

Thanks Frank!

is there some way get the previous day's close without having to fudge with the date? In other words, to have the last close date correct regardless of whether it was over a weekend or a weekday?

John

John Gilmour
www.JcGilmour.ca
cell: 905-964-0614
phone: 905-346-3488

Computer Service, Sales & More

Special Dell P4 2.8, DDR2, SATA  XP pro, $199 no tax!

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/wKuzERRgLGUJ.

[Ryan Wendel]

So... has anyone provided a method to produce a single cell output for the o/h/l/c of a given date?

[John Gilmour]

I have answered my last question regarding previous day's close 

=GoogleFinance("symbol"; "change") 

Good day to all!

John Gilmour
www.JcGilmour.ca
cell: 905-964-0614
phone: 905-346-3488

Computer Service, Sales & More

Special Dell P4 2.8, DDR2, SATA  XP pro, $199 no tax!

On Fri, Mar 9, 2012 at 9:44 AM, Ryan Wendel <ryan....@gmail.com> wrote:

So... has anyone provided a method to produce a single cell output for the o/h/l/c of a given date?

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

[frank1828]

<<

should be:

 

=GoogleFinance("rimm"; "close", "01/12/2012") >>

[Ryan Wendel]

Frank,

Thanks for the input but that produces four cells of output. I've attached my results.

[frank1828]

OK. So 16.44 is in one cell. Is that all you want? just reference that cell somewhere and you have it elsewhere. Might want to post an example of what you really want. You've trivialized that problem too much.

On Wednesday, March 7, 2012 6:37:57 PM UTC-6, bullishtech wrote:

[Ryan Wendel]

An example (or two)...

This function call populates four cells instead of just one. I simply
want one cell to be populated with the specified open or close for the
given date.

I am talking about putting something like =googlefinance(EIX,"open","3/2/2012") in G2 and =googlefinance(GXP,"open","3/2/2012") in H2 and having _one_ cell populate with _just_ the open price.

I am guessing this is just something the function call does not do. I would prefer not to have to reference another cell.

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/27fPn7FW-LAJ.

[frank]

On Wednesday, March 7, 2012 6:37:57 PM UTC-6, bullishtech wrote:

[frank]

<< I would prefer not to have to reference another cell. >>

 

You realize that that is the value of using a spreadsheet don't you? Nothing to do with Google Docs spreadsheet or Microsoft Excel. GoogleFinance() does not work the way you want it to. So, buy Google and make the demand to change the function.

 
On Friday, March 9, 2012 10:02:35 PM UTC-6, bullishtech wrote:

An example (or two)...

This function call populates four cells instead of just one. I simply
want one cell to be populated with the specified open or close for the
given date.

I am talking about putting something like =googlefinance(EIX,"open","3/2/2012") in G2 and =googlefinance(GXP,"open","3/2/2012") in H2 and having _one_ cell populate with _just_ the open price.

I am guessing this is just something the function call does not do. I would prefer not to have to reference another cell.

On Fri, Mar 9, 2012 at 7:19 PM, wrote:

OK. So 16.44 is in one cell. Is that all you want? just reference that cell somewhere and you have it elsewhere. Might want to post an example of what you really want. You've trivialized that problem too much.

On Wednesday, March 7, 2012 6:37:57 PM UTC-6, bullishtech wrote:

I am trying to populate a spreadsheet to track the profitability of a
spread model that I have created in real-time. I am basically paper-
trading this thing and want to use Google Docs to help me vet its
performance prior to plopping any money down. One thing I need to
figure out is how to place the open and/or close of a stock on a given
day. I have tried using the following:

=googlefinance(SPY,"open","3/2/2012")

with no luck. I am actually using cells to populate the ticker and
date but I think you get the idea.

This function call populates four cells instead of just one. I simply
want one cell to be populated with the specified open or close for the
given date. Is this possible? If so, how?

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/27fPn7FW-LAJ.

To post to this group, send email to google-finance@googlegroups.com.
To unsubscribe from this group, send email to google-finance+unsubscribe@googlegroups.com.

On Fri, Mar 9, 2012 at 7:19 PM, frank1828 <> wrote:

OK. So 16.44 is in one cell. Is that all you want? just reference that cell somewhere and you have it elsewhere. Might want to post an example of what you really want. You've trivialized that problem too much.

On Wednesday, March 7, 2012 6:37:57 PM UTC-6, bullishtech wrote:

I am trying to populate a spreadsheet to track the profitability of a
spread model that I have created in real-time. I am basically paper-
trading this thing and want to use Google Docs to help me vet its
performance prior to plopping any money down. One thing I need to
figure out is how to place the open and/or close of a stock on a given
day. I have tried using the following:

=googlefinance(SPY,"open","3/2/2012")

with no luck. I am actually using cells to populate the ticker and
date but I think you get the idea.

This function call populates four cells instead of just one. I simply
want one cell to be populated with the specified open or close for the
given date. Is this possible? If so, how?

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/27fPn7FW-LAJ.

To post to this group, send email to google-finance@googlegroups.com.
To unsubscribe from this group, send email to google-finance+unsubscribe@googlegroups.com.

On Fri, Mar 9, 2012 at 7:19 PM, frank1828 <> wrote:

OK. So 16.44 is in one cell. Is that all you want? just reference that cell somewhere and you have it elsewhere. Might want to post an example of what you really want. You've trivialized that problem too much.

On Wednesday, March 7, 2012 6:37:57 PM UTC-6, bullishtech wrote:

I am trying to populate a spreadsheet to track the profitability of a
spread model that I have created in real-time. I am basically paper-
trading this thing and want to use Google Docs to help me vet its
performance prior to plopping any money down. One thing I need to
figure out is how to place the open and/or close of a stock on a given
day. I have tried using the following:

=googlefinance(SPY,"open","3/2/2012")

with no luck. I am actually using cells to populate the ticker and
date but I think you get the idea.

This function call populates four cells instead of just one. I simply
want one cell to be populated with the specified open or close for the
given date. Is this possible? If so, how?

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/27fPn7FW-LAJ.

To post to this group, send email to google-finance@googlegroups.com.
To unsubscribe from this group, send email to google-finance+unsubscribe@googlegroups.com.

On Fri, Mar 9, 2012 at 7:19 PM, frank1828 <> wrote:

OK. So 16.44 is in one cell. Is that all you want? just reference that cell somewhere and you have it elsewhere. Might want to post an example of what you really want. You've trivialized that problem too much.

On Wednesday, March 7, 2012 6:37:57 PM UTC-6, bullishtech wrote:

I am trying to populate a spreadsheet to track the profitability of a
spread model that I have created in real-time. I am basically paper-
trading this thing and want to use Google Docs to help me vet its
performance prior to plopping any money down. One thing I need to
figure out is how to place the open and/or close of a stock on a given
day. I have tried using the following:

=googlefinance(SPY,"open","3/2/2012")

with no luck. I am actually using cells to populate the ticker and
date but I think you get the idea.

This function call populates four cells instead of just one. I simply
want one cell to be populated with the specified open or close for the
given date. Is this possible? If so, how?

--

You received this message because you are subscribed to the Google Groups "Google Finance" group.

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/27fPn7FW-LAJ.

To post to this group, send email to google-finance@googlegroups.com.
To unsubscribe from this group, send email to google-finance+unsubscribe@googlegroups.com.

[frank]

You've trivialized your question so much it can not be done, but a bigger question of what you really ultimately want probably can be done. You can get the most recent close or open without using a date in a single cell OR historical data using a date range output to multiple cells -- I have spreadsheets that do both. Historical data that produces more than a single cell with open or close for a single date is not possible. What you've asked for can not be done. What you want probably can be done. Just not asking the question broadly enough.

 

On Saturday, March 10, 2012 5:42:18 PM UTC-6, bullishtech wrote:

Your reply is about as retarded as they come. what an ass. please kindly remove yourself from my thread.

no, seriously... back away from the keyboard, jackass

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/JCjm1VlzQYMJ.

[Ryan Wendel]

Your reply is about as retarded as they come. what an ass. please kindly remove yourself from my thread.

no, seriously... back away from the keyboard, jackass

To view this discussion on the web visit https://groups.google.com/d/msg/google-finance/-/JCjm1VlzQYMJ.

To post to this group, send email to google-...@googlegroups.com.
To unsubscribe from this group, send email to google-financ...@googlegroups.com.