Видео

there are strategies that could be put in place for solid gains regardless of economy situation, but such execution is usually carried out by an investment specialist.

Working with an asset manager has been a game-changer for me. They provided invaluable insights and tailored strategies that aligned perfectly with my risk tolerance and financial objectives. With their support, I've seen significant growth in my investments and gained confidence in my financial future.

This is definitely considerable! think you could suggest any professional/advisors i can get on the phone with? i'm in dire need of proper portfolio allocation.

CFA NICOLE ANASTASIA PLUMLEE is the licensed advisor I use. Just research the name. You’d find necessary details to work with a correspondence to set up an appointment.

Wow, her track record looks really good from what I found online.i just messaged her, Thanks for the info

Keeping some gold is usually a wise decision. You would be better off keeping away from equities for a bit or, even better, seeking advice from an expert given the current market conditions and everything that is at risk with the current economy.

You have a very valid point, I started investing on my own and for a long time, the market was really ripping me off. I decided to hire a CFA, even though I was skeptical at first, and I beat the market by more than 9%. I thought it was a fluke until it happened two years in a row, and so I’ve been sticking to investing via an analyst

Could you possibly recommend a CFA you've consulted with?

My CFA NICOLE ANASTASIA PLUMLEE a renowned figure in her line of work. I recommend researching her credentials further... She has many years of experience and is a valuable resource for anyone looking to navigate the financial market..

Thank you for saving me hours of back and forth investigation into the markets. I simply copied and pasted her full name into my browser, and her website came up first in search results. She looks flawless.

That formula in I2 cell in `Custom Formula` tab is =QUERY(SORT(GOOGLEFINANCE("NSE:"&B2,"price",TODAY()-365,TODAY(),"DAILY"),1,FALSE),"Select Col2 LABEL Col2 ''",1)

The GOOGLEFINANCE function provides values of various parameters. support.google.com/docs/answer/3093281?hl=en This Stochastic Oscillator is a derived quantity. So, we need to calculate it. I would work on it and let you know.

In this, we rely on output of Screener website. If Screener website has changed their UI (moving table up or down), then exact same will not work. Therefore, I advise to use the process of framing formula rather than copy paste exact formula.

@@ApplyIT2021 I tried the formula but for the large amount of data it shows Loading Error only.

Thank you for your feedback. I feel happy for that.

Copy it from the cell and paste as value should work.

This is about Google Sheets, available freely if we have Gmail account. Are you trying to use them in Excel program?

For this specifically, I have not shared Google Sheets as if Screener website changes their UI, the exact same formula will not work, and then it will appear that the sheet is not working. Therefore I paste my earlier response for your quick reference. I advise to use the process of framing formula rather than copy paste XPath location shown in the video. As screener might have changed their UI, so XPath locations might have changed. If that is the case, we need to update XPath locations for one record and need to make them working; then copy paste those working formula for all other scrips. It should work. Let me know it works or not.

BSE does not generate URL for a scrip directly. One possible approach, though time consuming, is to find out URLs of few scrips (in which we are interested) manually, and then to use them using VLOOKUP at the place where it is required. Will explore generating URL dynamically for BSE and let you know.

Did it help you?

There is no direct way to get Intraday data. For intraday, we can get data of current situation, not of whole day.

You may find this link so that you can see formula docs.google.com/spreadsheets/d/1HXdO0egXDrGsVxsUfNDBoFdxJlEMsy4SYp_CGMurUvg/edit?usp=sharing

@@ApplyIT2021 Guess i have an issue with my google spreadsheet ,including in your sheet on google drive i am copy pasting what @sharewasi3438 has posted in the comments section clearly i think this will add more punch to your otherwise engaging videos 1) Stock breaking out form X days high/low 2)Volume increase of particular day above the average volume of X number of days. 3)Stocks with increase in price along with increase in volume for last 2 /3 and 4 days 4)also some stocks trade on BSE , BSE-SME ,NSE ,NSE-SME how to combine on to same sheet google finance function is not helping * note am a novice at programming In anticipation of your reply Rgards

Most welcome!

Will explore it.

Comma (,) it is to be placed at the correct position It is to be written as '-6,012 and not '-60,12

@@ApplyIT2021 thanks for a prompt answer 😍 but I replaced comma not from hand, have done it with "find and replace" option. Could it have made it wrong way? 😳

Formula not working for me

=IF(B2<>"",MAX(INDEX(GOOGLEFINANCE(CONCAT("NSE:",B2),"high", DATE(1999,1,1), TODAY()),,2)), "")

=IF(B2<>"",MAX(INDEX(GOOGLEFINANCE(CONCAT("NSE:",B2),"high", DATE(1999,1,1), TODAY()),,2)), "")

Thank you! Cheers!

Okay. Will solve it.

Thanks for the sub! Thank you for feedback!

It depends on what data Screener provides. If Screener does not provide certain data for certain scrips, it may not be possible to get that data in Google Sheets.

=INDEX(SORT(((GOOGLEFINANCE(CONCAT("NSE:",B3),"high",DATE(1999,1,1),TODAY()))),2,FALSE),2,2) Replace B3 by scrip name as per NSE

Error -wrong number of argument to concat expected 2 arguments but received I argument

@@varsangrathavi5407 CONCAT("NSE:",B3)

