New STOCKH formula in Numbers. Assistance please.

Check "My Stock" template as an example for use of STOCKH function. It has "30-Day History" sheet with it.

Note:

• User option-command-N ( File > New from Template Chooser... ) if you set to use specific template for new document in the preferences.
• The template is available only if the Language is set to English. Choose English for the "Language" at the lower-left of Template Chooser if you cannot find it in Personal Finance section.

"However what I would like to do is refer to a cell with a date already in it, and get the close price on that day, not necessarily within the last thirty days. Any idea how to do that?"

Hi bzm,

I can't answer that directly, as My 'current' numbers ie 5.6.2, but I suspect you will find that the 30 day history sheet contains a table with 30 rows of close prices, and the formula returning the close price in each of those thirty rows will include a portion that calculates a specific date with a fixed relation to the current date. Replace that part of the formula with a reference to the cell containing the 'date already in it' and your issue should be solved.

If you want assistance in deciphering the formula, copy it and paste it in a reply here.

Regards,

Barry

bzm wrote:

The problem is that when I either enter in a date in the format xx/xx/xxxx or refer to a date cell, I get an error.

Check the region setting for what is the order is chosen for year, month, and day.

It differs region by region. ( e.g. M/D/Y in US, D/M/Y in Europe, Y/M/D in my region )

Your date string may be invalid if it is not match with the preference setting.

With this reason, I recommend to not use text string as date value. Use the function DATE(y,m,d) to give specific date if necessary.

Also, check the message popping up when you click the red triangle ( error indication ). The message tell you what is wrong.

Did you check the template?

I mentioned it as example, no needs to use it as it is. You can learn how to use the function.

The below shows the part of the "30-Day History" sheet.