Learn how to Create Index charts in Excel to compare data

#excel #charts #visulisations

In this video, you will learn how to create an Index chart in Excel. An index chart is a great chart to compare trends against different sets of data. In this video, we will compare the price movement trend of four popular cryptocurrency prices. You will see how using a standard line chart can make it difficult to see similar patterns and trends between data sets and how using an index chart you can overcome this.

learn more about the stock history function in Excel

learn more about data types

Connect to coinmarketcap API

Index Charts, Part 1: Making Time Series Data Comparable

[AllenAnand]

ABSOLUTELY SAVED YOU SO MUCH FOR YOUR EFFORTS 😇🤗

[lukeyb]

You saved my assignment, you're the best.

[financebr]

TY!! HELPED ME A LOT, im applying for an internship and one of the tastks that ive made i used your video. literally saved me.

[pedrocotta]

Excellent video, Paula. This is exactly what I was looking for. Thanks.

[aslihanakar]

I think it's a great way to visualize. May be we can use logarithmic scale to see the others, too.

[mbasurtos]

Beautiful accent! Thanks for the video!

[ramanbansal]

good... very good... video... very easy to understand... thanks..

[shabanshah]

Thank u mam! I really want to learn with u. Very helpful.

[IamXAbhi]

Thank you. How to create, displacements and load with multiple samples

[wayneedmondson]

Hi Paula. Very interesting analysis and charting technique. Will come in handy. Thanks for sharing it :)) Thumbs up!!

[lrvxkrv]

Hi Paula, great video thanks, very clearly explained. Is there a way to create an adjustable timescale across this data? i.e. one that re-indexes to 100 from whatever start date you choose?

[paulmacharia]

Hey Paula thanks for the video..can you do one of creating a seasonality index for bitcoin for the past 10 years... love from🇰🇪

[tommyharris]

How do you convert the 100 base value to 0%?

[homerdus]

would you like to make one excel
that compares two wallets how the are performing including
- summarizing daily performance of a trading transactions (crypto pairs) during x months
- showing/comparing trend of wallet1 and wallet2
- in USD

there can be several transactions per day, so all transactions during a days have to summarized and all converted to USD (that day value)

- transaction data can be imported from Exchange (e.g. Binance ),
- crypto valuations from yahoo finance (if there is older excel in use)

trick is really optimally combining data from two wallets and comparing their performance.

[aksingh]

thanks for the video .i was wondering if we can create an index or portifolio of stocks which records the value of the portfolio every end of day ?