New Excel STOCKHISTORY Function - Definitive Guide - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Arnoldas
Finaly!!! Thank you very much for this video!
I was searching how to get portfolio value chart which is filling up automatically. This video made me shout Eureka!!!
I guess I can choose the date I started buying stocks for my portfolio, enter stockhistory function to get prices for each stock which are in horizontal order. For dates which are in vertical order I can use sequence function as well. Like this I will get prices for each stock I own. Next step is to create a column to get share quantity at each price. I guess this should be entered manually. And then on a new column which is stock value, just need to multiply prieces each day with share quantity each day.
I hope my interpretation of second part is right. Or is there any other way to get daily portfolio value chart? I tried to search it on the internet for so many days now and there is no info about it. And actually you are right! You are the first one to explain this method.
Once again, thank you very much and hopefully will get an answer to my question on this comment board, or even in a new video explaining that. :-
reply
Finaly!!! Thank you very much for this video!
I was searching how to get portfolio value chart which is filling up automatically. This video made me shout Eureka!!!
I guess I can choose the date I started buying stocks for my portfolio, enter stockhistory function to get prices for each stock which are in horizontal order. For dates which are in vertical order I can use sequence function as well. Like this I will get prices for each stock I own. Next step is to create a column to get share quantity at each price. I guess this should be entered manually. And then on a new column which is stock value, just need to multiply prieces each day with share quantity each day.
I hope my interpretation of second part is right. Or is there any other way to get daily portfolio value chart? I tried to search it on the internet for so many days now and there is no info about it. And actually you are right! You are the first one to explain this method.
Once again, thank you very much and hopefully will get an answer to my question on this comment board, or even in a new video explaining that. :-
reply
Sonak
thank you for the video, very very informative, but i have an issue if you can help me, 1. can you help me get the data starting with the latest stock price first, 2. i tried getting data for say 10 stocks for 10 years but some of the stocks in the list are listed for less than 10 years than the price and date did not match is there a way to correct this, thanks in advance.
reply
thank you for the video, very very informative, but i have an issue if you can help me, 1. can you help me get the data starting with the latest stock price first, 2. i tried getting data for say 10 stocks for 10 years but some of the stocks in the list are listed for less than 10 years than the price and date did not match is there a way to correct this, thanks in advance.
reply
Gabriel
This is great! Just wanted to ask, is it possible to obtain % change in prices for the last month or 1 year for example. Entering a stock into any cell allows us to obtain information such as high, low, % change e.t.c. However, the % change applies to todays change. I would like to obtain the % change over the last month. Is this possible?
reply
This is great! Just wanted to ask, is it possible to obtain % change in prices for the last month or 1 year for example. Entering a stock into any cell allows us to obtain information such as high, low, % change e.t.c. However, the % change applies to todays change. I would like to obtain the % change over the last month. Is this possible?
reply
David
Hi Mynda, very nicely done. I want to know if the StockHistory function can incorporate the array and sequence for multiple stock prices over the same periods. I don't want the date displayed for each stock but just a dynamic date in column, Stock Price Headers in Rows and prices for each below. Tx
reply
Hi Mynda, very nicely done. I want to know if the StockHistory function can incorporate the array and sequence for multiple stock prices over the same periods. I don't want the date displayed for each stock but just a dynamic date in column, Stock Price Headers in Rows and prices for each below. Tx
reply
TSSC
Hi, I see that you have at least one unreleased rich data type, namely -Organization- (visible at 4:53). Can you please introduce this/these in a video? The recording shows: Organization, Stocks, Geography - and the expand button. This makes me curious. Have any other data types been added?
reply
Hi, I see that you have at least one unreleased rich data type, namely -Organization- (visible at 4:53). Can you please introduce this/these in a video? The recording shows: Organization, Stocks, Geography - and the expand button. This makes me curious. Have any other data types been added?
reply
TheSardOz
Thank you for another great video, I would love to see a video to create a dashboard for intraday trading, to analysis performance, like p/l , expectancy, win loss ratio.. etc! I have been finding hard to organize the data from IRESS to get those metrics!
reply
Thank you for another great video, I would love to see a video to create a dashboard for intraday trading, to analysis performance, like p/l , expectancy, win loss ratio.. etc! I have been finding hard to organize the data from IRESS to get those metrics!
reply
Jag
Hi there , There was certain formulation that i wanted to learn. It was about creating a master sheet and flowing that info into various sheets . I have created one but couldnt find the formulation. Would you be able to help if i email the details ? Thank you
reply
Hi there , There was certain formulation that i wanted to learn. It was about creating a master sheet and flowing that info into various sheets . I have created one but couldnt find the formulation. Would you be able to help if i email the details ? Thank you
reply
LastDance
Hi Mynda, great video as always! It seems that STOCKHISTORY function would show #N/A when there is a whole day trading halt on a certain date. Any ideas to skip the trading halt date or hide it as the #N/A value makes calculating MA a bit troublesome?
reply
Hi Mynda, great video as always! It seems that STOCKHISTORY function would show #N/A when there is a whole day trading halt on a certain date. Any ideas to skip the trading halt date or hide it as the #N/A value makes calculating MA a bit troublesome?
reply
itech
Hi, thankyou for the video, but at 9:00 i copied that same code and it did not display 30 days of prices from current date, but only the current days price... Ive checked it probably 10 times now and don't know why it won't work
reply
Hi, thankyou for the video, but at 9:00 i copied that same code and it did not display 30 days of prices from current date, but only the current days price... Ive checked it probably 10 times now and don't know why it won't work
reply
Aaron
Great video! I'm trying to get data inputed for the last month, 3m, 6m, year. Is there a way to take out weekends and holidays from creating errors in the history (for stocks only traded on weekdays and non holidays?
reply
Great video! I'm trying to get data inputed for the last month, 3m, 6m, year. Is there a way to take out weekends and holidays from creating errors in the history (for stocks only traded on weekdays and non holidays?
reply
Add a review, comment
Other channel videos
