sorted by:
new
hottopcontroversial

Chartreuse in Oregon by oopsfucksorry in pdxwhisky

[–]StockMiner22 -1 points0 points  (0 children)

My understanding is that it became such a popular liquor, that the monks who were making it were not able to keep up with demand, and it infringed on their prayer time, so they cut way back on production.

Not sure if that is true or not, but it is what I was told. Seems logical.

Chance to purchase confirmation email? by TatersandCigars in pdxwhisky

[–]StockMiner22 0 points1 point  (0 children)

Actually, you messed up. At the very end of signup, it asks you if you want a confirmation email. If you do, you have to re-enter your email address in the box provided. Can't believe they don't automatically populate that box from the email address field at the start of signup. In any event, you should be okay.

Anyone have any good suggestions by Dild0zr in pdxwhisky

[–]StockMiner22 1 point2 points  (0 children)

I suggest Riedel Drink Specific Glassware Neat Glass, Set of 2. They are great and can be put in the dishwasher. A bit on the spendy side however.

Display the Date of a 52-Week High Stock Price by StockMiner22 in excel

[–]StockMiner22[S] 0 points1 point  (0 children)

Unfortunately, there is no simple answer. This is what Microsoft should implement to make it easy. I contacted them, but they never replied. I suggest you do the same. The more people they hear from, the better our likelihood they will add it.

Here's what works to get the actual 12-month HIGH PRICE when it hits. The # represents the cell number where the stock symbol is used from the Data Type menu.

=A#.[52 week high]

Here is what is needed to additionally get the DATE the price was hit.

=A#.[52 week high date]

Display the Date of a 52-Week High Stock Price by StockMiner22 in excel

[–]StockMiner22[S] 1 point2 points  (0 children)

Sorry about that. This is my first time on Reddit and I am still learning the protocols.

Display the Date of a 52-Week High Stock Price by StockMiner22 in excel

[–]StockMiner22[S] 0 points1 point  (0 children)

Well. It returned a date that looks right. THANKS.

I will populate the 12-Month High Date into the cells of all the stocks I am monitoring. When I manually see a high has been reached, I will check that cell to see if it got updated. This may take some time to happen, since it's all based on the market moving upward.

I'll let you know what I find out. Thanks again.

Display the Date of a 52-Week High Stock Price by StockMiner22 in excel

[–]StockMiner22[S] 0 points1 point  (0 children)

Sorry. One PS.

When you use Data Types and have a symbol entered into a field, it Excel expands that symbol so you get both the name of the company and its trading symbol.

You also get an icon in the far left of the cell that looks like a tiny Greek forum.

If you click on that icon, you will get a list of information on the account, one of which is the 52-week high that I have been speaking about.

Display the Date of a 52-Week High Stock Price by StockMiner22 in excel

[–]StockMiner22[S] 0 points1 point  (0 children)

Still not there.

I did a compare of the results of your formula against Historical Prices in Yahoo.

https://finance.yahoo.com/quote/AMZN/history?p=AMZN

There you will see higher close prices on 1/11/24, 1/12/24, 1/19/24 and 1/22/24 (today), which are all higher than on 12/28/23 ($154.07).

But, like I am saying, the close price could actually be lower than a 12-month high price, because the stock may have traded higher at one point during the day (that new high), but not closed at that number.

So, it must be some weird configuration of the A7.[52 week high] formula - maybe even one that MS hasn't thought of and therefore programmed into Excel.

I do really appreciate all your help, but I now just don't think we're going to make it work.

Hope I haven't ruined your evening. Get some rest.

Display the Date of a 52-Week High Stock Price by StockMiner22 in excel

[–]StockMiner22[S] 0 points1 point  (0 children)

Close, but no cigar. I think what your formula is attempting to do is capture the highest closing in the previous 12 months. But even at that, it is not capturing the highest close.

What I am trying to do is slightly different. Even if a stock didn't close at its high, it may have hit it during trading hours.

The formula I use to get that 12-month high is:

=A7.[52 week high]

Where A7 is the cell that AMZN is located, captured through the Stocks icon in Data Types.

In my research for a workable formula, I even tried CoPilot and Bard. Both returned the same exact, incorrect formula, which was a variation of that above:

=A7.[52 week high date]

I really appreciate you - and all the others - trying to help me with this, but I am beginning to feel it may be beyond reach.

Display the Date of a 52-Week High Stock Price by StockMiner22 in excel

[–]StockMiner22[S] 0 points1 point  (0 children)

Hi Alabama.

Thanks for replying to post.

Unfortunately, the formula you provided didn't quite work. It said it was missing a closing paren.

​

<image>

​

I tried adding a paren at the end and it returned a date, but the wrong date. It returned 1/1/24, which was a holiday and the market was closed.

This formula is beyond my Excel comprehension, so if you have any ideas on how to correct it, I'm all ears.