#NOTION PORTFOLIO WEBSITE FOR FREE#
#NOTION PORTFOLIO WEBSITE INSTALL#
#NOTION PORTFOLIO WEBSITE UPDATE#

We will also go ahead and calculate the percentage of each stock for the portfolio with =H2 / SUM($H$2:$H$12). 🔄 We can use it to get the current price of our assets and keep it in sync with Notion!- Notion2Sheets 🔄 August 6, 2021

#NOTION PORTFOLIO WEBSITE FOR FREE#

GOOGLEFINANCE allows you to fetch current or historical securities information from Google Finance, including price, volume, market cap and more. 364 Share Save 11K views 10 months ago notion website collab How to make a Portfolio Website for FREE using Notion x Super from scratch in 10 mins by Ali Solanki. In Trend One Year we will plot a spark line with the last year of pricing information for the specific asset, the formula looks like this =SPARKLINE(GOOGLEFINANCE(C2, 'price', TODAY() -365, TODAY())) and for Current Price as the name indicates, the current market price of the asset =GOOGLEFINANCE(C2, 'price'). I have added the links to the documentation for each if you want to take a look. Option 1: Traditionally, you can self-host your portfolio on a CMS like WordPress, Squarespace or Ghost: The upside: You will have your very own, professional website with custom URL to link to when submitting your design portfolio and perhaps for use on printed materials like business cards. We will use two handy formulas that are available in Sheets, =GOOGLEFINANCE() and =SPARKLINE(), one to fill the Current Price column and the other to show a trend line in Trend One Year. The first thing we are going to do is to add a new column, Trend One Year. Having the data available in Google Sheets will allow us to do two nice things, create charts and add additional information like the current price and the percentage of each investment.

#NOTION PORTFOLIO WEBSITE UPDATE#

Now we have the table in sync with Notion, records will be updated every 6 hours or you can update them manually when you want. Now we can clean the table a little bit, hiding Created, Updated and Page ID and reorder the columns. You can also change the names of the headers as well. We can hide and move columns if we want and the sync process will still work as each column is uniquely identified. Remember to select the page when giving permissions.įor step by step details please take a look at the next Youtube video:

#NOTION PORTFOLIO WEBSITE INSTALL#

Install Notion2Sheets and connect the workspace that contains the template you’ve just duplicated. If no, but you are still curious about how to keep your Notions databases in sync with Google Sheets, create charts and use Sheets formulas with your data, then you are welcome to continue reading.įirst thing first, duplicate the Stock Template in your Notion account. Why should you go with Notion if there are hundreds of website builders that can host your website or portfolio Notion is completely free to use. If yes, then your are in the right place. Have you ever wanted to have up to date prices of your investments in Notion? Or maybe a chart that is synchronized with your data?

Notion portfolio website