Cloud Notes

Market data, Trading, Technical support, Features requests, etc
david caliano
Posts: 12
Joined: Sat Dec 18, 2021 3:35 am

Cloud Notes

Post by david caliano » Tue Mar 01, 2022 1:57 pm

I'm trying to get data from another program into Bookmap through Cloud Notes.
I loaded the URL and it just says "loading" .  
Could someone tell me what I am doing wrong?

AndreyR
Posts: 458
Joined: Mon Jul 09, 2018 11:18 am
Has thanked: 18 times
Been thanked: 71 times

Re: Cloud Notes

Post by AndreyR » Tue Mar 01, 2022 2:31 pm

Hi David,
we need details to figure it out. Your log would be very helpful.
Also:
  • data from another program - what kind of program?
  • does it produce data compatible with Bookmap?

david caliano
Posts: 12
Joined: Sat Dec 18, 2021 3:35 am

Re: Cloud Notes

Post by david caliano » Tue Mar 01, 2022 4:56 pm

I figured it out.  Had to put the excel file in the Bookmap format then upload the 
file to Google Sheets then publish from there.

david caliano
Posts: 12
Joined: Sat Dec 18, 2021 3:35 am

Re: Cloud Notes

Post by david caliano » Tue Mar 01, 2022 8:14 pm

The file I have from IRT is updating every ten seconds with new price levels.
For example, the daily high and low.  When the market makes a new low the 
price changes automatically in that excel file.  When I go to upload this file
to my google drive and open it in google sheets in order to publish it so 
it can be read in Bookmap, the price levels show up when I create with it
a cloud column.  But the levels don't update along with the excel file from IRT.
How do I get the levels to automatically update in Bookmap?

Svyatoslav
Site Admin
Posts: 242
Joined: Mon Jun 11, 2018 11:44 am
Has thanked: 2 times
Been thanked: 29 times

Re: Cloud Notes

Post by Svyatoslav » Wed Mar 02, 2022 10:56 am

First of all, all those uploads to google drive, one drive, etc., are not really an official way to use the CloudNotes functionality. It's just a trick to get a direct link to a file without spending much effort. What bookmap app itself does - it just expects a link to a file in certain format, as described in https://bookmap.com/knowledgebase/docs/ ... escription
It does not really care where that link comes from. Bookmap can not read the excel file (xls) - it only reads CSV (btw, important to keep in mind that it actually has to be a CSV, not SCSV or any other variation - say Excel does not always respect the CSV format specification).
So, regardless of how you get the data, what you need to do is either:
- (better) have some URL where the relevant version of a file is available. That can be your own server (including the one running locally on your computer) or any other source, as long as it follows the specification
- (worse, and that will probably fail from time to time) write changes to a CSV file on your computer and specify this file as a URL using file:/// format. I'm saying it's worse cause in certain cases bookmap might not fully close such file and this will prevent your scripts from writing into it. You can however use any primitive http server to make it available via HTTP locally, that will solve the issue.

AndreyR
Posts: 458
Joined: Mon Jul 09, 2018 11:18 am
Has thanked: 18 times
Been thanked: 71 times

Re: Cloud Notes

Post by AndreyR » Wed Mar 02, 2022 11:07 am

david caliano
If you need a server example in Java please check this thread

david caliano
Posts: 12
Joined: Sat Dec 18, 2021 3:35 am

Re: Cloud Notes

Post by david caliano » Wed Mar 02, 2022 1:22 pm

I have no idea how to go about using java.  
Will it work going the OneDrive route like it says
in that link ?

Svyatoslav
Site Admin
Posts: 242
Joined: Mon Jun 11, 2018 11:44 am
Has thanked: 2 times
Been thanked: 29 times

Re: Cloud Notes

Post by Svyatoslav » Wed Mar 02, 2022 1:34 pm

You will have to manually convert the data from whichever format you have into bookmap format in order to do that. If you go that route - you don't even really need to upload it to the server. If the file is on your computer - you can specify the file location using file:/// protocol (e.g. file:///c:\my-folder\my-notes.csv )

david caliano
Posts: 12
Joined: Sat Dec 18, 2021 3:35 am

Re: Cloud Notes

Post by david caliano » Wed Mar 02, 2022 1:53 pm

That would be the URL I would put into Bookmap under under the Settings for the Cloud Notes column?

C:\users\dcali\documents\ED_Output.csv

That's the location on my computer.  

Svyatoslav
Site Admin
Posts: 242
Joined: Mon Jun 11, 2018 11:44 am
Has thanked: 2 times
Been thanked: 29 times

Re: Cloud Notes

Post by Svyatoslav » Wed Mar 02, 2022 2:04 pm

Yes. It would be file:///C:\users\dcali\documents\ED_Output.csv

Post Reply