Need to check. All formula of Google Sheet may not be supported in Excel

Great

Bienvenido

Thank you for your feedback. Will explore and let you know.

Sure

How to Get Dates of all Time High Price automatically ruclips.net/video/hzi9OvzMEhY/видео.html

Will explore and let you know.

Thank you for your feedback. Will look into this.

Thank you for your feedback. And also suggestion of the topic on heat map and industry PE.

The following formula should work; we need to replace value of Col1 =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Promoters +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='FIIs +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='DIIs +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Public +',0) =QUERY(IMPORTHTML(C4, "TABLE", 10,), "select * where Col1='Others +',0)

Thank you for your feedback.

Google Sheets IMPORT functions do not allow to read JSON data provided by any API (for simplicity from web URL). API connector extensions does the work similar to what is presented in this video. If we write apps script, we get full control on what we want to return, for example, we get birthDate as a field in response of API, but we want to return age as of today, we can easily do that using our own apps script. Hope that has answered the question.

​@ApplyIT2021 ok thank you very much for answering me however I'm not sure I understood correctly, can you say that the reason why I can't import the title from public RUclips video is because of the format? but I think I understood that I can do it with an api key? and otherwise I would like to ask you something else more generally about APIs and no code software and custom GPT Do you use no code software like make? In fact I'm asking myself questions to try to understand the differences between custom GPT, chrome and WordPress extensions, automation software like browser automation studio and make I had an idea of ​​creating an SEO and image editing but I don't know how to go about it I thought of several solutions either with make or by creating a Chrome or WordPress plugin or by using a existing plugin but I don't think it exists to do what I want or even with a custom GPT seo: OK and what do you think about rank math? I understand that this extension allows me to scan my pages and find the keywords to replace, from my back end, have I understood correctly? And I also understood that this does not allow me to ask it to scan my entire website? I mean if I understood correctly it scans the pages but one by one and I have to do everything by hand? This is why I wondered if I could not create an extension to which I would give the URL of my website and have it scan all the pages and tell me which keywords to replace And I even wondered if I wouldn't be able to make a robot with custom GPT or even with no code software like make in the case where an extension wouldn't be able to allow me to do it, does this idea seem good to you? do you also create chrome or WordPress extensions? I'm asking you this question because I'm trying to understand what I could do with custom GPT, could I do more with a chrome WordPress extension? Does it exist or not and finally what more can I do with it? make compared to its other methods Amazon, jungle scout I would like to use the jungle scout api but at the moment I am looking into the subject of artificial intelligence and I realized that there are several ways to use APIs and so I would like to try first to understand what is the difference between using the jungle scout api in a dent custom gpt action and I realized that I can also use the JS api in a make scenario Could you tell me what the difference is, what could I get, using either of these two methods? And also with the Amazon API? I understand that Amazon has several APIs? Do you also sell on several marketplaces? could you give me your opinion could I send you an email

​@ApplyIT2021 ok thank you very much for your answer, I am a Total beginner, I don't know anything about code, you wrote "the important functions of Google Sheet do not allow you to read Jason data provided by an API" could you recommend some documentation and tutorials to read so I can learn more about this? and for the rest of your explanations it still seems very vague to me given my beginner level, do you have any tutorial to recommend to me so that I can understand in more detail a first example of what I would like to do, I would like to sell on Amazon, I would like to retrieve the history of my sales made on Amazon from their Sp API, do you know how I could do, could I do this with the API connector extension? could you explain to me what is the difference between this extension and what I could do with appscript? could I send you an email

Thank you for your suggestion.

Glad you liked it

That is a nice question. Regarding getting all time high price, you can find the solution in this video ruclips.net/video/u8tR5KfLgUw/видео.html. You can try out to adapt the solution in this video for getting date of all time high price. If time permits, I will try to make video on your problem.

New video on How to Get Dates of all Time High Price automatically ruclips.net/video/hzi9OvzMEhY/видео.html

So nice of you

You can use it. It is expected that at some point in your blog you should reference this video, in scientific term it is called citation.

@@ApplyIT2021 ok brother ❤️

The listing date can be retrieved using the following formula =IMPORTDATA("archives.nseindia.com/content/equities/EQUITY_L.csv",",","en_US") It is explained in the following video ruclips.net/video/3bmMUXF2oBg/видео.html

Thanks 🙏

Thank you for your feedback. Happy that it helped you!

Instead of all time high price, if you put your desirable price, then also the same sheet should work. You can try that.

If we set PATH of java/javac as environment variable, we can put any one (JDK 8 or JDK 18) at front. So always, javac from a specific version will be invoked. If you do not want to change this PATH variable everytime you switch from a project using JDK 8 to a project using JDK 18, or vice versa, you need some efficient solution, which this video provides. And change will be for CLI session, which we want as we want to use specific Java version.

For breakout of 52 week high, the following formula should work: =AND(ABS((N2-H2)/N2)<=C2 , H2>N2) We apply AND operator on two conditions: the second condition being today's price (H2) is above 52week high (N2) Let me know if it works.

It should be possible by taking image from Google Drive (with Drive API in App Scripts) and sending email as HTML email.

We can access only those values that are available on Screener without any login.

SIR AAPNE MERI REQUST PR VIDEO BNAYA BHUT BHUT THANKS AAPKA

Most welcome