Feature request - bulk import of price in Custom Assets

Q&A
1

Hi Evan, would it be possible to have a feature to do bulk import of prices in custom assets? Some ways this could be done:

  1. Form input for multiple dates and prices.
  2. Import of CSV or XLSX file

Currently we can only input prices one by one, which is quite tedious.

2

Hi there,

There is already a way to do that via JSON. e.g. https://stocks.cafe/stock/to_add_eod_via_json?exchange=CA&symbol=AIASG24

You can go to this page from the Custom Asset page → Prices tab then on the top there is a Add Prices via JSON.

Cheers,
Evan

3

Hi Evan, that only works if it is a fund available on Tiger Brokers, isn’t it?

4

Yes and no.

If it is available in Tiger then you can do it easily. If not, you just have to make it to be in the same format.

5

Thanks Evan. I sort of figured it out a way to do bulk update using this method by taking a screen capture and asking ChatGPT to generate the json. I guess that will do for now.

1 Like
6

Do share so that others can also learn?

7

I took a screenshot from the historical nav price on the fund manager’s page and asked ChatGPT to write the JSON in the format you specified.

image
image1534×2032 304 KB

8

Created a Custom GPT to perform this task repeatedly in future. :grin:

9

Nice. Can I share this link on that page and credit you?

10

Sure. No problem.

1 Like
11

I have modified the GPT. It can accept images, text and CSVs to generate the JSON.
NAV Extractor (Image · Table · CSV → JSON)

1 Like