I have that already but couldnt figure out how and where to enter the details there. Because the API I get from my account is not a link. It`s a 50 digit code and there is a secret also.
If you know how to do it, could you please explain me?
What you have is not the "API"... what you have is the "API Key"... you call the API via a HTTP POST call using a URL. For instance, here is the API documentation for Poloniex... they have both Public and Private APIs... Public example: https://poloniex.com/public?command=returnTickerTheir Private API is quite different: All calls to the trading API are sent via HTTP POST to https://poloniex.com/tradingApi and must contain the following headers: Key - Your API key. Sign - The query's POST data signed by your key's "secret" according to the HMAC-SHA512 method. Additionally, all queries must include a "nonce" POST parameter. The nonce parameter is an integer which must always be greater than the previous nonce used. All responses from the trading API are in JSON format. In the event of an error, the response will always be of the following format: {"error":"<error message>"} There are several methods accepted by the trading API, each of which is specified by the "command" POST parameter:So you need to setup a data source in Excel that creates the HTTP POST call, feeding in a "Key" parameter (ie. your 50 digit code), the "command" parameter (which are specified in the list on that page) the "nonce" value and then the "Sign" parameter which involves creating an HMAC-SHA512 of all the "POST" parameter data you've just created. Obviously, all the different exchanges use slightly different APIs but in general work on a similar process. This guy was doing something similar with limited success: https://www.reddit.com/r/excel/comments/2ex0vh/http_post_api_request_using_power_query/Possibly the same guy: https://www.mrexcel.com/forum/general-excel-discussion-other-questions/745134-web-api-access-sha-512-authentication.htmlThis link shows some of the API specific stuff: https://www.howtoexcel.org/power-query/how-to-access-a-json-api-with-power-query/I think the issue will be generating the HMAC-512 that a lot of the exchanges require... Excel doesn't handle that stuff natively... and will require some VBA coding etc. It might actually be easier to execute a python script to extract the data from the Exchange API and dump it out to a JSON file and then just read the JSON file into the Excel sheet, seeing as there are numerous python scripts that already exist for most of the popular exchanges. Thank you very much for the detailed answer. Awesome help! I`m looking for the binance account info so I checked out their api doc information on their github page. There`s really good info there but it doesnt say anything about how to import it to excel. I shouldn`t need to write a code to import the data. Because when I need to import something from a public api, I just enter the link and it gets the data. I`m already using power query and that`s how i connected to public apis but I just dont know how to do it for private apis. I`m not good with coding so I was trying so hard to avoid it and just import the info somewhere then see the data on the sheet. I`m sure you already understand what I`m looking to accomplish but Just to give you an example of what I need, Check out this guys excel sheet. https://www.youtube.com/watch?v=kPLCsKAG57g |
|
|
|
Thank you for trying but I dont think you read my post completely. I know there are already ways to import public data like that. I`ve looked it up everywhere and saw many examples. But what I need is importing the private data. Like my account balance in Binance to a specific cell. When there is a private api there is also a secret. Plus the api is not a link but 50 digit code. So this is where I`m confused. Do you know how to import private data from an exchange to excel? I have that already but couldnt figure out how and where to enter the details there. Because the API I get from my account is not a link. It`s a 50 digit code and there is a secret also. If you know how to do it, could you please explain me? |
|
|
|
|
I need to auto-import my account balance to my excel tracker.
So is there anyway I can import the account balance from like Binance, HitBTC etc to a specific cell in excel sheet? and it will auto update the content as well
I found few sources for this but they`re all using public APIs instead of private APIs to get the information from.
|
|
|
|
|
I have bunch of VGA monitors around the house and I`d like to use each of them as different (extended) monitors for my laptop to increase productivity. All the monitor docking stations I`ve seen has only one VGA drive and maybe one HDMI drive.
Anyone knows a monitor docking station with multiple VGAs and multiple HDMIs ?
|
|
|
|
I`m starting my own crypto investment company and so far based on my research s-corp made the most sense. At least tax-wise. But I`m not sure where to register the business. I`m not really going to have customers nor I need a physical office/store. I do my own investments (bots, arbitrage, day/swing trading etc.) and make money. Some say Delaware or Wyoming or S. Dakota are the best for some privacy or tax reasons for an s-corp but I`m not sure as this is going to be my first business ever registered 
So I`d greatly appreciate if someone can give me some business advice on this. Thanks |
|
|
|
A few hints/ideas:
- cron runs as its own user with its own ENV, so $PATH etc differs from other users
- try running it in cron as your own user (kullanici)
- cd into your homedir before trying to start the bot since it seems unable to find modules ("No module named Trading")
- set the directory for the modules (PYTHONPATH or sys.path.append) Thank you. Will try... If you know someone who is good with Linux, let him have a look directly at your system. It's hard to debug something if you cannot do anything yourself.
Only let that do someone you really trust and look over his shoulder to see what he is doing at any time.
That`s the reason I`m writing here instead of getting someone to look at my screen. I kinda have to do this all by myself but I keep getting smashed on my face, get up and try again |
|
|
|
You can't save the positions and everything, but you could make some things to open when you restart.
Go to System > Preferences > Startup Applications, click the Options tab, and check the checkbox reading "Automatically remember running applications when logng out". You can also set the startup programs manually on the "Startup Programs" tab.
I think you just googled it which I did before I write here also. This doesnt work for Debian. I don`t see any preference page or the options you said above. So I found this https://github.com/johannesjo/linux-window-session-manager which seems pretty good and would probably do what I need. But it keeps giving errors and doesn`t restore everything correctly. |
|
|
|
Sounds like you're talking about hibernation. It's not quite a full reboot, but basically during hibernation the computer saves everything in memory to the hard disk, then shuts down. When it powers back on, it loads the saved data back into memory and the computer is just like it was before hibernation.
Will that count as a reboot to finish up the installations of some softwares? I just want the same windows to be in the same exact spots in same exact workspaces when I reboot. The applications doesn`t even matter if they run or not but like firefox will be open on the same spot next to the notepad on the corner of the pages etc. |
|
|
|
|
How to save all windows (locations, sizes) and open applications in all workspaces before a reboot in Linux?
I have bunch of terminals, browsers and windows open in multiple workspaces. But everytime when I have to reboot the computer I have to start again to setup them all up again
So I need a solution to automatically save all window sizes and locations, plus the open applications (Ie. firefox) and automatically go back to how it was before the reboot.
|
|
|
|
|
I did. That`s why I tried that crontab command first. I did a lot of research and tried multiple commands but none of them worked for me. I know I`m a n00b and I shouldn`t ask for the basics but believe me I really research these things before I come here and ask for it.
That`s why first I tried to put the file in the cron.hourly folder and it didn`t work. Then I tried to run it from there and it didn`t work and then put the crontab command and it still didn`t work. Please don`t think that I`m looking for the basic and easy to find info here.
|
|
|
|
|
No. I was running it from it`s destination. I have never put anything in cron before and I checked it out but couldn`t get it to work when I write
crontab * * * * * /home/kullanici/restart_script.sh
It says app: Not a regular file
|
|
|
|
|
I`m so close to succeed in this solution right now, I don`t want to start another way to do this now to be honest.
|
|
|
|
Ok I`m having a problem now. Below script I got it saved in /home/kullanici/restart_script.sh #!/usr/bin/bash
if [[ ! $(pgrep -f "python /home/kullanici/bot.py --wait_time 0.2 --stop_loss 0") ]]; then
echo "Bot down"
python /home/kullanici/bot.py --wait_time 0.2 --stop_loss 0 &
fi So when I go to terminal and write bash /home/kullanici/restart_script.sh it runs perfectly. But when I put that file in /etc/cron.hourly/ it doesn`t run it. I also went to terminal and wrote bash /etc/cron.hourly/restart_script.sh and it doesn`t run like that either. It says root@debian:/etc/cron.hourly# Traceback (most recent call last):
File "/home/kullanici/bot.py", line 9, in <module>
from Trading import Trading
ImportError: No module named Trading |
|
|
|
|
I`m looking for an accounting software like quickbooks or quicken but they charge about $50 a month and there are bunch of tricks with their marketing tactics. So I don`t really trust them.
Is there a good free/afforadable accounting and bookkeeping software I can use to log my company things? We`re a small startup who`s trying to squeeze every penny from these kind of expenses
|
|
|
|
|
Got it. It was in an "Change Address"
I really don`t like this change address thing so far
|
|
|
|
|
How come? I had 51 LTC and I sent 40 of them somewhere and didn`t even touch the rest.
Is there anywhere I can check to see if I had any LTC in my wallet at a exact particular time? Maybe it was in another wallet or something
|
|
|
|
|
Can someone please help me? I had 10 LTC in this wallet during the fork. But when I import the priv key to the node it doesn`t give me any litecoin cash... LTJ3JPPjDCx5YS45Rb9Arei6jTCusNJYDM
|
|
|
|
|
Alright. After testing it for few days. Here`s the result.
You`re right. I have to add it to the cron job because bot just stops sometimes. But I realized that sometimes the bot just stops however it doesn`t go back to command line. It just freezes. So can you add a line in the code where it will restart the script if it just stops or if it just sees a specific line in on the terminal while running?
Like
If "LINE LINE LINE" appears on the terminal page while running
Stop the script, go back to the command line and restart the script again with the same command it did before
|
|
|
|
It worked perfectly like below. But I have couple questions 1- Does this script checks the code every some time? because I see my script is running but then once every minute or so I see one more of the same python process goes on the list for couple seconds and then disappear. 2- I didn`t need to add it to cron job because when I run your code, it checks the script and can`t find it so It starts it and when I cancel it, it restarts it again. So as long as your code runs, the script keeps running no matter what. Is that normal and should I still add the .sh file to the cron job? #!/usr/bin/bash
if [[ ! $(pgrep -f "rtgferfd.py") ]]; then
echo "Bot down"
python rtgferfd.py --solid --r --fr --quantity 35 --wait_time 34 &
fi |
|
|
|
|
Please read the topic better. I`m not buying. I`m selling. Just like you
|
|
|
|
|
Show Posts
