u/Big_Bull_2400

Confused between these two. Which one would you buy?

Could anyone assist with a formula to select the most recent date for which the stock price is available? I attempted the approach below, but it yields no result.

=INDEX(GOOGLEFINANCE("NSE:HDFCBANK", "date"))

Is this a good deal or is there further scope for discounts?

I asked the dealer to include only ex showroom, registration, insurance and RSA of some 3,000 rupees.

It came up to 10.4 lakhs and they offered me 9.4 lakhs.

I have shortlisted below cars:

1. Hyundai i20 Sportz (O)
2. Honda Amaze VX CVT
3. Baleno AGS
4. Punch EV Empowered 40 kWh
5. Nexon EV 45 Fearless 45 kWh

My monthly usage can be 1000 km as of now (just an estimate) who knows it could be lower or higher and 70% drive could be in city. As of now there's no charging setup at my home or the place i rent in another city. So probably 50% of the time it would be public chargers.

I personally love the i20 because of its looks, premium build fit and finish and interiors. But mileage is a concern too. Can't bear 7-8 kmpl. That's why baleno is an option.

Was considering EV to save fuel expense. It feels like compromising on Punch and maybe spend more and get the Nexon.

I was leaning to spend not more than 10 lakhs but feel that to get some flexibility towards EV as it would save my fuel expense and that would manage the additional EMIs.

Edit:

I am now leaning towards baleno alpha ags, i20 sportz ivt, amaze VX CVT and nissan magnite AMT N connecta.